Importing into Access - Can I tell who has file locked

[SBendBuckeye]

I am importing a file via DoCmd.TransferSpreadsheet. If the file is opened by someone else I get a 3051 error. Is there a way to tell who has the file opened so I can include their name in a message box explaining why the import did not work?

Thanks in advance for any help or suggestions!

Have a great day!

 

[Nikita6003]

Try parsing the ldb file - it's readable in notepad & therefore can be opened & read using VBA. This gives a list of all users/PCs with the .mbd opened.

HTH

Cheers
Nikki

 

[SBendBuckeye]

Hello Nikki,

Thanks for the response which engendered a couple more questions, if you would be so kind.

A. How do you reference the ldb file you mentioned? I've never done that before and didn't even know it existed.

B. Will the information in that file pertain to the Excel spreadsheet I am trying to import? I was not quite sure of that based on your response.

Thanks again for your helpfulness. I am usually on the Access forums but have recently spent more time here because of my current project. I have appreciated your contribution in other threads as well.

Have a great day!

 

[Nikita6003]

Well, the ldb file tells all about the access file rather than the xl file - could you let me know which version of windows are you running under?

Cheers
Nikki

 

[Nikita6003]

Oh, and which xl version?

 

[SBendBuckeye]

I'll do that on Monday when I get to the client site. I don't know it off the top of my head. Thanks!

 

[Nikita6003]

Okay, here's a start anyway:

there's a API call GetUserName (not quite sure, but I've got full info atw ork - like you ;-)) which'll allow you to get a list of users accessing a file on NT & Win 2k

If you're using xl 2k or higher, you can use the Property UserStatus to find out which user(s) is(are) currently accessing a file. It's a property of the workbook

More 2morrow ...

Cheers
Nikki

 

[SBendBuckeye]

PC O/S: Windows98
Office Suite: Office97
Lan: WinNT (I think)

Not sure how to tell on the LAN. I did a set statement in DOS to look at the environment variables and didn't see anything that looked significant in that regard. Since I am at a client site, I am not sure who to ask either.

Have a great day and thanks for the help!

 

[SBendBuckeye]

I'm pretty sure the LAN is NT because they are getting ready to roll out Win2K and take away user access to local drives.

Hope this helps!

 

[Nikita6003]

Right - in that case your best bet's using the API call; I've looked up some stuff here & there

Try this link for some code to pick up the holding user's username:

http://p2p.wrox.com/archive/vba_excel/2002-11/29.asp

HTH

Cheers
Nikki