Accessing front-end or back-end of Access

[treviboy]

I have an Access application that has a front and back end. When I access the tables with ADO, is it correct that I am setting the database source to the front end because that's where the modules and queries are or do I set it to the back end? But, I am confused because I have a function that runs against tables using ADO. How should I have it set ?
thanks

 

[jadams0173]

Since your DB is split to a front and backend I'm assuming that all of you tables are linked to the frontend. If that's the case then you can access the tables using Currentproject.connection method.

If your talbes aren't linked the you would have to open a connection to the backend.

I tried to have patience but it took to long! -DW

 

[treviboy]

Thank you ! I appreciate the tip. I will try it. I'll post my results in case anybody is interested.