What is the method to hide ms access database from users while data entry is made thru front end screen in VB?

Question

What is the method to hide ms access database from users while data entry is made thru front end screen in VB?

Answer 1

This may or may not be the kind of information you are looking for:



►To lock the database (prevent others from opening the database while you have it open)◄

Open the database

From the Menu Bar: Select Tools, then Options

In the Dialog Box that opens, Select the Advanced tab

Click the Exclusive option (Radio Button under "Default open mode")



►To specify what is available to user(s)◄

Open the database

From the Menu Bar: Select Tools, then Startup

A Dialog Box opens, allowing you to:

Show/Hide the database window

Show/Hide the Status Bar

Contol what menus and shortcut menus are available

Enable/Disable Special Access keys



§

Answer 2

Unfortunatly it is very difficult to secure an access db... because there are several freeware tools out there that can tell the user the password of the access db even if its protected. The simplst way to secure the db from outside editing is a simple trick I learned while doing the same type of project... Change the first couple of bytes of the database file so that when the app is closed, if opening the db is attempted the user will get an error saying "Database format is not recognized", but when you open the db in the program, have it change the first couple bytes back to the original, open the db, update, change or whatever, then after you close the db, change the first couple bytes so they are wrong again.

Answer 3

Easy:

Goto TOOLS>>STARTUP

Then click-off "Display Database Window" and Select your entry form from the "Display Form/Page" Drop list

Also, Click off the "Use Access Special Keys" (so they can't hit F11 and view the DB window.



To by-pass these settings, hold down the SHIFT key.



You could also (just in case someone knows how to by-pass it) Right click the table, Select PROPERTIES, and CLICK-ON "Hidden".



An added "safety" would be to make the Table(s) links to another DB tucked away where only YOU know. (Then No-one can modify the Table structure from the front-end db EVEN if they By-Pass and UNHIDE).



Lastly, make the Front-end into a REPLICA MASTER

TOOLS>>REPLICATION

Then distribute Replicas to people to keep on thier Desktop. Replicas CANNOT be modified in Design view. Just make sure You have LInked the tables to a network DB, so everyone adds data to the same Tables.

Answer 4

You need to look into "securing an access database". Check out the link below at Microsoft.



The Data Analyst - http://www.squidoo.com/thedataanalyst

Answer 5

1. Create a form and give it a name.

2. Click on "Macros" --> New

3. Under Action --> Open Form

4. Under Action Arguments at bottom, use drop menu by Form Name and choose the name of form you want to open at startup

5. Use the next field under Action, at top of screen. Use drop menu to select "maximize"

6. Click disk icon to save

7. Name the macro "autoexec"

8. Click "OK"

9. Close Access program and try it out.



Then, when you want to access the back-end yourself, hold down the "shift" key when you click to open the file.



Email me at [e-mail] if you still need help and I'll walk you you through it.

.

.

.