Problem with Alter column

S

squirrel

Hello everybody

I intend to program an undo function with logged information. For
example a deleted record should be set back again. Of course with the
old ID. I have found IDENTITY_INSERT for SQL but nothing for Access.
So I tried to change the column ID from Counter to Long Integer which
worked fine. But I cannot set it back to Counter if records already
are in the table. Can anybody give me a suggestion? Thanks a lot-Alex
 

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

Delete colums in a table using a macro if 2 column is empty 0
Increment SQL identity From Access Front End on save of record 2
VBA for data validation in 3rd column does not run. I need help. 1
append multiple worksheets data into a single multi-dimensional array 4
Having problem with MultiUser Counter 1
Alter Table: datatype 1
2 problems with code 3
Record logout time on close 3

Top