CODEWITHSUNDEEP
sql-server-2005ms-access-2007
Amy
Amy

Reputation: 132

Error: Cannot got to specified record. Access 2007 and SQL 2005

I have inherited an Access 2007 database that has been split so the tables are on a SQL 2005 server.

The database consists of 3 tables and 3 forms. The main form that is used reads and writes to all 3 tables. Data can be edited and deleted OK but trying to add a new record throws an error saying, "You can't go to the specified record"

The code for the new record button is an embedded macro with the follow parameters:

  OnError Next,
  GoToRecord ,,New,
  [MacroError]<>0 MsgBox =[MacroError].[Description],Yes,None,

Any advice would be greatly appreciated

Thanks,

Amy

Upvotes: 0

Views: 1136

Answers (1)

vbocan
vbocan

Reputation: 1374

Check whether all required fields of the record are present when you do the insert or if the constraints are met (such as having a duplicate value for a field that does not allow duplicates).

Upvotes: 1

Related Questions