July 29, 2003 at 5:00 pm
We have an Access 97 database which links to SQL Server 2000 via ODBC. I am having a problem where once data is entered I cannot do anything else to that row.
I can do any sort of data entry via the forms through Access and with some forms there is a point where the data is saved or even if data is saved after data entry is complete. Well, the data cannot be edited after that, nothing can be changed or new data on the row cannot be added. I receive the 'The data has been changed since you started editing it etc etc, copy to clipboard or drop changes' and that will always come up for any row that has been added using the linked tables. I cannot even go to the linked table and directly type in, same error... but if I go to SQL Server I can change and add anything to the table.
It is like the ODBC has no idea how to release the row once I have created it and it thinks it is always in use or something. It is very frustrating as it is a show stopper for this database.
Any ideas
S.
July 29, 2003 at 8:15 pm
Make sure the table has primary key defined.
July 29, 2003 at 8:46 pm
The table has a unique primary key, which is an int, identity with step value of 1.
All the rules as far as I know are correct (as far as I know).
S.
July 30, 2003 at 1:35 pm
Make sure you don't have the datatype bigint in your SQL table. Also check that any bit fields have a default value and that none of the records have a NULL in that field.
Some things I experienced,
Michelle
Michelle
July 30, 2003 at 5:21 pm
Michelle, GREAT work!!!
It was the BIT and null issue exactly.
I really didn't think I would have the level of problems that I am having simply changing the linkage from and access front to access backend into a access front end SQL back end via odbc.. it is a minefield.
Thanks again
S.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply