[Wolves] Micro$oft Access DB

[Re-LoaD's LUG Mail]

A BIG !! Thanks for pointing me in the right direction :)

I exported all the data from access tables, created a database in mysql on
one server.
users can search the data from a php webpage on the web server.

Its only a small database but I think I have the basics.

Thanks Again

Re-LoaD

...........................................
----- Original Message ----- 
From: "Chris Procter" <Chris at foxonline.co.uk>
To: "'Wolverhampton Linux User Group'" <wolves at mailman.lug.org.uk>
Sent: Tuesday, January 27, 2004 3:23 PM
Subject: RE: [Wolves] Micro$oft Access DB



In Access right click on the tables window and you should get 'Link tables'
as an option and you can link to a table in a remote odbc database, it
should then work entirely as normal but using Access as a front end and
connecting remotly for its data. That will be the easiest thing seeing as
you already have it working.

A web based front end will take (a lot) more work to get set up but can then
be accessed from any pc with a browser (one less windows specific app in the
world!) and probably more flexable in the long run. There must be loads of
tutorials on this on the web, if you know HTML/SQL/Perl its not that
difficult, just long.

chris




-----Original Message-----
From: David Goodwin [mailto:david at openminds.co.uk]
Sent: 27 January 2004 15:02
To: Wolverhampton Linux User Group
Subject: Re: [Wolves] Micro$oft Access DB


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.

_______________________________________________
Wolves LUG mailing list
Homepage: http://www.wolveslug.org.uk/
Mailing list: Wolves at mailman.lug.org.uk
Mailing list home: http://mailman.lug.org.uk/mailman/listinfo/wolves


**********************************************************************
Any opinions expressed in this email are those of the individual
and not necessarily those of Fox Online.
This email and any files transmitted with it, including replies and
forwarded copies (which may contain alterations) subsequently transmitted
from Fox Online, are confidential and solely for the use
of the intended recipient.
If you have received this email in error please notify Fox Online by
telephone on +44 (0)121 693 1424.
**********************************************************************


_______________________________________________
Wolves LUG mailing list
Homepage: http://www.wolveslug.org.uk/
Mailing list: Wolves at mailman.lug.org.uk
Mailing list home: http://mailman.lug.org.uk/mailman/listinfo/wolves