homepage Welcome to WebmasterWorld Guest from 54.197.147.90
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
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.
Tom_58




msg:663961
 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.

 

Xoc




msg:663962
 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




msg:663963
 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.

jatar_k




msg:663964
 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

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>

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