security
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 […]
How To Send Email With Access And Outlook VBA
There are 3 things you probably want to send from your Access application. You probably want to send an Access report or send an attachment(s). 1. Email An Access Report (SendObject) 2. Email An Access Report With Attachments (Outlook Automation) 3. Email With Attachment(s) (Outlook Automation) First, if you are in the database, and want […]
Access 2010 Ignoring Open Of ADP File
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 […]
How To Set Up Relational Database
I had a suggestion from a reader named “Dennis” after trying to gather information for a new database book. He responded: Erik, My suggestion is this: Make an easy tutorial to set up a database with tools on how to setup tables, link tables, how to set up keys on tables. Most tutorials tell users […]