CODEWITHSUNDEEP
ms-accessvbams-access-2007
user1914530
user1914530

Reputation:

Split database: where are queries located and how to view SQL?

I'm redeveloping an Access + VB based application to C# and SQL server. I am working with the split versions of the Access database. In the front-end file when in design view I see code like this for some event routines to lookup a value from a query:

DLookup("someField", "someQuery")

This is probably simple but I cannot find where "someQuery" and queries in general are located and how to view them. They don't appear in the backend file and I can't see how to list them in the front end file. I haven't had any luck searching the net only that this suggests they are located in the front end file. How can I view the SQL for these queries?

Upvotes: 1

Views: 692

Answers (1)

HansUp
HansUp

Reputation: 97131

Since you are unable to open the Navigation Pane, you could create a new db file and import queries from the front end into the new db (see the Import section of the External Data ribbon). Without the linked tables, those queries will be non-functional, but that effort will allow you to identify which queries exist and you may examine their SQL if that is helpful.

You could even create links to the back end tables and import anything else you may need from the front end db.

Upvotes: 0

Related Questions