Re: Problems
- From: "George Nicholson" <JunkGeorgeN@xxxxxxx>
- Date: Thu, 15 Dec 2005 18:54:07 -0600
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,
--
George Nicholson
Remove 'Junk' from return address.
"Katya2006" <Katya2006@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D0D01BCD-CA2A-4BFA-AF15-0C439010A6AB@xxxxxxxxxxxxxxxx
> 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!!!!
>
>
.
- Prev by Date: Re: Append Query Multiplies Records Thousands of Times? Access 200
- Next by Date: Re: Interactive Query to Reference user Defined Variables
- Previous by thread: Re: Updatable Query
- Next by thread: Re: not equal
- Index(es):
Relevant Pages
|
Loading
