connecting to remote MS Access database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mcog_esteban
Forum Contributor
Posts: 127
Joined: Tue Dec 30, 2003 3:28 pm

connecting to remote MS Access database

Post by mcog_esteban »

hi, like the title says, there's any way i could connect to ms access database that is on another machine?

thanks.
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

using ODBC

edit: by the way, MS access is horrible at handling multiple connections if this is going to be a site that is fairly busy use one of the other database systems
mcog_esteban
Forum Contributor
Posts: 127
Joined: Tue Dec 30, 2003 3:28 pm

Post by mcog_esteban »

yep..i know most of that ...i was looking for an answer and i found this on a forum "There is no way to access a remote MS-Access Database over the internet. Try
to switch to mysql or any other database system which is *not* designed for
desktop access only."

i have a conf text file, which describes the connection, i though i could just change the server location, login, pass and db location and everything would run ok...guess not, now.
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

access was not designed for this
Post Reply