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