Convert Access table to SQL

T

Tony WONG

i have 2 access files of Forms and tables.

The tables are now successfully imported into SQL 2000 server. Forms are
still saved in the Access file.

i created back ODBC links in the Forms (Access file).

Very strange, it only happens in one of the tables.

i open the table (Access file) linked by ODBC to SQL

i can amend the old records.

when i create new record, i can insert but after insert, i cannot amend
those new insert records.

a message come out about write conflict, telling me about another users
using it.

i am sure i am only the user.

Grateful for any advice. thx.

tony
 
D

Douglas J. Steele

When you created the tables in SQL Server, did you create unique indexes on
all of them? Without unique indexes, the tables will not be updatable
through ODBC.
 
J

Jason

Hi

I had a WINRAR Error at my Pingotron.



Douglas J. Steele said:
When you created the tables in SQL Server, did you create unique indexes
on all of them? Without unique indexes, the tables will not be updatable
through ODBC.
Click to expand...
 
Top