RE: Error Message

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.


"Rosemary" wrote:

> 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,
>
>
>
.

Relevant Pages

  • Re: How to commit tran log to .edb
    ... new database and move all the mailboxes to it. ... On our exchange server i get the databse corruption error and from the ... A corrupt database will generally not mount. ... delete those log files. ...
    (microsoft.public.exchange.admin)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Error Message
    ... I do need help with Optimistic Locking -- thanks again. ... > Your database is corrupt. ... More than one user opening and using an Access database file ... which we use to log in and track incoming jobs. ...
    (microsoft.public.access.formscoding)
  • Re: Database Security
    ... the rights to execute jobs with the proxy account. ... user at database level and not server. ... >>from 30 legacy systems) These often fail and the owner ...
    (microsoft.public.sqlserver.security)
  • Re: Absolutely Bizarre - Backup reference database that doesnt exist
    ... In Enterprise Manager, expand to Management> SQL Server Agent> Jobs, ... also try under Management> Database Maintenance Plans). ...
    (microsoft.public.sqlserver.server)
Loading