Can anyone help. I inherited a database with approx 400 records. There are digital photos embedded in the individual tables, each photo is approx 1mg in size.

The issue: If I select any photo for viewing, copying, editing, etc (any function) once the function is completed I get an error message (invalid argument) and have to fail out of the program in order to continue working. As well the operation (what ever it was) does not complete (record unchanged).

My question is: could it be the size of the photos that is causing the error?


Thanks for any help you may be able to give. I am a novice at this.

Gail

I think you will have to give more information on the code that you´re running.

Fuga.

Thanks for the quick reply.

I am using Windows XP and running Access 2000. I hope this is enough info.

I think he meant you'd need to give further information on the VBA code in your functions.

When I said I was a novice, I meant just that. I know enough about Access to get into trouble, but not enough to get out.

The person who created the database was not a programmer or formally trained in Access. the database consists of 4 linked tables, there are no macros. The table in question contains the embedded photos which are JPG format and were created in MS Photoshop. The photos are 1 meg each (entirely too big). I suspect this is the problem, however since I get this error message whenever I try to do anything with the database itself, I can not be 100% sure.

If you select the form and then

view->code

you should be able to see what is supposed to happen when you press a button or something like that. Otherwise there might be modules in the db.

Fuga.