hi,
the reason i am asking this is that,i am creating new tables dynamically 
and dont want to delete the old tables for sometime.......am gonna need to 
create 100 of new tables........??will there be performance problem??

regds,
ashay


> I belive the limit is 255, but i wouldn't suggest having more than 16, 
in 
access.

What is the purpose for the max table count?

Ever look at MSDE - Microsoft Data Engine.. if not...
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/off2000/html/acconAboutMSDE.asp

MSDE is a step above an Access database, and it acts like a minature SQL 
Server.  i.e. SQL Server Twinky Sized ::TWINK::

I belive MSDE comes on the MS Office 2k CD.... but will MS tell you that, 
I 
think not.


Treize Krushrenada,

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com