hi, like the title says, there's any way i could connect to ms access database that is on another machine?
thanks.
connecting to remote MS Access database
Moderator: General Moderators
-
mcog_esteban
- Forum Contributor
- Posts: 127
- Joined: Tue Dec 30, 2003 3:28 pm
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
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
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
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.
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