Access97 export file corruption

  • Thread starter Thread starter Curt Cohee
  • Start date Start date
C

Curt Cohee

When Win98 workstation exports an Access97 table (VB
application) to another database, the action causes a file
corruption in the target database requiring that that
database be repaired. The error log reports the problem
as error 91 or error 3343 with the notation "Object
variable or with block variable not set".

This is a new and random event in what is otherwise a long
time and stable application.

Any suggestion how I might isolate and solve the problem?
 
Hi Curt,

If the VB app is accessing one or both mdb files across the network, the
first object of suspicion should be the network. If the problem only
occurs with one workstation, there's a good chance it's a cable or
network adapter on that machine.

Also, try moving the mdb(s) to a local drive and running the app. If the
problem still occurs, it's likely to be something other than the
network.
 
Back
Top