Connecting to Aceess databse on the server

[man_luck]

Hi,

I want to connect to an Access database on the server and not on my local machine.I dont know how to achieve this.I am able to connect to the database on local machine ,both in access ans SQl server.Moreover when I use VB.Net,I am able to establish connection to SQL Server on the server and results displayed in a DataGrid but same thing is not achieved when I try to use ASP.Net.......................it gives the error :- "Login failed for user 'THINK\MANISH$'." where THINK is my local domain and Manish is the name of my computer on this domain.

 

Does the code differ in VB.Net and ASP.net when we use SQL Server on another machine?And how do I establish connection to an Access database on some other machine?

[steo]

Chances are the location of the database is different. You have full rights I'd imagine on your local machine so oermissions etc. wouldnt matter.

 

Double check that the access database has no password. Contact yoru host and ask for the location of the folder where your database is. Check that against your code.

[CzechMan]

I don't think you can connect to Access on one machine from another machine. You can do that with MS SQL since it allows remote connection but not with Access.

[bungpeng]

Not sure whether it can solve your problem, you can try:

 

Share Access file from server with Share permission and security are full control to 'everyone' and 'guests'

 

Tips: You can browse your access database through network, the make sure the path is valid