Database gives Invalid Data Format Error when I push a command bu.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that gives the following error "Invalid Data Format". I
have checked the references in Visual Basic and they seem OK. The database
is rather complex but the error does not seem to be related to anything. The
only way I have found to fix it is to open a new database and export all the
forms, queries etc into the new one. Then it works for awhile.
Compacting and repairing doesn't seem to help. It does seem to happen after
I use the object dependencies feature but not right away.
This has now happened about 5 times over 6 months. I have it on a server
and a copy on my PC and it happens to both so it is probably the database and
not the copy of Access or how it is set up.

Help!!!
 
Hi BarbaraT

Will it be possible to have a look at the code behind the command button?
Are you trying to perform a computation?

Michael
 
Back
Top