V
Vaughan
I have a custom form with a combo-box control. The Combo-box is populated
with data from an Access database using DAO. It works fine, but there's one
minor issue with remote users. If they aren'e connected to the company
network, they obviously can't populate the combo-box and the form errors out,
which is fine, but r_e_a_l_l_y s_l_o_w_l_y, which is not fine.
The problem is that the error is generated by this line of code:
Set DatBase = DBEngine.OpenDatabase(strDBPath & strDBName)
I'm sure if I knew how to test whether strDBPath was a valid path before
calling the OpenDatabase object, it would be seconds quicker, but I don't
know how to do it. This must be easy, but I don't really know where to start
with it.
Can nyone advise?
Thanks in advance
Vaughan
with data from an Access database using DAO. It works fine, but there's one
minor issue with remote users. If they aren'e connected to the company
network, they obviously can't populate the combo-box and the form errors out,
which is fine, but r_e_a_l_l_y s_l_o_w_l_y, which is not fine.
The problem is that the error is generated by this line of code:
Set DatBase = DBEngine.OpenDatabase(strDBPath & strDBName)
I'm sure if I knew how to test whether strDBPath was a valid path before
calling the OpenDatabase object, it would be seconds quicker, but I don't
know how to do it. This must be easy, but I don't really know where to start
with it.
Can nyone advise?
Thanks in advance
Vaughan