Welcome to WebmasterWorld Guest from 54.146.171.44

Forum Moderators: phranque

Message Too Old, No Replies

Access Database on the Web

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

   
3:27 pm on Feb 13, 2002 (gmt 0)

10+ Year Member



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.

Xoc

4:04 pm on Feb 13, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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.

6:08 pm on Feb 13, 2002 (gmt 0)

10+ Year Member



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.

6:27 pm on Feb 13, 2002 (gmt 0)

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



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

LOAD DATA [LOW_PRIORITY CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]

<added>
from mysql.com
</added>