You often get an error “file already in use” if you use the Online Web Access Viewer together with a MS Access database. The message you get look like this one:
AccessMicrosoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Microsoft Access Driver] Could not use ‘(unknown)’; file already in use.
/winsyslog/EventsOnline.asp, line 388
This is a well-known performance issue of the MS Access database. It is highly recommended not to use this database for production environments. You can switch to either MySQL (which is free) or SQL Server. This will solve the problem of web access too and will enhance the efficiency at the same time.
However, to avoid the error you can try the following:
- Right click on the folder in which the MS access database is located and select Properties.
- Be sure that the Read-only property is unchecked.
- Switch to the Security tab in the properties windows.
- Click the Add button to open the Select Users or Groups window.
- Select the user Internet Guest Account, click Add and confirm your selection with OK. (Note, the Internet Guest Account has typically the name IUSR_COMPUTERNAME)
- Now you are back in the Properties window. Be sure that the new user is selected. Give the user Write permissions by activating the checkbox.
If you have any questions on these pages, please email us at firstname.lastname@example.org.