Initiate code with external database closes?? 1

[xsnrg]

I have a timer code that does the following...
1. Sets a time value to now
2. Performs an action
3. Sets an end time value to now
4. Displays message box with elapsed time

Very simple...

However, I have some actions that take place in an external database.

I have code that opens an external database. Upon opening, that other database runs code and then closes. How can I set code in my front end database to run when the other database closes...
OR
How can I put a pause between steps 2 and 3 above and have my code wait until the other database has closed to resume?



McLean Jones
buddycenters.org
"Believing is Seeing

 

[SiJP]

Check for the ldb file...

e.g.

Dim strYourDB as String
dim strCheckFile as String

strYourDB = "C:\Mydb.mdb"

        'Check if ldb file exists..
        strCheckFile = Dir(Left(strYourDB, Len(strYourDB) - 3) & "ldb")
        If strCheckFile > "" Then
            Do While strCheckFileNotLocked > ""
        strCheckFile = Dir(Left(strYourDB, Len(strYourDB) - 3) & "ldb")
            Loop
        End If

hth's

------------------------
Hit any User to continue

 

[SiJP]

Sorry cocked up on one of the variables (comes from ripping my own DB to shreads )

Do While strCheckFile > ""
strCheckFile = Dir(Left(strYourDB, Len(strYourDB) - 3) & "ldb")
Loop

...

------------------------
Hit any User to continue

 

[xsnrg]

Fantastic help!
That works great. Didn't even think about looking for the ldb file. Great idea and very simple.

McLean Jones
buddycenters.org
"Believing is Seeing