CODEWITHSUNDEEP
ms-access
Pam
Pam

Reputation: 11

Access 2010: Can't access query after splitting DB

I split my DB and now when I try to change some information on a few queries, I can't access them. I have a front end and a back end and understand that I should make changes to queries/forms via the front end, but they are grayed out and inaccessible.

At this point, I tried unsplitting the DB (which I believe I did), but I still can't edit those queries or forms.

I can click on the query/form and see the result of it, but I can't get to design view to edit it.

Upvotes: 1

Views: 1698

Answers (1)

Scotch
Scotch

Reputation: 3226

I'm taking a shot in the dark and saying that in the process of splitting your database, you either created your front-end in an accdr or accde format (a runtime application). The purpose of this is that you shouldn't be able to open queries or forms or tables in design view on the front end. You can just open your database and save it again as an accdb file and continue as normal.

If you're having other problems with the linked tables, I suggest you open the Linked Table Manager and refresh the links (if you moved the backend file, this is necessary).

I would recommend trying to proceed as normal by using Shift Bypass just to be sure. ( Hold the shift key when you start the database. Then attempt to modify in design view).

If these fail, I would attempt to copy the queries and /or forms if possible and create new ones.

Upvotes: 1

Related Questions