Acesss on a non sql server

I

Impy

How do i keep my database 'always on' on a server. I have problems with the
autonumber field in that once logged out the database reverts to the number 1
on the autonumber column within one of me tables
 
R

Rick Brandt

Impy said:
How do i keep my database 'always on' on a server. I have problems
with the autonumber field in that once logged out the database
reverts to the number 1 on the autonumber column within one of me
tables
Click to expand...

The only time this should happen is if you are clearing the table and then
compacting it. Do you have Compact On Close enabled?
 
Top