multiple user database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a database to track my team's work. I import spreadsheet that i get from different team into the database, and my team will document their work in the database. Can anyone recommend a best way to format the database for mutiple users? I often get a message that says " You or another user may have unexpectedly quit Microsfot Access while a Microsoft Access database was open. Do you want to Microsfot Access to attempt to repair the database?" I am constantly running queries while they're in the database for reporting numbers purposely only. I have split the database so that they access link tables, queries, forms, and etc. But is there any other way to format the database for multiple users

Thank you
 
Are you using Access 2000? I am having the same problem.
But first I get the message "The database needs to be
repaired or isn't a database file" when trying to open it.
Then the "You or another user have unexpectedly quit
Access..." message appears. This is happening multiple
times per day. There are approx 5 users that share this
database over a server (I do not have tables split from
interface).
Was told that Service Pack 3 will fix this, but it hasn't.
By kicking everyone out, deleting the .ldb file on server,
I can get it repaired. But then it happens again (to
different users each time).
Can anyone help?
-----Original Message-----
I have created a database to track my team's work. I
Click to expand...
import spreadsheet that i get from different team into the
database, and my team will document their work in the
database. Can anyone recommend a best way to format the
database for mutiple users? I often get a message that
says " You or another user may have unexpectedly quit
Microsfot Access while a Microsoft Access database was
open. Do you want to Microsfot Access to attempt to
repair the database?" I am constantly running queries
while they're in the database for reporting numbers
purposely only. I have split the database so that they
access link tables, queries, forms, and etc. But is there
any other way to format the database for multiple users?
 
ACCESS said:
I have created a database to track my team's work. I import spreadsheet that i get from different team into the database, and my team will document their work in the database. Can anyone recommend a best way to format the database for mutiple users? I often get a message that says " You or another user may have unexpectedly quit Microsfot Access while a Microsoft Access database was open. Do you want to Microsfot Access to attempt to repair the database?" I am constantly running queries while they're in the database for reporting numbers purposely only. I have split the database so that they access link tables, queries, forms, and etc. But is there any other way to format the database for multiple users?
Click to expand...

Splitting is good. However have you given each person a copy of the
FE, ie linked tables, queries, forms, etc.?

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

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
 
This is happening multiple
times per day. There are approx 5 users that share this
database over a server (I do not have tables split from
interface).
Click to expand...

That's why.

Split it, and give each user their own frontend.

Multiple users CANNOT open Access20xx databases *in design mode*
simultaneously (they can open the database and use existing forms,
reports, code etc. in a shared way, just not change the structure of
any of these).
 
Back
Top