[RESOLVED] MS Access question

how many tables can I have open at one time in Access???


I really need about 10 open at one time.

do you mean create

I think there is no probelm to create 10 table in a database, i've worked with more.
and
I think also no probelm to open 10 table at a time. Do you feel any problem to open 10.
what problem you face?

Don't know of a limit to how many you can have open, except as limited by the resources on your machine.
You normally wouldn't need ten tables open in most well designed Access dbs, but I suppose there are exceptions.

If you have the database open via a valid connection, ALL the tables in the database are available to you.

You can have up to 255 connections, user or program connections.

you can have up to 2048 tables open.

under some conditions it may be less.


I just solved the problem Of more than one Table open at a time.

I looked at my code and figured it out, so my problem is solved.



http://www.databasedev.co.uk/access_specifications.html

Those are table opened in the Access GUI. You didnt state how or where you were opening them :)

Ps, dont forget to Resolve your thread from the Thread Tools menu so others know its done. ;)

If Access GUI can do 2048 then I should be able to do 10 or so.

again, thanks for the info.