reference to Back end

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

sigava77 via AccessMonster.com

Hi,
Is there any way to reference to Backend trough code?
Thanks,
Carla
 
Dim db As DAO.Database
Set db = OpenDatabase("C:/mydata/dbbe.mdb")
 
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)
 
Back
Top