hey all, as the subject line says, is there a way to read and write to an Access database (.mdb) via applescript in either OS 9 or OS X? I want to develop a system in which mac and pc users can share information on a local network. On the PC i’ll have a visual basic form read and write to the mdb file but i’m not sure applescript can do this. If not, is there another database that can be read by both AS and VB? How about via realbasic? AS and VB read and write to excel files, but that would be a reeeaaaallll pain in the butt.
thanks a bunch.
Both PC & mac users must read/write the same doc?
As long as I know, it doesn’t exists Access for macintosh… Perhaps you could try Filemaker, which will work on both platforms. Or, if you have an extra computer, you can set up a local web server and make the people manipulate the database from a web interface… You can do it via windows-asp/vb-access or mac-cgi-applescript (for example).
Also, Filemaker has a plug-in which will share databases through a web inteface… (Doesn’t have Access a similar feature?)
And, if you’re not talking about tons of data, you could also write a “simple” Studio app & store the data in a plain text file…
Some thoughts…
Hi,
you could develop an application using REALbasic. The PRO license has three features that are important here:
- it is a RAD with a GUI builder (ALL licenses)
- it can generate Windows application, too (PRO license)
- it has a database engine (PRO license) or can connect to other databases
The database is single user, which means that only one person at a time can make modifications. The database itself is in a cross-platform format which means that it can be shared among Mac’s and PC’s.
REALbasic applications can use AppleScripts and can be made scriptable.
REALbasic has a plugin architecture so independent developers can add features.
Regards,
Eddy Walet
PTH
here another possibel way. SQL Plug in for Filemaker. So you can develop a filemaker solution and write ore read fields, columns ect. to Access.but it´s IT Pro stuff.
If you can rule the PC zombies choose Filemaker on both Plattforms.