integrating Access Database w/ website

[kgarner]

I know, i know, but the client works with Access. Any helpful articles on using Access databases in a website. I am a little famiiar with how to do it with MySQL, but no clue where to start for Access.

[angelneo]

I know, i know, but the client works with Access. Any helpful articles on using Access databases in a website. I am a little famiiar with how to do it with MySQL, but no clue where to start for Access.

its better to use ASP for it. I googled for some links
http://www.webwizguide.com/asp/tutorials/default.asp
http://databases.about.com/library/weekly/aa011401a.htm

[tomf87]

An easier idea, if you know how to do it all in MySQL, is to setup some sort of replication from Access to MySQL. Or you could modify Access so it updates the data into MySQL immediately.

Just an FYI, which you probably already know, any little load on the website will cause Access to slow down considerably.

[kgarner]

Thanks for the advice guys. I think that I will try the import into MySQL route. It seems to offer the best solution to my predicament. Thanks again.

[davecuse]

I actually ran into a pretty similar situation, my supervisor forced me into using MS-SQL. There are actually some pretty handy tools for for migrating data between an Access DB and MySQL. I begged him to let me use MySQL but in the end darker forces prevailed... I would google exporting access tables to mysql. Or to appease the MS crowd, you could even talk up MS-SQL, which in all fairness is reasonably decent.

[tomf87]

I actually ran into a pretty similar situation, my supervisor forced me into using MS-SQL. There are actually some pretty handy tools for for migrating data between an Access DB and MySQL. I begged him to let me use MySQL but in the end darker forces prevailed... I would google exporting access tables to mysql. Or to appease the MS crowd, you could even talk up MS-SQL, which in all fairness is reasonably decent.

It's expensive too, though, to take the MS SQL Server route.

[kgarner]

It's expensive too, though, to take the MS SQL Server route.
Yeah, that's why I think I will take the export to MySQL route. They just need to have those databases available online to run some reports, so it shouldn't matter what they use. I just wasn't sure if that was an option for Access at first.

[tomf87]

Access could probably handle it until you get more than a couple of users running against it. I usually find that after people get one report, they want to add more data to it and work it in different ways. I think you are doing the right thing by using MySQL from the start. Better to do it right the first time.

[raytube]

Hi,
I've used Access to run some small scale sites and it's ok, but I would also recommend going over to MySQL, try out Navicat, www.navicat.com, if you use the windows version you can actually import straight from An access database into MySQL. I use it daily for all my database stuff. I don't think the OSX version of Navicat will let you import access databases though.
Other wise if it needs to be Mac check out the OS X Apps section on apple.com, there's a few utilities there that will let you import / export.
It tends to be that you need to do it on a PC if you want to work with the Access database directly though.

Cheers,

Rick

[kgarner]

Hi,
I've used Access to run some small scale sites and it's ok, but I would also recommend going over to MySQL, try out Navicat, www.navicat.com, if you use the windows version you can actually import straight from An access database into MySQL. I use it daily for all my database stuff. I don't think the OSX version of Navicat will let you import access databases though.
Other wise if it needs to be Mac check out the OS X Apps section on apple.com, there's a few utilities there that will let you import / export.
It tends to be that you need to do it on a PC if you want to work with the Access database directly though.

Cheers,

Rick
Thanks, I will check it out. I thought I read on some Access FAQ that you can export to an ODBC (?) database directly from Access. I will have to look around a bit more while I wait to hear if they are going to use me for this. But the info I have found will be very useful for future jobs I am sure.

[tomf87]

Found this:

DBTools
Free. Works with Access97, Access2000. DBTools actually is intended primarily as an application for administering MySQL, but it includes data import capabilities that can be used to read Access databases for transfer to MySQL. (It can also read data from other sources such as Excel spreadsheets, making it particularly useful for transferring to MySQL information that is stored in a variety of formats.) Because DBTools reads Access databases directly, you can use it to migrate Access tables even if you don't have Access installed locally, as long as you have the database files containing the tables to be transferred. DBTools does not require ODBC.

MySQLFront
Free. MySQLFront is similar in many ways to DBTools. It can read Access97 and Access2000 files directly. If ODBC is installed, MySQLFront can import information into MySQL from ODBC data sources over the network. (Unfortunately, MySQLFront development has ceased and it is no longer distributed by its author. However, you may be able to find it on alternate download sites by using a search engine.)

Courtesy of http://www.kitebird.com/articles/access-migrate.html#TOC_5