Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Export SQL server2000 to Access 2000 with primary

Author  Topic  casstd Starting Member 3 Posts Posted - 2006-01-16 : 04:38:56 Hi, I have a small website created for my user using sql server2000 database. Now my user wants me to covert sql to access2000 so that it can run on any machine with provided services. I export sql server dabase to access2000 there was no problem. The problem is with Primary key. All the primary key field I used in sql converted to datatype 'number' in access database. When i change this 'number' datatype to 'autonumber' datatype in primary key column it doesn't allow me to change with records. Here is the message "Once you enter data into database you can't change any field datatype to autonumber, even if you haven't yet add record in the table." "Please create new field and set datatype as autonumber. The access will automatically enter autonumber into that field starting from 1" I can't do that because all my primarykey field are not in order and are linked with subtable. That will mess the whole database. How do I solve the problem. Thank you.