What mdb is local Access application looking at?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm running an Access application locally but, somehow, my local copy is
looking at another mdb database. It has a macro (which has Action: OpenForm
and Form Name: USysLoadingFrm) but I can't find that form anywhere.

Also, from the application I can see that it displays data that's not in any
of my local tables .

How can I see what mdb my application's using?

Thanks.
 
I'm running an Access application locally but, somehow, my local copy is
looking at another mdb database. It has a macro (which has Action: OpenForm
and Form Name: USysLoadingFrm) but I can't find that form anywhere.

Also, from the application I can see that it displays data that's not in any
of my local tables .

How can I see what mdb my application's using?
Click to expand...

If you name objects with a prefix "USys" they will be treated as system
objects and as such will be hidden unless you go to Tools - Options and
check "Display System Objects". Most likely the developer named a few
things this way to keep users from tampering with them. The mystery table
might very well be local but with the same naming convention to keep it
hidden. If it is actually in an external file you can find out where by
putting the following code in a module, running it, and then examining the
output in the debug window.

'(requires DAO reference)

Sub GetConnections()

Dim db As DAO.Database
Dim tbl As TableDef

Set db = CurrentDb

For Each tbl In db.TableDefs
If Len(tbl.Connect) > 0 Then Debug.Print tbl.Connect
Next tbl

End Sub
 
Back
Top