How to go to see the backend Access Database?

[dollygg]

HI all,

I created an Access database application 10 years ago. The Front end is Forms that I created, the backend is query, forms , tables. Every time When I double click on the mdb file, the main form (that I created) appear. How to see the backend ? Should I press ALT+F8 or ALT+F11 ? ( I totally forgot about it and I am using a laptop computer now.)

[CJ_London]

the backend is query, forms , tables

backend should only contain tables so not sure what you are doing here

If the db is split you need to open the back end file. Otherwise open the navigation window (pressing F11 will usually do that unless you have code to disable it) and you will see the tables you are using there.

The other thing you can try is hold down the shift key before double clicking the file to open - this will prevent any forms from opening.

It may be your mdb opens another instance of access for your 'backend' either when you open it or on the click of a button or similar in which case you need to inspect the code to find the bit that does that and you should be able to find the path

[dollygg]

thanks! the SHIFT key works. I could see the backend now.

[ArviLaanemets]

In case you really have front- and backend files, then in navigation pane of front-end you see links to tables in back-end file, not real back-end tables. (It will be enough when you need to check table structures)

[Emmanuel]

From what am seeing here, I doubt you’ve split the database.
Is recommended you do that ASAP to prevent any loss of data in case any eventuality.