Database locked? can't export

[HerberMA]

Access 2000- says database is locked and TransferText will not work (Error 3027) to export a table. Single user system, all properties boxes for db and files show NOT locked.

I had been using Open recordset command but could not get it to work, so I deleted it. No where in the code does this command appear now. I have repaired and compacted, but still says is locked.

Thanks for any help.

 

[The_Doc_Man]

Look for a .LDB file with the same name as your database and in the same directory.

If that file exists when the database has been closed for, say, at least two minutes, delete it. Then try again.

THIS WORKS ONLY FOR SINGLE-USER, NON-SHARED DATABASES. If you do this to a shared database, I will disavow any knowledge of having made this suggestion. I'll swear it was my evil twin Skippy who said it.

 

[HerberMA]

Thank you for the suggestion. I can find no *.ldb except for the one created when I open the app and then it is deleted when I quit.

 

[ahemr]

Solution to TransferText and Error 3027

I just had this problem, and solved it. The file extension .txt needs to be in your code, or it can't create the file.

 

[CallMeAndy]

So what about when it is a word merge operation (getting the same 3027 error - single user setup) i.e:

DoCmd.TransferText acExportMerge, , "Incident Query", _
"..\FormsAndLetterTemplates\Case Brief for Internal Expert.doc"

N.B. In the actual code the full filespec is specified!