How to avoid "file already in use" error in the Online Web Access Viewer?

Thursday, May 27th, 2004

How to avoid "file already in use" error in the Online Web Access Viewer?

Created 2004-05-27 by Michael Meckelein.

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:

  1. Right click on the folder in which the MS access database is located and select Properties.
  2. Be sure that the Read-only property is unchecked.
  3. Switch to the Security tab in the properties windows.
  4. Click the Add button to open the Select Users or Groups window.
  5. 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)
  6. 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 support@adiscon.com.

2004-05-12 MonitorWare Agent 2.1 Final released

Wednesday, May 12th, 2004

MonitorWare Agent 2.1 Final Released

Adiscon today announced the immediate availability of MonitorWare Agent 2.1 Final. "I am pleased to announce the new 2.1 version" says president Rainer Gerhards "with this, MonitorWare Agent offers even more capabilities – many of them based on customer requests". (more…)

2004-05-12 MonitorWare Agent 2.2

Wednesday, May 12th, 2004

MonitorWare Agent 2.2 Final Release

Build-IDs: Service 2.2.240, Client 2.2.700

Service Changes

  • Database Monitor Moved some options into a new Advanced view and added a new option to define the message format. There are three Options to what the message can be configured now: (more…)

2004-05-12 MonitorWare Agent 2.1

Wednesday, May 12th, 2004

MonitorWare Agent 2.1 Final

  • New Services Added– DataBase Monitor Service can read a table out of a database and process each data record like other events within MonitorWare Agent.
    – SerialMonitor Service allows you to capture messages from a Serial Com or from the Printer ports. It is highly configurable and can send a Greeting message. (more…)