Hello CJ_London.
Sorry that I forgot to mention that the accde file has no table inside (except the table that use to store the backend connection password). All the tables are at the backend.
Those tables will link when the user open the accde file (of course first undergo a series of...
Anyone know the way to 100% secure your accdb/accde file ?
What I mean secure is disable the ability to modify and see the design structure of the tables, forms, VBA code, etc. This is very important once you finish it and ready to distribute it to your users.
Below are the tasks I made to...
Just want to make sure Access Runtime 2013 and 2016 can run on Windows Server 2012 R2 or not.
As the official download site said Supported Operating System has only
Windows 10 , Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012
Debug > Compile has no error. But when the app need to deal with Excel, error 429 show and indicate the error at
set xlXL = CreateObject("Excel.Application")
Didn't try to install an older Office on the same Windows.
I create an accde by Access 2013. And "Microsoft Excel 15.0 Object Library" is need and was added.
This accde is suppose to run on those Windows which has Access Runtime 2013 64bit installed.
Problem arise if the Windows have no Office 2013 install. Because "Microsoft Excel 15.0 Object Library"...
I know the normal way to change the Application Icon - by go to "Access Options" > "Current Database" > "Application Icon" > Browse for an ico file
But this not work if the path to the ico file is no longer valid.
Since I only need the customized Application icon in the compiled accde file. Can...
I made an AutoExec macro in my accdb . Every time Access start, a "Marco Single Step" popup show and require to click on "Enable Content".
I want to get rid of these, at the same time don't want to lose the security measure. Then I found this webpage...
Hello tvanstiphout. Thanks for the tips.
According to the link you provided. I reference to the file "Win32API_PtrSafe.txt" and made the below changes. Now it works
Private Type WKSTA_USER_INFO_1
wkui1_username As LongPtr
wkui1_logon_domain As LongPtr
wkui1_oth_domains As LongPtr...
Thanks to The_Doc_Man and Galaxiom
I think I'm going to choose SMB 3.0 as the backend accdb is store in Windows Server 2012.
I don't really care the user copy the backend accdb file. As my frontend accde won't show the location of it. They can copy it only if they know where it is. Anyway...
The plan is:
1. A password protected backend accdb place in the network share drive
2. Frontend accde connect to the backend by the below code. The variable "theHashPass" store the encrypted password
dbs.TableDefs(strTable).Connect = "MS Access;PWD=" & theHashPass & ";DATABASE=" & LnkDataBase...
I want to set form access permission base on domain credential. Then I found the below link (Can download a code sample at the lowest part of the webpage)
http://www.accesssecurityblog.com/post/2011/02/05/Securing-Access-databases-using-Active-Directory.aspx
It not work in my domain joined...