By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,259 Members | 1,690 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,259 IT Pros & Developers. It's quick & easy.

Please Help --Adding a Primary Key to a Table with over 180K records

P: 1
Hi,
I am currently trying to add a primary key to a table with 180K records. I know that each of these records is unique but there is currently no unique identifier for each record. Therefore, I am trying to add an autonumber as a primary key but I keep getting the error message "file sharing lock count exceeded" I found an microsoft solution --but it sounds scary--like it could ruin my computer if I attempt it.

Any suggestions!

THANKS!
Dec 7 '05 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi,
I am currently trying to add a primary key to a table with 180K records. I know that each of these records is unique but there is currently no unique identifier for each record. Therefore, I am trying to add an autonumber as a primary key but I keep getting the error message "file sharing lock count exceeded" I found an microsoft solution --but it sounds scary--like it could ruin my computer if I attempt it.

Any suggestions!

THANKS!
Hi,

And this message appears only when you want to add an autoincrement Field in your table?

I suppose that if you try to add a field in you table that is not primary key there will be the same result!

I suppose that there is other users connected to the database and so you can't modify it... It's locked for modifications...

Have a nice luck..

:)
Sep 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.