[Wolves] Micro$oft Access DB

David Goodwin david at openminds.co.uk
Tue Jan 27 15:01:50 GMT 2004


Re-LoaD's LUG Mail wrote:
> Hi All,
>     I'm after some help please.
> We have here at work an access data base about 18MB in size, currently if a
> user needs to use said data base he/she just opens the file over the novell
> shares.
> This basically transfers the whole file to the local machine, Not very quick
> and some users don't even have access to the correct share.
> Ok what I have been asked is can this data base be held on a central server
> with a web based front end ??
> now I know nothing about data bases / access and very little about web based
> front ends.
> 
> Can any one point me in the right direction, a place to start. Can access
> data bases be converted into other formats ?
> I do have Mysql, apache, perl, etc installed on my Linux servers what I
> would like to do is hold the data base on one server ( this is my main
> store )
> and run web queries from the web server.
> 
> Thanks in advance
> 
> Re-LoaD

Yes, you should be able to export the data into e.g. MySQL or PostgreSQL 
and then using an ODBC connection use Access as a front end for the 
database. I'm pretty sure I've done a similar thing before, but not 
recently.

You should find the following useful...

http://mdbtools.sourceforge.net/

thanks

David.



More information about the Wolves mailing list