Can a Database Be Larger Then 1GB?

[dvannoy]

Is it possible for a database to be larger then 1GB...

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tlbroadbent]

In Access 2000, the limit is 2GB. Previous versions are limited to 1GB. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[dvannoy]

what will happen if it reaches or tries to go over 1gb?

see im running a series of append query's and it's causing the database to blowup..I dont know what else to do.

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tlbroadbent]

Generally, the process (query, code, etc.) aborts when the database approaches or exceeds the limit. Have you compacted the database? Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[Dzidze]

If your database is in access, then compacting it will buy you some time. But if it is really growing fast, then you should really consider switching to Oracle or SQLServer. ''Life is like a box of chocolate...''

 

[tlbroadbent]

Could you possibly create another database, export some of the tables to the new DB, delete the tables from the old DB, compact the old database and then link the tables from the new DB in the old DB? This will only work if you have the data spread across multiple tables. If the data is all in one table then you'll need to develop another strategy.

Could a big table be split? Perhaps it contains a memo filed that could be split from it and moved to another DB. Perhaps some of the older data could be archived to another database. Perhaps images that have been stored in the DB could be removed and stored on disk with a link provided in the table. Just some thoughts. Hope something helps. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[dvannoy]

I did an export and was compacting up to two times a day...I had OLE Objects on some splash forms that i thought might be causing the problem. deleted those as well as the modules and still the database would blow up to 900mb within 9 hours. everyday this would happen and as all of you know this was making me crazy. In this database i am also running a series of append query's that append certain data to there right tables. I then started trying to figure out why that would cause the problem. The tables that I append from, one has 6000 records and the other one has 20000 records. so, in my append query's under criteria I told the query to only append todays date. I have been watching the database since yesterday and it has not even grown 1mb. I think my problem is solved. they run this append query's several times a day, we run 24hours here so these query's run around the clock.

I also tryed to decompile the database. what this does is convert all your VBA code to the current version of VB and i think it even converts it to just plain text.

I want to thank everyone for your help and advice.

Thank
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com