Strange problem with autonumber column !?!

D

David

I have a table with an autonumber key. This is a split
database. I added 3 records to the table manually in
datasheet view and all appears fine, the autonumbers are
there. This is all in the back end database.

When I go to my front end database and open the table in
datasheet view, I get 'Reserved Error -1517' and the
autonumber columns have #Error in them.

I dont understand this. What can I do?
 
J

Joan Wild

Answered in the other message you posted:
'Reserved Error (-1571) in datasheet view'
 

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

Autonumber records inserted in gaps 0
Setting column width in a table with a macro is not working 0
sqlite-odbc write conflict 2
What are AutoNumber Dangers 11
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Outlook 365 not saving sent messages. 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Errors in Autonumber ID field 4

Top