accessing database on network drive?? 1

[arneweise77]

Hi!

I´m accessing an Access-database from my asp.net page with OleDb and it works find as long as the databasefile is on the local machine but I need the file to be on a network drive. I´ve mapped up the drive to g: and got permission to access my database file. But when I run my app the this exception occurs:
The Microsoft Jet database engine cannot open the file 'g:\access\robot\tabort.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
The file is certainly not opened by another user and permission to file is should be ok because if I copy to a local drive it works find. My Trust level is set to full, but it doesn´t help.

Hope somebody can help me!!
Arne

 

[netangel]

Check if the remote machine's folder has write premission for ASPNET user. When you open an access database file, it creates a '.ldb' file to hold the current users.
If u don't have premission to write or change that file, u can't use the database.

ATTENTION: The ASPNET user needs the premission, not your current loged user.

Hope this hepls NetAngel