Invalid Argument - Database Size?

[christianhagman]

I have developed an application which is recording many records containing photgraphs. The database has about 1000 records in it and is now at 2.095Gbytes. The application uses Access 2000.

I am having a problem trying to add or delete records to the database. The following error messages appear:

Invalid Argument

Then press help and an HTML Help Author Message appears as follows:

“The window name “langref” passed to HH_GET_WIN_Type has not been specified.”

I have since imported the database including data to a new database and this fixed the problem for a while, also compacting it I assume and making the size slightly smaller.

I then added new records to the database and came acrosss the same issue.

After analysing the table structure I found that the table in question has two very strange indexes on it which I cannot find through the table design mode. And therefore cannot delete.

Does anyone know if there is a problem with the database being to large or any issues with saving many JPG files etc?

Also has anyone encountered strange indexes appearing in their systems?

Do I need to upgrade to SQL Server?

 

[MHM]

Do you really store all these files in the database (..itself)??

I'd probably store the file names only, i.e. I'd install pointers to the actual storage position.

Do you really need to save JPGs in the database itself?

P.S.: Be always careful about running beyond the 2GB-limit (2.147.483.648=2^31)!