What's a 'db.mdb' file?

[Guest]

I'm using an Access databse which is creating a db.mdb file when closed down.
Can anyone tell me exactly what this is? I think it means the database hasn't
saved properly but I'm not sure. Cheers

 

[SusanV]

when Access does a compact/repair on close it will create a temp file
db1.mdb, which should go away after the process finishes. Is this the case?

 

[Guest]

No, I'm aware of that temp file. This file is just called db.mdb and doesn't
disappear unless deleted. My suspicion is that for some reason the file is
'Saving As' and giving it a generic/default filename instead of overwriting
my existing file with the changes, but I wondered if someone could confirm
this.

 

[SusanV]

Being a non-standard temp file name, I would suspect some sort of code
running at close or something...
you could do a find in the VBE for the project for db.mdb maybe?

<mystified>