Hi all. I recently moved to data portion of an access database to sql
server 6.5 using MS's upsizing wizard. However, the transition was not
all I had hoped it would be.
I open the access database. I open a simple select query. I am
prompted for my user id and password for sql server. I enter userid sa
and the appropriate password. The results I expect are returned.
The query selects 3 columns from a single table.
The problem happens when I try to change an entry in the query.
- First, I get a Write Conflict saying that another user has changed
the record since I started editing. It gives me the option to discard
changes, or copy to clipboard. choose to copy to clipboard.
- I then get an ODBC call failed error. I click OK.
- I then get an error saying
[Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that
starts with 'Change' is too long. Maximum length is 30.
(#103)[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quote
before the character string 'Change_Reques1_ISET NOEXEC
OFF'.(#105)[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax near 'Change_Reques1_ISET NOEXEC OFF'.(#170)
Any ideas how to resolve this problem?