Error starting Database

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I understand how 2 people can not change the same record
at the same time. However I get this error when I start
the database!

"The Microsoft Jet Database engine stopped the process
because you and another user are attempting to change the
same data at the same time."

No structure changes has occurred to this database. It is
used in a network so many people are viewing the database
at one time.

Any idea why this would show up when you start the
database?

Thanks in Advance
 
Scott said:
"The Microsoft Jet Database engine stopped the process
because you and another user are attempting to change the
same data at the same time."
Click to expand...

Corruption. For more information on corruption including possible
causes, determining the offending PC, retrieving your data, links,
official MS KB articles and a list of vendors who state they can fix
corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm
No structure changes has occurred to this database. It is
used in a network so many people are viewing the database
at one time.
Click to expand...

Have you split the MDB into a FE/BE?

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp.htm for more info. See
the Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top