Hi everyone, today I was doing a client consultation and came across a strange issue.
Access 2010 was ignoring my request to open an .adp file, or Access project file.
Access was ignoring the request to open “adp” files. Normal Access files “accdb” opened fine.
I found the solution to be adjusting the security settings for the Access program.
You have to open Access and go into the Access options, click on Trust Center, then every “not open” option
needs to be switched to all opening. Go into the macro settings and other settings and just
enable opening for everything. If you need to, be more restrictive with your selections later, but
do this now just to make sure the database opens for you.
Now the program (adp file) opens fine.
I hope this helps someone who is “googling” furiously.
Erik
Shared Access Database Management
Here is a handy setup for those who need to manage a shared access database. Either you can create this from scratch as per the example or add the new tables to your existing database. This setup will track: 1. the users currently using the database 2. what time the user and computer name currently […]
Access Database Users And Permissions Example
This post is a compilation of two of my previous posts: https://vbahowto.com/ms-access-object-security/ https://vbahowto.com/ms-access-login-form-revised/ This elaborates on the two posts a bit: First, here are all of the database objects: There are 2 tables here: tblLogin and tblAdmin Here are the main forms: frmLogin – this is the form that opens when the database opens Here […]
MS Access Object Security
Today’s post is based on a question that I received. We are going to assume that there are multiple users who have rights to view different database objects. So in this example there are 3 user logins with different rights to access 3 forms and 3 reports. Here is an overview of the database setup: […]
How To Connect Access To SQL Server On Amazon Virtual Machine
In this post I am going to show you how you can connect your Access database to a Microsoft SQL Server 19 running on an Amazon Virtual Machine. Something great about the current technology is that you can have a version of something that would cost you BIGGGGGGGG Money in the past! In this case […]