If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How Add Row Number
Have a large Access table 3 million rows. I tried to add a row number field
but get an error "File sharing lock count exceeded...". Should I be able to do this? |
#2
|
|||
|
|||
How Add Row Number
Al
How many fields do you have in that table? How many (maximum possible) bytes in each record? How many bytes in the longest record? What you mean by "row number field" and what I mean may not be the same. Care to share? Are you attempting to change the design of the table, or are you creating a new (empty) table with the new field and using an append query to load it up? More info, please! Regards Jeff Boyce Microsoft Office/Access MVP "Al Franz" wrote in message ... Have a large Access table 3 million rows. I tried to add a row number field but get an error "File sharing lock count exceeded...". Should I be able to do this? |
Thread Tools | |
Display Modes | |
|
|