Error Message

[Guest]

Hi,

We have a small DB called "Worklog" that is stored on a local network drive.
The front end and back end are stored in the same folder. The DB uses a
Main form, which we use to log in and track incoming jobs. The Main form
contains tabbed subforms. The Main form is accessed via the Switchboard in
two ways -- Add New Job is a data entry only version of the form; See All
Jobs Details is an Edit version of the Main form.

We have been using the DB successfully, however the last couple of days we
have been getting an error message when entering new jobs. Where do I look
for the cause of the message? Here is what an operator wrote to me:

"The error we get when entering new jobs is 'Microsoft Jet database engine
could not find the object scripts'. Then when I hit okay another error comes
up which says it could not find the macro 'Open Switchboard'. The only way I
could get rid of the error was if I closed out. I reopened the worklog and
so far it seems to be fine. But when this happens, all of sudden the
"Worklog" on the status bar would start blinking and we would have to close
out of it."

Thanks,

 

[Guest]

Your database is corrupt. That is not suprising given the way you are doing
it. The Front End should NOT be on the server. It should be on the desk top
of all users. More than one user opening and using an Access database file
(Front or Back) is almost certain to eventually be corrupted. In addition,
this implementation doubles network traffic.

Solution:

Compact and repair both Front and Back
Leave the Back End where it is

Set up Optimistic Locking in both (If you need help on this, post back)
Set both to compact on close
Relink using relative addressing - NOT drive letters
(\\ThePeskyServer\SomeDataStuff\Access BackEnd\
Put a copy of the Front on each user's desk top
Get rid of the copy of the Front End on the server.

 

[Guest]

Hi,

Thanks for your post. I do need help with Optimistic Locking -- thanks again.

Regards,
Rosemary