What do I do if all users are locked out of OneSource?

Occasionally a OneSource user unexpectedly looses connectivity to the data file on the file server (due to a faulty network card, a loss of power to the PC, a power surge, an MS Access crash, a PC crash, etc).  In some cases, when this happens the OneSource file and/or data file stored on your file server becomes corrupted.  When this happens, each user, one by one, as they log out of OneSource, will be prevented from logging back in to the data file until it is repaired.

Note: The error message usually contains content about an "unrecognized database".

In nearly every case, MS Access can automatically repair the file corruption by following these simple steps:

1. Ask all remaining users, if any, to log out of OneSource.

2. Open up the data file directly from the server.  (In other words, walk over to the server machine and log into a session on your server directly.  If this is not possible, you may be able to open up a session on your server using some type of remote login application, such as Remote Desktop.  If your server does not have a working copy of MS Access of the same version or higher, you may need to make a copy of the  company data file on another PC and continue these steps on another PC).

3. Before proceeding, make at least one back up copy of the file before attempting to repair it.

4. Next, double click on the data file directly.  You will typically be prompted to allow MS Access to repair the file.  

5. The repair process will normally only take a few seconds.  When the database opens up the file is finished being repaired. (If you moved the data file to another PC to perform the process, be sure to put the data file, with the same file name as before, back into its original location on your file server).

6. The file should now be accessible by all OneSource users.

Note: If this does not solve your problem, please contact OneSource for additional support.  To perform steps to prevent

Note: If this problem seems to happen on a prevalent basis, you may want to take steps to prevent or eliminate the problem.
 

ID: A1112