November 8, 2005 at 8:10 am
There is an access db in our system which needs to be migrated to SQLSERVER.
Whenever I open this db, the interface comes up. How to disable this/see the underlying tables/queries ...
Maybe there is a macro that gets fired on open.
thanks,
-ch
November 8, 2005 at 10:55 am
you can put the anti-open in the autoexec macro
If this one exists, it will be executed first.
Have a look at securing Access sites how about to hide the main window, to disable the shift (bypass) key.
http://www.drewslair.com/desk/access_series/add_security.htm
There were/are(?) some problems with password protected access databases
November 8, 2005 at 2:23 pm
All I wanted to see was the underlying tables ...
On the open db prompt , I get a security warning message with 3 options:
cancel open MoreInfo
I say Shift+Open, the I get the std access menu: tables/forms ...
thanks,
ch
November 13, 2005 at 12:11 pm
There are two places in Access that usually cause a form to open automatically: the AutoExec macro and the "Display Form/Page" property found under Tools -> StartUp. Usually the Shift key will allow you to bypass these. OR once the app is open look at Window -> Unhide to see the database objects. All of this can be locked down and is likely to be locked down if you have purchased this through a software vendor.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply