ADO Data Control, Refresh Method, and ldb file

[vladk]

Hi,

I am maintaining the old application that uses Microsoft ADO Data Control. I noticed, that when the application ends, it always leaves ldb file, which is not I would expect.

I researched the code and found that ADODC Refresh method creates the ldb record-locking file. I tried to play with various properties and methods of that control but could not get rid of the ldb file.


Can anyboby help me find out how to remove the locks after the Refresh so when the program ends, only mdb file would remain.

Thank you!

vladk

 

[genomon]

The ldb file is created by the Access installation, not the program. When you close out Access, the ldb should delete itself.

I have great faith in fools; self-confidence my friends call it.
-Poe

 

[vladk]

genomon,

Thanks for the reply. I meant, ldb file appears when line with Refresh method executed. Access appears to be closed after the program's end but the ldb file still persists in the directory. And if it was not closed, how would I know which instance of Access to close in case there are several of them?

vladk

 

[CaptainD]

This is a guess, but, are you using ADO to create the connection to the database, and if so, are you closing the connection after getting your data?

 

[JerryKlmns]

vladk,

Your users do have delete rights on that folder, don't they?
A connection opens, an ldb is created. When ALL connections to that mdb close, ldb is automatically deleted. Opening that access with MSAccess.exe, opens a connection - workspace.

 

[vladk]

Hi guys,

Yes, this application uses ADODB.Connection. It indeed closes and sets to Nothing the connection. But this line:
adoLookup.Refresh '(adoLookup is ADODC)
either opens or reopens database that leads to the ldb file.

I found some kind of solution: I added these lines in UserForm_QueryClose event:

adoLookup.Recordset.Close
Set adoLookup.Recordset = Nothing

It eliminates the ldb file, but the latter line causes this message:

"Data source name not found and no default driver specified."

I believe, something should be adjusted in my PC regarding DNS settings to get rid of this message. But the additional problem is that this application is in use by many people, which do have delete rights on that folder, but not necessarily have the proper DNS settings.

Thanks

vladk

vladk

 

[JerryKlmns]

I don't think this line is accepted
Set adoLookup.Recordset = Nothing

But ... I don't use that ADODC any more since the 1st time I did.

 

[vladk]

Well, I don't like this line either. But I need somehow negate that Refresh. ADODC is something that is given to support...

 

[vladk]

I solved it:

adoLookup.Recordset.ActiveConnection.Close

vladk