How to check if a file is opened by another user?

[gundie]

I'm using Access 2000, in VBA, how do I check whether a file (an Excel file) is opened, or in used, by another user?

 

[genomon]

Here ya go!

http://support.microsoft.com/kb/209189

The three most dangerous things in the world are a programmer with a soldering iron, a hardware type with a program patch, and a user with an idea.

 

[gundie]

Thanks genomon! Works perfectly!

 

[genomon]

Cool

The three most dangerous things in the world are a programmer with a soldering iron, a hardware type with a program patch, and a user with an idea.