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

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

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 wrote:
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

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

Dr. Khalak

"John Spencer" wrote in message
...
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 wrote:
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

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



"Ahmed" wrote in message
...
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

"Steve" wrote in message
...
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

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.

"Ahmed" wrote in message
...
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

"Steve" schreef in bericht ...
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.

You are an expert in advertising and harrassing posters here.
Not in Access...no way... You did prove that lots of times...

--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!)

Arno R