Help Help Help Pleeeease

[BrandonSk]

Hi everybody here!

RSINGH suggested that I ask you here for your help! We are aparently dealing with some sort of a strange behaviour of Access. Have a look at the "ALMOST THERE ... who will ..." thread in Database section to see all the details /it's got pretty big by now/.
Just to narrow it -> I link to a file in Access and that file gets opened (ldb file is created)
Then I remove the link but the linked file remains opened.
Anyway to force it to close?
I have no idea about API but I know it sometimes can do miracles.

Please! Help!

[mlewis]

How are you linking to the file?

[BrandonSk]

I am linking through Reference object:

Set RF = References.AddFromFile("DB2.mdb")

That's all. If there's a public sub in DB2 then I can call it now. All that works except that after I do:
References.Remove RF
Set RF=Nothing
the db2.ldb doesn't disappear.
Now interesting is that when I linked the same way to an empty database (let's say DB3) the db3.ldb did not even appear. So I think the problem lies somewhere in my DB1 and I will be stuck adding tables, forms and modules one by one.
Unless you could help

Thanx.

[BrandonSk]

OK. Small but significant change!
The "ldb" gets created even when refering to an emptz database. I don't know how, but one time when I tested on NT it didn't. Now it shows up both W95 and NT.

I don't care how I just want to close that DB!

Thanx if you can help me, thanx if you @ least looked here

PS: If possible, submit threads to the ALMOST THERE ... thread in database development. Here it's ok, but I have to do everything twice this way.