I've developed an Access .adp application (Access 2010/SQL 2008R2) which works fine - but if I try to rename a form or delete a form the sub menu that opens when you right click on the form has the Delete and Rename option greyed out.
I created a blank database and imported all the forms/reports/macros/modules successfully from the Access.adp front end database and connected the front end database to the back end SQL database but sill no joy with being able to rename/delete forms.
I have opened all tables/ forms - just to make sure there was no problems - everything opened as expected and I even recompiled the front end database - still no joy.
I have several other Access.adp databases running in the same PC/Server and all allow me to rename/delete forms/reports etc.
Is there some system setting that I should set on/off?
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…