Make sure also that if you are using the OpenDatabase method that you have set the Options variable to False

e.g.

Dim ODb as Database

Set ODb=OpenDatabase(YourDbPath,False,False,ConnectString)

Connect string is usually for passwords (";pwd=" & "YourPassword")

This would only happen though if the file is being used elsewhere (like Access itself is open or more than one copy of your app is running...)

Regards,

------------------
- Chris
[email protected]
If it ain't broke - don't fix it


[This message has been edited by chrisjk (edited 01-14-2000).]