Re: [Gambas-user] Microsoft Access database

2013-08-13 Thread Caveat
Hi Ivan Ready to take another look at converting your multi-user database (ahem! SINGLE USER FILE!) to a proper dbms? :-D I did also look at mdbtools and the like before rolling my own conversion tool but nothing worked particularly well... I ended up with some fugly combination of awk, sed, g

Re: [Gambas-user] Microsoft Access database

2013-08-13 Thread Randall Morgan
This is true, You should not change your access database while connecting to it via ODBC. Also, you may find some queries don't work as expected. Again, Access looks like a T-SQL database but is not really. It would be best to use the ODBC connection to update a local MySQL or Postgres database on

Re: [Gambas-user] Microsoft Access database

2013-08-13 Thread Rob Kudla
On 2013-08-13 09:31, Bruce wrote: > a) MSAccess did/does not run as a server process, especially to remote > machines. In order to get it to that we had to use ODBC and establish > a connection process on the "server" and similarly an ODBC client on > the remote "client" machine. In the case of a

Re: [Gambas-user] Microsoft Access database

2013-08-13 Thread Bruce
On Tue, 2013-08-13 at 14:57 +0200, Ivan Kern wrote: > I thank you all. > > I'm running MS Access on the remote machine and I need actually connect to > MS access. > I still have no solution. > > Kind regards, > Ivan I am grasping at the thin straws of memory here, but for what it's worth. I use

Re: [Gambas-user] Microsoft Access database

2013-08-13 Thread Randall Morgan
: Dienstag, 13. August 2013 00:11 >> An: nand...@nothingsimple.com; mailing list for gambas users >> Betreff: Re: [Gambas-user] Microsoft Access database >> >> Some ideas... >> >> Are you running MS Access on the same system under wine? Or on a remote >> mac

Re: [Gambas-user] Microsoft Access database

2013-08-13 Thread Randall Morgan
ienstag, 13. August 2013 00:11 > An: nand...@nothingsimple.com; mailing list for gambas users > Betreff: Re: [Gambas-user] Microsoft Access database > > Some ideas... > > Are you running MS Access on the same system under wine? Or on a remote > machine? Do you need to actually conn

Re: [Gambas-user] Microsoft Access database

2013-08-13 Thread Ivan Kern
nand...@nothingsimple.com; mailing list for gambas users Betreff: Re: [Gambas-user] Microsoft Access database Some ideas... Are you running MS Access on the same system under wine? Or on a remote machine? Do you need to actually connect to ms access or can you import the access database in to MySQL or Pos

Re: [Gambas-user] Microsoft Access database

2013-08-12 Thread Randall Morgan
use something on a box a while back. > (sorry forgot what is was) > > > -- Original Message --- > From: Caveat > To: gambas-user@lists.sourceforge.net > Sent: Mon, 12 Aug 2013 14:26:54 +0200 > Subject: Re: [Gambas-user] Microsoft Access database > > > N

Re: [Gambas-user] Microsoft Access database

2013-08-12 Thread nando
To: gambas-user@lists.sourceforge.net Sent: Mon, 12 Aug 2013 14:26:54 +0200 Subject: Re: [Gambas-user] Microsoft Access database > Not that I know of, but I have written a system to convert MSAccess > databases to MySQL/postgresql/MSSQLServer. It's written in java and > uses th

Re: [Gambas-user] Microsoft Access database

2013-08-12 Thread Randall Morgan
I would think you should be able to use the ODBC component to connect ot MSAccess? Check this out: http://office.microsoft.com/en-us/access-help/administer-odbc-data-sources-HA010275550.aspx And this: http://gambasdoc.org/help/doc/odbc?en&v3 On Mon, Aug 12, 2013 at 5:26 AM, Caveat wrote: > No

Re: [Gambas-user] Microsoft Access database

2013-08-12 Thread Caveat
Not that I know of, but I have written a system to convert MSAccess databases to MySQL/postgresql/MSSQLServer. It's written in java and uses the jackcess library (http://jackcess.sourceforge.net/). I also wrote a server which makes calls to the jackcess library based on simple text commands, s

[Gambas-user] Microsoft Access database

2013-08-12 Thread Ivan Kern
Hi, Is it possible to connect Microsoft access database with Gambas? If yea, please, an example. Best regards, Ivan -- Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free troubleshoo