Database Connection Problem

[razah]

I am able to connect to an access database on a local hard drive but unable to connect to one on a network drive.Does anyone know what the problem is?

[Guest Marius]

It could be multiple things, most likely the user you have is only allowed to connect trough localhost and it is therefore blocking the login attempt.You should post the error message you receive.

[Skemcin]

assumptions:a.) your database is on local drive [c]b.) you have the database and ODBC set up on your local machinec.) you have your web server (with scripting engine) installed on your local machineIn order to have, say drive [x] able to access the database, machine [x] must also have an ODBC set up that points to the ODBC set up on drive [c]. Depending on other things, you might have to have certain permissions set up was well - from machine to machine - in order to select, insert, update, and delete records (and tables).Throw in a web server on drive [x] and you can run a site/intranet off of drive [x].Hope this helps (and hope I got it correct)