Acesss on a non sql server

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert database to SQL server 2
Convert a Number field to Autonumber? 15
convert a number to an autonumber 4
autonumber queestion 3
Append query to ODBC linked table in SQL Server 19
Create a folder 2
Starting an AUTONUMBER at a specific number 3
Re-Seed in SQL Server 8

Top