Could not use ‘’; file already in use.”

date:2008-01-19 22:10
author:geographika
category:bugs
tags:2147467259, ldb, OleDbException
slug:could-not-use-file-already-in-use
status:published
System.Data.OleDb.OleDbException occurred
  ErrorCode=-2147467259
  Message=”Could not use ‘’; file already in use.”
  Source=”Microsoft JET Database Engine”

Access, lock files, and Visual Source Safe - an accident waiting to happen! I got the above error, after my code had been fine for weeks. Googling turned up permissions on the folder with the Access database, and closing secondary applications. The solution in the end turned out to be that the .ldb file had come under source control. Removing it from this, and deleting the fle resolved the issue.

orphan:

Comments

http://www.gravatar.com/avatar/a2d36bff7011844d43ff02b099b30c7f?s=55&d=identicon&r=g

1. GBrian **

Hi,

In my case I need to pass data from local server to the linked one. If I use OpenQuery I need to convert every field to a string and concatenate them an execute de INSERT statement for each row.

Any other idea? Thanks.

Reply
http://www.gravatar.com/avatar/531e4f6319861732b2ecebd007667e77?s=55&d=identicon&r=g

2. Allan **

worked for me...thanks

Reply
http://www.gravatar.com/avatar/0fb56e68e4b010b3541bee6c25ad07c2?s=55&d=identicon&r=g

3. kenswdev **

Thanks for this! Exactly what I needed and worked perfectly.

Reply
http://www.gravatar.com/avatar/9dfc39d667196f07663943fa362d8cb5?s=55&d=identicon&r=g

4. Dave **

Nice! Thanks.

Reply
http://www.gravatar.com/avatar/bb93073c9137610d398aba72bfef0ad5?s=55&d=identicon&r=g

5. Corrin **

Worked perfectly, thanks!

Reply
Add Comment