Ok well the problem is that the following code used to work for an Access 97 database, but it doesn't want to work for me now that I have moved to Access 2000.

Set db = wrkJet.OpenDatabase(Me.TxtPath, True, False)

The error message that I get is unrecognised database format. I can open the db manually without a problem. Anyone come across this before?