How Add Row Number

[Al Franz]

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?

 

[Jeff Boyce]

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

 

[Margaret]

Please visit [email protected]/blog
I am starting up a business and need new customers. Any help that you could
give me, I would really appreciate it. Im not spaming anyone, so please let
me know if there are anyone you know who lives in the london area and would
be interested in the purchase of medical uniforms.

Im trying to get as many customers as i can. i need help tho. Please pass
this email on to whom ever you know who would be interested. I would really
appreciate it.

Here is a little about it:

We are a business that makes Medical Uniforms which are made for Nurse's,
Doctors, and any Medical team that there is out there like PSW's.

You can find more out about it at: [email protected]/blog

We have flexible plans to accommodate growth. All size's, styles and colors
that you can think of

We are located in London, Ontario

Thank you for your time.

Margaret