Referring to BE from FE

  • Thread starter Thread starter Jim Evans
  • Start date Start date
Jim said:
How can I refer to the BE from the FE?


The path to the backend is contained in the Connect property
(DATABASE=path) of each linked TableDef.

If the BE is a JET mdb file:

path = Mid(CurrentDb.TableDefs!tablename.Connect, 11)
 
Thank you, Marsh.

Jim Evans

Marshall Barton said:
The path to the backend is contained in the Connect property
(DATABASE=path) of each linked TableDef.

If the BE is a JET mdb file:

path = Mid(CurrentDb.TableDefs!tablename.Connect, 11)
 
Back
Top