Page 1 of 1

connecting to remote MS Access database

Posted: Fri Apr 22, 2005 10:11 am
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.

Posted: Fri Apr 22, 2005 10:14 am
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

Posted: Fri Apr 22, 2005 10:28 am
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.

Posted: Fri Apr 22, 2005 10:31 am
by malcolmboston
access was not designed for this