Add New Record to Table error (Access F/E - Sql Server 2005 B/E

[TerryM]

I'm presuming that this is a MS Access issue, however i could be wrong.

What I have is a preexisting MS Access Database that I am wanting to upgrade
the tables to SQL Server 2005 standard. I have already imported the tables
to the SQL Server and can view them through the ODBC connection. However
when I try to open my forms which is set to open to a new record on open I
get this error "You can't go to the specified record. You may be at the end
of the recordset." Even when I go to the table the add new record option is
grayed out. However the property is set for data entry, so I'm a little
perplexed.

So what I'm trying to figure out is how or what I need to do to get this to
work. I'm have to believe it is a Access/SQL Server issue.

Terry

 

[Stefan Hoffmann]

hi Terry,

What I have is a preexisting MS Access Database that I am wanting to upgrade
the tables to SQL Server 2005 standard. I have already imported the tables
to the SQL Server and can view them through the ODBC connection.

So you have the tables linked to your .mdb? Then open one of those
tables in the design mode and check whether the tables contains a
primary key. If there is none, then create on the SQL Server and relink
your tables.


mfG
--> stefan <--