CODEWITHSUNDEEP
ms-accessvba
user3290334
user3290334

Reputation: 83

How to open program made by access in design mode?

I have a program made and developed by Microsoft access 2003 but i can't open it's VBA code or see any tables or use the design mode even by using alt + F11

it's only open the program interface

so how i can do this?

Upvotes: 5

Views: 51125

Answers (2)

kiks73
kiks73

Reputation: 3758

You can do this by pressing shift key while opening the mdb.

Upvotes: 5

Albert D. Kallal
Albert D. Kallal

Reputation: 48989

If the application has been compiled to a mde (or accDE), then design mode will not be available for forms/reports and VBA code.

Assuming you have an mdb or accDB (not an mde or accDE in which design changes are NOT possible), then you should and can modify the application.

The first suggestion to hold down the shift key during application startup usually works. However, the shift key can be disabled. That being the case, then simply create a new blank database and then import all objects from the original - this thus will allow you to launch/open the application without any startup code running.

Upvotes: 17

Related Questions