Errors

[Guest]

In the last year I have been using Access 2000 alot.
I have noticed that in running queries that when a database reaches 2gig
size the queries will no long run and will give an error that reads "Invalid
Argrument".

I then have to create another database and import all the data from the
first database.

I usually try to watch and compact the database to eliminate it getting this
big.
However, it sometimes gets that big after one query process.

Is there any other way to solve this problem?

Thanks,

BC

 

[Rick B]

Yes, break your database into smaller chunks. Put some of the tables into
separate linked files or purge unneeded data from the tables.

Why are you running it so close to the maximum size? Are you storing photos
in the database?



--
Rick B



"Invalid Argrument error in Access" <"Invalid Argrument" error in Access
@discussions.microsoft.com> wrote in message
news:[email protected]...

 

[Guest]

It is for work.

There is massive amount of data to query.

Does limiting records by "criteria selection" help?
Any other suggestions to limit the size of the database?

Thanks
BC