reference to Back end

  • Thread starter sigava77 via AccessMonster.com
  • Start date
S

sigava77 via AccessMonster.com

Hi,
Is there any way to reference to Backend trough code?
Thanks,
Carla
 
J

jahoobob via AccessMonster.com

Dim db As DAO.Database
Set db = OpenDatabase("C:/mydata/dbbe.mdb")
 
M

Marshall Barton

sigava77 said:
Is there any way to reference to Backend trough code?
Click to expand...


Choose any table linked to the back end mdb. Let's say it's
named tblXXX. Then you can use this kind of code to avoid
having to hard code the path to the back end.

strBEpath = Mid(CurrentDb.TableDefs!tblXXX.Connect, 11)
Set dbBE = OpenDatabase(strBEpath)
 
Top