We help IT Professionals succeed at work.

shared database

Johny Rambo
Johny Rambo asked
on
93 Views
Last Modified: 2018-03-02
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
Comment
Watch Question

ste5anSenior Developer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Fabrice LambertConsulting
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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...

Author

Commented:
security when is enabled macro is no problem, I need anything when is only security warning with enable macro or macro is disabled...
Fabrice LambertConsulting
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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 :/
Fabrice LambertConsulting
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.

Author

Commented:
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 :/
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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?
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.