Welcome to WebmasterWorld Guest from 54.147.63.124

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.

     

Tom_58

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

Inactive Member
Account Expired

 
 


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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Jan 18, 2001
posts:1437
votes: 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.

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

Preferred Member

10+ Year Member

joined:Aug 8, 2001
posts:493
votes: 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.

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

Administrator

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

joined:July 24, 2001
posts:15755
votes: 0


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>

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members