Help Secure Access 2007 Database

Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.

Help Secure Access 2007 Database. Well its obvious to get worried as it contains huge of your crucial data. Dont want them messing with forms or queriesor even knowing they are there.

Microsoft Access Form Cascading Combo Boxes Microsoft Internet Phone Access Database
Microsoft Access Form Cascading Combo Boxes Microsoft Internet Phone Access Database from www.pinterest.com

Access databases can be encrypted and the Access 2007 ACCDB format provides advanced encryption of older versions. In Access XP and earlier choose Database Utilities from the Tools menu and then select Make MDE File. Like Eric Lippert said this wont make it totally secure you need to decide what will be secure enough Share.

In Access 2007 click Make ACCDE in the Database Tools group on the Database Tools tab.

Now you have entered the Access Option window go on to click the Trust Center button at the left bar. Edit existing data in the database such as changing the current location of an item. Quit any Office 2007 programs that you are running. Use tables attached to a database that has security SQL Server MySQL or attach tables from an MDB and manage them in an older version of Access.