Help From Visul Basic And Access 2002

[Kumar 0]

Hai! I need a Help about to Storing datas in Access 2002! What is the maximum size allowed in Access2002 to store datas? I have a error when i save records after the database size reaches above 152Mb, through visualBasic Connection! I have 172 tables in my database, and my initial DB size is 19Mb before saving records ! How can i rectify this problem? It would be really helpful to me if u help to solve this problem!:) Guru!

[_Damian S_]

Howdy, The physical database file limit for Access XP is 2 gig. What is the specific problem you are running into?

------------------------------------------- Damian - Insert snappy one-liner here.

[Kumar 0]

I have a error when i save records after the database size reaches above 152Mb, I have 172 tables in my database, and my initial DB size is 19Mb!

[leckey 0]

What is the error? Is it 'invalid argument?'

______________________ stuff + cats = awesome

[Dave Kreskowiak]

What's the ERROR?? Without that, there's nothing we can suggest to help you. 172 tables in an Access database?? I'd serisouly consider moving this up to SQL Server.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007

[Kumar 0]

Invalid data Source is the error statement

[Kumar 0]

Invalid Storage media is the error msg!

[Dave Kreskowiak]

OK. You're going to have to show us the code snippet that is throwing this error and the EXACT error message. You replied to lecky and myself and gave two DIFFERENT errors. Which is it and what is it EXACTLY?

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007

[Kumar 0]

Invalid physical Storage media is the exact error msg!