Problems

[Guest]

I'm having loads of problems with our 15 MB database. Stored on a Server
that all can access, plenty of room on the server. How many users can be in
a database at one time? My database is erroring and crashing all the time.
I could use some help getting through this since I'm not an access guru yet,
although they are trying to train me to be that, I really could use some help
here. We are running Windows 2000 on the clients, windows 2000 server on the
servers and microsoft access 2002

The biggest error that I get right before we crash is the following: The
database 'Full Path and filename' needs to be repaired or isn't a database
file. You or another user may have unexpectedly quit Microsoft Access while
a Microsoft Access database was open. Do you want Microsoft Access to
attempt to repair the database?

Of course we say yes, but then it won't let us repair because its locked up
somehow. once the above happens? we crash usually within 24 hours

HELP!!!!

 

[George Nicholson]

You don't specify whether this is a split db or not, but I gather from how
your questions are worded that it isn't.

A split db:
- shared backend (data only) on server
- each user has their own local copy of the Front end (queries, reports,
forms, code, tables linked to backend data)

If it isn't split, that's problem #1, and the 900 lb gorrila among all of
the possibilities.

How many users can safely access a backend mdb file at one time from their
own local front ends? The Access help entry "specifications" says 255.
How many users can *safely* access the same single-file mdb at once?: 1
("safely" means without running the risk of corruption exactly like you are
experiencing)


HTH,