469,619 Members | 2,200 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,619 developers. It's quick & easy.

strangest hanging problem with re-attaching functions...

I have some functions that will allow a user to attach to a different
back-end database. I added this functionality to the program Ribbon in a
custom Access 2007 app. I have 2 ways to attach to a different back end db.
One is through a browse function. So the ribbon button option calls a macro
that runs a procedure that allows the user to browse to the back-end db,
then re-attaches the tables.

So for the browse button, A macro is launched: StartProgram("Other"). If
"Other" is the mode, I put up a browse dialogue in the StartProgram

This works fine. All tables get properly re-attached, and the program
re-loads everything. Now for the problem.

I just added a new twist to the above where they can define their own
database locations into a table: tDatabaseLocations, the idea being that
they can switch to different databases at a single click, without browsing.
So, on program startup, I programatically add ribbon buttons for each db
that they define, and put an onAction call on the button (see proc below).
Each programmatic button I create is followed by a number. So when the
ribbon is built, it will have a series of buttons with button names such as
BtnOpenCustomDb1, BtnOpenCustomDb2, etc.. By finding the number at the end,
I know which db this relates to in their tDatabaseLocations entry.

The code below will show the correct db name, so the logic is working
(message box line that is commented out). The kicker is that it will get all
the way through all of the code in the proc called on the very last line:
Call StartProgram(dbnm)

However, when stepping through the code, when control is returned to this
calling proc (after running the Call StartProgram(dbnm) line), the program
just hangs. Since StartProgram uses many of the same variables, such as db,
rs, i, etc. I tried using different names in this proc, such as ddb, rrs,
ii, etc. All had no effect. I tried adding the DoEvents line, again no luck.
Lastly, I tried setting IRibbonControl to nothing and db to nothing, again
no affect.

So it will run all code in the StartProgram proc, but when it returns to the
proc below (WhichDbClicked), the program hangs. It appears to be treating
the call as a dialog (where it won't continue on to the last line until
StartProgram is complete). I think if it would simply execute the exit sub
line, while StartProgram is doing it's thing, all would be well.

Any ideas why it would be hanging?

Sub WhichDbClicked(control As IRibbonControl)
On Error GoTo ErrRtn
Dim ddb As Database, rrs As Recordset, recno As Integer, ii As Integer, dbnm
As String
recno = Right(control.ID, 1)
Set ddb = CurrentDb()
Set rrs = ddb.OpenRecordset("tDatabaseLocations", DB_OPEN_SNAPSHOT)
ii = 1
Do Until ii = recno
ii = ii + 1
'MsgBox "Database Selected: " & rrs!DBInternalName
dbnm = rrs!DbLocation
Set ddb = Nothing
Set IRibbonControl = Nothing
Call StartProgram(dbnm)
Exit Sub
MsgBox Err.Number & " - " & Err.Description & ", Function: WhichDbClicked",
Exit Sub
End Sub

Aug 30 '07 #1
1 1548
Ok, I figured this out, but for the life of me I can't figure the "why" of

Instead of using the line: Call StartProgram(dbnm) and passing the full
datapath: "C:\pc experts\develop\IQOFF2007\DatabaseNorth.accdb"

I added these 2 lines:

TempVars("WhichDb").Value = dbnm
Call StartProgram("Custom")

Then in StartProgram, if the passing variable is "Custom", I set a variable
DataPath to TempVars!WhichDb, then did the reconnecting of tables.

And oddly enough, the code now works perfectly. So the short of it is that
it had something to do with passing a long path to the StartProgram
function. The line causing the hang would have evaluated to a call like

Call StartProgram("C:\pc experts\develop\IQOFF2007\DatabaseNorth.accdb")
I wonder why that would be?
Aug 31 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Harlan Messinger | last post: by
25 posts views Thread by Shannon Jacobs | last post: by
reply views Thread by Onin Tayson | last post: by
1 post views Thread by =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?= | last post: by
5 posts views Thread by Stanimir Stamenkov | last post: by
3 posts views Thread by Microsoft | last post: by
2 posts views Thread by kj | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.