2GB file

[Sahar]

What causes the database to reach 2GB? I dont believe I have any large files,
such as pictures in the database, yet during the day it reaches 2GB. When I
go to compact, it gives invalid argument because it is now 2GB!

 

[Arvin Meyer]

What causes the database to reach 2GB? I dont believe I have any large files,
such as pictures in the database, yet during the day it reaches 2GB. When I
go to compact, it gives invalid argument because it is now 2GB!

Create a brand new empty database. Import all the data tables. Create
another empty database. Import eveything else. Open the second database and
link all the tables.

Typically, there is some corruption causing this and the easiest way to get
rid of it is to start fresh.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Sahar]

Yes, that is what I normally do. After I compact the new database, it is
about 40MB, but what causes it get so large? It happens daily to the database.

 

[John Vinson]

Yes, that is what I normally do. After I compact the new database, it is
about 40MB, but what causes it get so large? It happens daily to the database.

Do you use a lot of temporary tables? MakeTable queries? Queries which
empty a table and then refill it using an Append query? None of the
space freed by deleting these tables or records will be freed up.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Tom Wickerath]

Check out some of these possibilities:

http://tinyurl.com/2dmpw


Tom
___________________________________


Yes, that is what I normally do. After I compact the new database, it is
about 40MB, but what causes it get so large? It happens daily to the database.

 

[Tony Toews]

Yes, that is what I normally do. After I compact the new database, it is
about 40MB, but what causes it get so large? It happens daily to the database.

One thing I'd do is ensure everyone is running the same version of
Jet.

What I've done is use the various API calls available and am checking
the version number and date/time of a crucial dll, msjetxx.dll, to
ensure it matches what I have on my system. See the Verify
Appropriate Jet Service Pack is installed page at my website for more
details including sample code:
www.granite.ab.ca\access\verifyjetsp.htm

If however the problem is extensive use of temporary tables or
importing and discarding large numbers of records then I'd use a
temporary MDB to store these.

See the TempTables.MDB page at my website which illustrates how to use
a temporary MDB in your app.
http://www.granite.ab.ca/access/temptables.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm