the size of an single project

[Tracy]

Hi,

I have an question on general about the size of an single ms
access project.
What is the maximum numbers of rows and columns I can create for an single
table and What is the maximum numbers of tables I can create for one project
?
( I need at least 15000 tables )

 

[ldiaz]

I think that is not necessary that qty of Tables, and about rows you can use
thounsands of them.


Thanks

 

[default105]

Goto this website for capacities of access

http://www.databasezone.com/techdocs/acclimit.html

This should answer your question

 

[Brendan Reynolds]

If by 'project' you mean an ADP, the data is stored in SQL Server, so it is
the SQL Server specifications that apply. The answer to the question 'how
many of anything can I have in SQL Server' is 'way, way more than you will
ever need', but if you want more specific answers than that the details are
at the following URL ...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

There is no specific limit on the number of tables you can have in a SQL
Server database, but the maximum number of objects, including tables, is
2,147,483,647.

The fact that you think you need 15,000 tables, however, suggests to me that
you are contemplating a seriously flawed database design.

 

[aaron.kempf]

yeah.. i've had some AWFUL designs with just a couple of hundred
tables..

gosh ive had some awful designs with a dozen tables.. a lot of times;
it's easier to bend database rules.. in the short run.. but in the long
run having proper normalization is nice.. keeping similiar entities in
the same table.. i dont know my codds anymore but i swear it's in there
somewhere

 

[aaron.kempf]

but what im really trying to say.. is

i really really reccomend Access Data Projects

even if you only have 15,000 RECORDS in a single table; i just swear..
anything more than a single record and a single user; you should be
using Access Data Projects and not some silly mdb format