Database Security

shelbylk

New Member
Joined
Aug 9, 2006
Messages
2
I'm not sure if this is possible, but...is there any way to restrict users access to the datasheet and design view of a table and still have them input from a form?
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Yep. You need to create your interface so everything is form-driven. Then do the following:

1. Create a menu form for navigation. Create a button on every other form that takes you back to the menu when the form closes.

2. In Tools > Startup, pick the menu form from the Startup Form drop-down list. Also deselect Show Database Container. Close the file and re-start. You will see the menu form, and users can navigate to the other forms using the buttons provided. If your database is not too complex, you can use the Switchboard Manager to build a menu form (Tools > Database Utilities > Switchboard Manager).

Note: Users can still bypass the startup options by holding down the Shift key when they launch the DB. You can prevent this by deselecting the Allow Bypass Keys option in Tools > Startup, but be careful! You may lock yourself out of Design view if you want to make changes.

This is a very high-level answer to tell you what's possible. Post back once you have worked out how you want to proceed, and we'll point you in the right direction.

Denis
 

Forum statistics

Threads
1,141,587
Messages
5,707,258
Members
421,498
Latest member
matinebi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top