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

A

Amies

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
 
T

Tom van Stiphout

On Thu, 12 Nov 2009 01:52:21 -0800 (PST), Amies <[email protected]>
wrote:

What is the RecordSource of that form?
If you create a View on SQL Server with the same sqlstatement, can you
add a row to it?
I suspect there are some joins involved and adding data simply is not
possible with such complex sqlstatement. Simplify.

-Tom.
Microsoft Access MVP
 

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

SQL 2005 Databound Form 2
Add New Record to Table error (Access F/E - Sql Server 2005 B/E 1
Cannot insert new record into sql 2005 View from Access form 1
Access frontend with SQL Server backend: my solution for ODBC Call error 1
you can't go to the specified record 1
Access 2007 ODBC Error Trapping 8
"Cannot go to specified Record" 2
cannot create New Record (icons greyed out) 5

Top