homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

Access Database on the Web
Need advice on the easiest way to put an Access DB on the web.

10+ Year Member

Msg#: 742 posted 3:27 pm on Feb 13, 2002 (gmt 0)

I have a client that has an existing Access database that is currently about 8 megs in size with about 8 tables and 200 fields. They want the DB on their website, with a password protected front end so their remote offices can make changes and additions- currently the people in the remote offices email their info to the main office and the changes/ additions are made there.

Although I have worked with flat file DBs and have some experience with MySQL, I've not worked with Access much.

What would be the easiest way to get data from Access into MySQL tables? The site is currently on a NIX server, if that makes any difference. I would probably use DBMan SQL, or a similar product for the front end. Thanks.



WebmasterWorld Senior Member 10+ Year Member

Msg#: 742 posted 4:04 pm on Feb 13, 2002 (gmt 0)

Use Access to dump the tables to text files. Use the import feature of whatever database you want to move the data. Text is the universal media.

BTW, if you use IIS, or anything else that can talk to an ODBC driver, you could leave it in Access and get the data directly into the database from the web site.

cyril kearney

10+ Year Member

Msg#: 742 posted 6:08 pm on Feb 13, 2002 (gmt 0)

Access can link tables, i.e. a local version of Access can link through an ODBC connection to many different databases on a server.

I don't know if this includes mySQL but it works with SQL Server, Oracle, Sybase and others. Data loading becomes a snap because you simple Export using a built-in capability of Access.

If you move the Access database (tne .mdb file) to the server, remember that the server needs to have Access installed on it to work properly.


WebmasterWorld Administrator jatar_k us a WebmasterWorld Top Contributor of All Time 10+ Year Member

Msg#: 742 posted 6:27 pm on Feb 13, 2002 (gmt 0)

you can export the access info to a csv file and then use the following sql command

INTO TABLE tbl_name
[ESCAPED BY '\\' ]

from mysql.com

Global Options:
 top home search open messages active posts  

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved