Preventing user from opening accde directly but only via another access database. (1 Viewer)

Micron

AWF VIP
Joined
Oct 20, 2018
Messages
1,757
I recommend you wrap Command in the Trim function. I once found that in an extra space got added to the value. No idea why, but it was as if you could only pass strings in chunks and anything less got padded. I passed Otto Mayshun and a trailing space was passed to the Command function. Someday you might use this with a word that has a different length and wonder why it doesn't work.
 

isladogs

CID Moderator
Staff member
Joined
Jan 14, 2017
Messages
12,338
For info, I have just created a thread in the code repository showing how the UserControl property can be used to restrict how an application can be opened:
https://www.access-programmers.co.uk/forums/showthread.php?p=1654125#post1654125

It includes two simple examples each containing a Starter app and a Main app, each with one form:
a) BlockDBOpenDirect (similar to this thread request) - the Main app can be opened via the Starter app but cannot be run directly
b) BlockDBRemoteAccess - the exact opposite - the Main app can be run directly but cannot be opened remotely using automation
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom