How many forms can Access have?

[Robson8112]

How many form can Access hold in one database? is there a limit? if so, does any body know what it is?

 

[pgk]

Hi,
There can be upto 255 forms in Access. Hope it helps. Let me know what happens.
With regards,
PGK

 

[Robson8112]

What would the performance on access be like if i had about 150 forms, with about 150 tables?? can Access handle something like that. the Database will be ran on standard PC's (1Ghz +, 256ram)??

 

[nberryman]

What are you trying to achieve?

150 forms is a lot to maintain, what are all the table holding, the same structure with different data or all different structures.

Tell us as much as you can

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[BVerlaan]

The maximum size of an Access mdb is 2GB. I think it's very difficult to reach this maximium size, even with a few hundred tables and forms. So i suggest, try and let your computer sweat. Make back ups regularly!!

Greetings, Bart Verlaan.

 

[Guest_imported]

I am creating forms for each of my tables...
I want to use the "tab control" form....
How do I have the tab control look at all the tables? Its seems that the field list only lets me look at one table. How can I look at more? My work around is to click on the second tab and the new form will come but I would like for it to be already there.