T
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
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