OLE AND INVALID ARGUMENT

E

ERIK

I have an access database its about 2GB in size. When i try to add or change a record or make a design change to a form or report I get "invalid argument". I know it is somehow related to the size of the database. I have a OLE column with fields that contain 2 and 3MB's worth of data. How do I overcome this problem or is Access limited to 2GB. I tried using an pre-2GB copy, when it reached the 2GB mark the problem came back. All of this is in Access 2000.
 
J

Jake

Erik

The actual db file itself is limited to 2 GB, however you can use linked tables (to another backend) if you need more room

Jak

----- ERIK wrote: ----

I have an access database its about 2GB in size. When i try to add or change a record or make a design change to a form or report I get "invalid argument". I know it is somehow related to the size of the database. I have a OLE column with fields that contain 2 and 3MB's worth of data. How do I overcome this problem or is Access limited to 2GB. I tried using an pre-2GB copy, when it reached the 2GB mark the problem came back. All of this is in Access 2000.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
2GB file 5
Database exceeding 2 GB during macro execution 5
Invalid Argument 5
Limitations on Split Databases 5
Too mnay records? 7
Error: The query cannot be completed 3
Errors: There isn't enough memory to update display. MS Access 20 0

Top