Prev: Rooms reservation DB - any help?
Next: Linking tables
From: Al Franz on 25 Jun 2008 13:15
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?


From: Jeff Boyce on 25 Jun 2008 14:33
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" <albert(a)nospam.netmation.com> wrote in message
news:ut67Dcu1IHA.4476(a)TK2MSFTNGP06.phx.gbl...
> 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?
>


From: Margaret on 6 Jul 2008 12:01
Please visit www.atnas20(a)hotmail.com/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: www.atnas20(a)hotmail.com/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

"Al Franz" <albert(a)nospam.netmation.com> wrote in message
news:ut67Dcu1IHA.4476(a)TK2MSFTNGP06.phx.gbl...
> 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?
>

 | 
Pages: 1
Prev: Rooms reservation DB - any help?
Next: Linking tables