locked
Accessing an Access database on a network share. RRS feed

  • Question

  • User644103945 posted

    I was able to get access to the db but now whenever the db is opened by another computer/user I'm getting a user is being used error even if the db is opened in shared mode.

    Also when I am able to open the db and I'm the only user to have it opened I cannot do update queries and inserts just select queries.

    Is there something I'm missing?  Im checking the internet and looks like I need to setup the user to make sure it has access to read/write/execute/delete basically I've granted access on the db server for the windows user account all priviledges and still its giving me the file is in use error when another user has it opened, and when I do have it opened I cannot update/insert into db...please help.

    Thursday, July 11, 2019 8:01 PM

All replies

  • User753101303 posted

    Hi,

    Maybe the permission is wrong at the network share level ? Note sure if related to ASP.NET. I would away from Access for web applications.

    Monday, July 15, 2019 7:18 AM