I have recently developed a MS- access application using Data Access Pages. The application is deployed on IIS Server for intranet use. The MDB file resides on the network share where internet user account IUSR_<machine_name> has permissions.
The connection string specified in the data access page uses user "Admin" and blank password to connect to the MDB.
I assumed that this would work for multiple users when they try to access the page from the IIS servers and insert records into the MDB. But I observed that if one user is accessing the page, the other user trying to do so is denied the access with message "File ; could not be opened" and the page doesn't show up.
I would appreciate help in this regard. How can I make it work so that multiple users could use the application at the same time.