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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Front End Back End Connection Through VBA 1
date - regional setting 1
Updating a front-end and back-end database to the local machine automatically 3
Different results to same query 10
Proportion of Fields filled 1
Reference in Frontend to Backend table 4
front end and back end 4
Ghost references to deleted tables in a back end database (Access2000 XP) 5

Back
Top