I cannot open in exclusive mode since I am sharing the
database on the server. Using adShareDenyWrite will
prevent the creation of the ldb file if openning the mdb
I tried your code with an Access 97 database and I don't receive an error. However, the Mode
property is being ignored for a linked table. It doesn't matter what value I specify, an LDB file is
always created when I open the linked table in Access. This could be because the version of Jet used
in Access 97 (3.51) does not support it directly.
I can look into XP or 2000 if that is what you are using.
Microsoft MVP (Visual Basic)