Avatar of Johny Rambo
Johny RamboFlag for Slovakia asked on

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
Microsoft Access

Avatar of undefined
Last Comment
PatHartman

8/22/2022 - Mon
SOLUTION
ste5an

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Fabrice Lambert

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Johny Rambo

I need protect all data in shared db as is possible for example exclusive mode...

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...
ASKER
Johny Rambo

security when is enabled macro is no problem, I need anything when is only security warning with enable macro or macro is disabled...
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Johny Rambo

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 :/
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Fabrice Lambert

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.
ASKER
Johny Rambo

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 :/
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Johny Rambo

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?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
PatHartman

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.