Suddenly getting errors

[susand]

We have an access db that has been working fine for ages and now when we click on a New Record button we are getting the following error:-

Run time error 2105 - you can't go to the specified record. erroring out on the line DoCmd.GoToRecord , , acNewRec. We are not aware of anything changing on the PC that the db is sitting on. I have spent the whole day searching the web but have found nothing helpful.

I have compacted and repaired the db, even went to the form/table security to see if all users can edd/add.

Any help greatfully received

 

[jdraw]

We have an access db that has been working fine for ages and now when we click on a New Record button we are getting the following error:-

Run time error 2105 - you can't go to the specified record. erroring out on the line DoCmd.GoToRecord , , acNewRec. We are not aware of anything changing on the PC that the db is sitting on. I have spent the whole day searching the web but have found nothing helpful.

I have compacted and repaired the db, even went to the form/table security to see if all users can edd/add.

Any help greatfully received

See this link for a similar problem and solution
http://www.tek-tips.com/viewthread.cfm?qid=813047

This isn't mine, I just happened to do a little searching for error 2105 and possible solutions.

There are other entries in this forum as well - but I didn't find any resolution here.

Good luck.

 

[GPatters]

I had the same message come up recently. Turned out I was using the autonumber in the primary key to tell access which record to go to. When you delete a record, however, access will either pull up the wrong record or give you the 2105 error if the record number doesn't exist.