shared database
Hello peoples,
I need help with my project vs setting theft protection. db is split fronted and backend and I use protection with vba and here is my problem...
How I may lock/set security/protect this both shared database?
My problem:
If someone copy db to place it where is not function vba/macro then he may close security popup modal window and theft all data.
vba is set with password but when he want to get table, query, form etc. Is way how lock menu bar in ms access or set security in shared db with split db?
thnx for reply
I need help with my project vs setting theft protection. db is split fronted and backend and I use protection with vba and here is my problem...
How I may lock/set security/protect this both shared database?
My problem:
If someone copy db to place it where is not function vba/macro then he may close security popup modal window and theft all data.
vba is set with password but when he want to get table, query, form etc. Is way how lock menu bar in ms access or set security in shared db with split db?
thnx for reply
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
security when is enabled macro is no problem, I need anything when is only security warning with enable macro or macro is disabled...
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I am tested it but my front-end shared db show me error that my back-end db with password is in exlusive mode... so I must give the backend db for shared mode and then is all function again :/
Upload your databases (front-end and back-end).
I suspect something else is in the work.
The back-end shouldn't be in exclusive mode.
I suspect something else is in the work.
The back-end shouldn't be in exclusive mode.
ASKER
so if I have one db which is divided into two parts, in the first re forms, queries and reports and in the second re all tables then the second split db can't be in exclusive mode which re protected with password?
Is in this case frontend or backend? I thing that in the second db re all data and this db should be protect :/
Is in this case frontend or backend? I thing that in the second db re all data and this db should be protect :/
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
ok I have solution for first problem and both db re shared
1. delete connected tables in FE
2. open shared BE in exlusive mode
3. set encryption and close BE
4. import tables to FE, u must give your password
5. compact and repair
it's all
but how to set protection of FE if makro is disabled or not function?
1. delete connected tables in FE
2. open shared BE in exlusive mode
3. set encryption and close BE
4. import tables to FE, u must give your password
5. compact and repair
it's all
but how to set protection of FE if makro is disabled or not function?
You already accepted two conflicting answers and your proposed solution has nothing to do what what I suggested so you should not have awarded me ANYTHING.
Either reopen the question or start a new one.
Either reopen the question or start a new one.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
Problem is that this db must be shared for all users, I can't set password for backend db where is all tables with data...
with the popup modal window form is not good solution for security... when is not working macro then user know close this modal window with default close button and then may makr everything in option from menu bar in file...
I have this popup modal window form set without close system default button from proerty options and when is function macro all is good... when is not working then show me close button on form again and it does not matter ig is disabled...