hi,
I wanted to convert tables from a access database to a ms sql database, every thing went well (transferring data, remake the auto numbering, and set the table key's)
next step was to relink the tables via odbc in the old access database (this also went well) but now i was testing it and there apears to be a few errors:
1) when I tried to make a new record, access made a new record but immediatly emptied the data I entered, by reentering the data every thing seemd to go well
2) I can update all exsisting records, I can enter new data, but I can not update new added data in acces olso not after rebooting
it looks like it is locking al new entered data after saving, when I try to update data I get the message cannot update record is locked by another user, drop changes? or coppy to clipboard?
I also have some other databases running in ms sql 2000 that do not have these problems I tried to import a test table from the old acces database to a database in sql that did not have that problem , to see if the problem was database related or table related, but the outcome of this test was the same so according to this test it seemed to be table related
I hope someone is familliar whit this problem and has solved it
many thanks in advance
P.S. sorry for my poor english
I wanted to convert tables from a access database to a ms sql database, every thing went well (transferring data, remake the auto numbering, and set the table key's)
next step was to relink the tables via odbc in the old access database (this also went well) but now i was testing it and there apears to be a few errors:
1) when I tried to make a new record, access made a new record but immediatly emptied the data I entered, by reentering the data every thing seemd to go well
2) I can update all exsisting records, I can enter new data, but I can not update new added data in acces olso not after rebooting
it looks like it is locking al new entered data after saving, when I try to update data I get the message cannot update record is locked by another user, drop changes? or coppy to clipboard?
I also have some other databases running in ms sql 2000 that do not have these problems I tried to import a test table from the old acces database to a database in sql that did not have that problem , to see if the problem was database related or table related, but the outcome of this test was the same so according to this test it seemed to be table related
I hope someone is familliar whit this problem and has solved it
many thanks in advance
P.S. sorry for my poor english