How many tables .. in Access 2007 .. are there limits ?

[Ahmed]

Hi,

Is there restriction for number of table in Access 2007... what are
maximum number of tables
can be used..?

thanks in advance...


Dr. Khalak

 

[John Spencer]

Check HELP. Search for specifications.

You are allowed to have up to 2048 tables open at one time. And 32K objects
total in a database. So there are restrictions.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Ahmed]

Thanks John for Replying...
Thanks all MVPs.... for helps

Dr. Khalak

 

[Steve]

Dr. Khalak,

If you are concerned about the number of tables that can be in your
database, it is highly likely that the tables you have or the design of the
tables you are contemplating is not correct. Before proceeding further, I
suggest you post what you have here for review by the experts. If you want
someone to review what you have or want help designing the tables you need
for your database, I can help you. I provide help with Access, Excel and
Word applications for a small fee. Contact me if you want me to help you.

Steve
(e-mail address removed)

 

[John... Visio MVP]

Dr. Khalak,

Before proceeding further, I suggest you post what you have here for
review by the experts.

and little stevie is not one of them, though he did sleep in a Holiday Inn
last night.

If you want someone to review what you have or want help designing the
tables you need for your database, I can not help you. I pretend to
provide help with Access, Excel and Word applications for a small fee.
Ignore me if you want real experts to help you.

Steve

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

 

[Jeff Boyce]

These newsgroups provide FREE assistance. The Code of Conduct even states
that solicitation is not allowed.

If someone offers to help you for a fee, ask yourself if you want to do
business with someone who knowingly ignores the rules.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.