Leaving an Access 95 database open 
Author Message
 Leaving an Access 95 database open

Is it okay to leave a database open?  Can an occasional crash harm an
open database if the computer has to restart?



Fri, 03 Dec 1999 03:00:00 GMT  
 Leaving an Access 95 database open

Hi,

It is not a good idea if the PC has a Lazy write cache or if networked and
someone is writing in the cache or on the disk. I won't recommand to
restart the PC as the first alternative, but exception made of having a
feeling against it, I don't see other clear scientific reason of not doing
it (sure, you can loose unsaved data, but Access dot-mdb files are
relatively quite robust at that, by opposition to DOS or other "native"
files). Note that a bad side effect of closing the PC, either "elegantly"
or "abruptly", is that other PCs with a linked table on that PC will
experience a "Disk or Network Error", 3043=Err.Number.

Hope it may help,
Vanderghast, Access MVP



Quote:
> Is it okay to leave a database open?  Can an occasional crash harm an
> open database if the computer has to restart?



Sat, 04 Dec 1999 03:00:00 GMT  
 Leaving an Access 95 database open

Taking all that into consideration, is it okay to leave a networked
database open for 8 hours a day on three computers?  For the last year
we have been opening the database, doing something, then closing it.  As
of late it has become a pain to have to open up the database in order to
use it as it takes about 20 seconds (with a customer on the phone
waiting).

Josiah Smith

Quote:

> Hi,

> It is not a good idea if the PC has a Lazy write cache or if networked and
> someone is writing in the cache or on the disk. I won't recommand to
> restart the PC as the first alternative, but exception made of having a
> feeling against it, I don't see other clear scientific reason of not doing
> it (sure, you can loose unsaved data, but Access dot-mdb files are
> relatively quite robust at that, by opposition to DOS or other "native"
> files). Note that a bad side effect of closing the PC, either "elegantly"
> or "abruptly", is that other PCs with a linked table on that PC will
> experience a "Disk or Network Error", 3043=Err.Number.

> Hope it may help,
> Vanderghast, Access MVP



> > Is it okay to leave a database open?  Can an occasional crash harm an
> > open database if the computer has to restart?



Sat, 04 Dec 1999 03:00:00 GMT  
 Leaving an Access 95 database open

Hi,

Well, we have few installations requiring the database be open 24h on
24h... and keeping running. On some levels, even a small memory leak (from
Access or from W95) may generate a problem, but overall, it is working
(even if it is not warmly recommanded). I imagine that you can close the
database from time to time (scheduled "failure") in order to compact the
database. Don't forget the backups.

Hope it may help, (note that this is not an official Microsoft answer, just
a report based on "field" experimentation).
Vanderghast, Access MVP.



Quote:
> Taking all that into consideration, is it okay to leave a networked
> database open for 8 hours a day on three computers?  For the last year
> we have been opening the database, doing something, then closing it.  As
> of late it has become a pain to have to open up the database in order to
> use it as it takes about 20 seconds (with a customer on the phone
> waiting).

> Josiah Smith



Sun, 05 Dec 1999 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Access 95:Open database within a database

2. problem forms database access 95 in access 95 and access 97 on windows nt

3. Opening Access 2 database in Access 95

4. Can't Open/Convert Access 2.0 Database From Access 95

5. Access 97 opening Access 95 Database

6. Conversion of MS Access 95 Database to MS Access 97 Database Format Using DAO

7. Can't open any more databases(Access 95)

8. Access 95 database open by user Admin

9. Can't open any more databases(Access 95)

10. You don't have access to this database (97 opening a 95)


 
Powered by phpBB® Forum Software © phpBB Group