If I hold down the SHIFT-key and click on my access database the database boots up with the startup options! I can't get into my database even if I hold down the SHIFT key!! Help me, please
I know that I can startup MS-Access manually and bypass the startup options, including any macro that is set to run automatically, by holding the Shift key down when launching the application. I have:
Code: Public Sub AccessStuff() Dim myaccess As New Access.Application myaccess.OpenCurrentDatabase(" orfs006slsops_repts\_RS DevSOPSOP.MDB") Dim db = myaccess.CurrentDb() End Sub
which works nicely and opens the database just fine. However, this mdb has a startup macro defined in it. I can't hold down the Shift key since I'm doing this from a program. In this case, how can I bypass the startup macro?
I am able to bypass the shift key so I can disable ribbon and all menus at startup.
But the issue I have is anytime someone makes a copy of the database or it is their first time opening it they get prompted with the security warning:
"Security Warning - some active content has been disabled, click here to enable"
and it gives them complete access to see the back end of the database because while that warning message is popped up ... before they click "enable" they can go do anything in the database including see tables, data, and vba.
Once they click "enable content" that first time the bypass takes effect and the ribbon and all menus disappear, but if they dont click it they can navigate all around the db
I have a database with certain startup options for the end user. What I would like is for the database to prompt for a password ONLY IF the shift key is used to try and bypass the startup options, so that only an authorized person with the password can see the background of the database. If I simply set a database password from the Tools menu, it asks for that password with the startup options as well, and I actually locked myself out of a database that way! So there needs to be some kind of check for whether or not the user attempted to bypass the startup options, and based on that, ask for a password or not. I am not sure if I can do this through Access options directly, or I will require some coding, but either method is fine.
I thought I had this figured out, but apparently am still missing something...
When I start my DB, I get the default 'Security Warning' message every time asking if I want to cancel or continue... I thought this was an options setting under the Tools/Macro/Security setting. However, when I change this setting (default is Medium) to Low, exit Access and restart the DB I get the same warning message and the security setting is back to medium.
Am I in the right area to fix this? Why would my settings default back?
I am using MSAccess 2002. I have removed the tables and queries to reduce file size. I have set database password as "planning". In the form named "Form1" I have created a Shift-Key Enable/Disable button with password "SIMON". In Menu Starup, I have also disallowed Display Database Window, disallowed Built-in Toolbars and disallowed Toolbar/Menu Changes. Now I have problem because I cant unset the Security password and make changes in Startup.. because the Menu Tool/Security, Startup..etc have disappeared. How do I get them back again?
Hi All, i need some more help. I have an access application which has 6 different forms. The application will be accessed by 10-12 people. some can have an access to to all the forms and some may have an access to a few of them. How can I set up the password security for the users at application and form level? I also want to capture the audit trail when the user users edit form and makes changes to a record. I would apprecaite help on this one. Regards K
I have an issue which having read some previous threads may not be resolved simply. My database is password protected.
The password (presumably) is preventing the mailmerge from connecting the deata with the template. There is not even a password request shown. Is there any way that this can be overcome. There are a number of mailmerges but all are pulled from the same data query, can i unprotect this query only??
After convincing my boss that the dbase can easily run securely, your help will be very much appreciated.
I setup a splashScreen in startup, and I uncheked all check boxes. Now, as soon as I load database starup form shows, and does not allow to do any modifications.
Is there any way i can "Undo" or drop splashScreen, and get back to normal loading of database. Thank you.
Hello Guys, I have proj name m1.mdb which has forms and reports.I have 2 forms form1 ,form2.In form2 I have button that creates new database named m2_date.mdb and creates report and form1 by using property DoCmd.TransferDatabase acExport, "Microsoft Access", sFilename, acForm, "form1", "form1", StructureOnly, StoreLogin,now this form1 has to be seen first when any user doubleclicks m2_user.mdb,so my question is, is there any way i can setup startup form properties dynamically ,without using startup form manually from tool properties of toolbar. hope to get answer.. thanks vsap
Ok, I have a Forms_Menu that has many command buttons which control other functions of the database. What I want, is when a user opens access to have a page displaying a title, and then the Forms_Menu to open up automatically. Does anyone know how to do this???
Hi guys. I am stumped with a 45 second delay when I startup my application. I get the delay on networked workstations only when another workstation is up showing the Main "switchboard" form. Each workstation has their own copy of VBA (not compiled) with networked versions having linked tables to the server's .mdb
It seems like the workstations know that the main form is up somewhere else and need to negotiate with it. All have the (Access 2000) Default open mode to Shared, Default record locking to No Locks, and Open database using record-level locking On. :confused:
I am having a problem with my form. When it opens up, it is maximized, which is what I want. However, the vertical scroll bar on the right does not begin at the top of the form, but towards the bottom. I have to scroll up each time so that I can see the top of my form. Is there a way to make the form startup at the top of the form?
I am trying to display only my form on startup. Tools-Startup allows you to eliminate"Database window" default menu and toolbar but I can't eliminate "Microsoft Access" window.
I don't know if there are other settings that I am not aware of or there has to be code built.
Sorry if this is a really dumb question - I have just started using Access and I couldn't find the answer to this doing a forum search.
I have made a database consisting of a table and a form. All I want to do is get the form to appear automatically when the database is opened. I am using Access 2007.
I have a couple of buttons on a form that I am havinga little trouble with.
The first button increments an integer variable which changes the colour of a box dependant upon the value. When a new record is opened I want it to be 0 which sets the colour. So on the form load event I have put Status (variable identifier) = 0.
when a new record is pulled up the box is white, should be a different colour, vbgreen, when I click on the button to increment it changes, so where should I put the declaration so that for each new record the colour is reset to the starting colour.
The other slight problme that I have is that another button inserts the time into a memo field. If I click the button again it just over writes the previous time stamp.
Is there a way to put each new click on a new line? Also I want to preced the time stamp with a a statement like the frist click was at time(). The second click was at time(). So I guess that I need to just increment a var for each click to then wrire 1st click, 2nd click etc. But how do I get the "1st click text/2nd click" text and again where do I put this variable so that it begins at 0 for each new record?
I have been building a new db in my personal drive at work which has been working perfectly, until I transfer it to the main network drive so that others can use it.When I try to open it, I now get an error saying that windows cannot access the file (code 0x80070002) - although it does in fact open it anway, eventually.
I have removed and re-instated various bits of code, and discovered that it's linked to the 'Display Form' function within Access Options > Current Database, that I have used to open the form 'Homepage' when the db is opened. When the dropdown is set to 'None', the db opens fine, but when a form is selected, the error occurs. I have tried using an AutoExec macro to open the Homepage form, but this generates the same error too.
I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further :
I want to have a splash screen that loads as well. I have set the splash screen to the default form when the database opens. However, I am not quite sure how to get the other form to load in the background as hidden, AFTER the splash screen opens and appears. I tried calling it with the oncurrent event of the splash screen, but then splash screen wont appear until after the other (hidden) form has finished loading. I have tried different orders of events, but am having no luck getting the desired results.
Summary: I want the splash screen to show first, then the big form to open (hidden) in the background. The user can click on a continue button on the splash screen and then the main switchboard will open.
I was reading the threads related to bypass issues...
Now I know how to disable (or enable) shift key of a database with password using the code provided by ghudson: http://www.access-programmers.co.uk/forums/showthread.php?t=51479&highlight=bypass
In other thread he provided another way to enable or disable the shift key using another method: (developed by Ricky Hicks):
this one can easily disable or enable the shift key of any database... even if that is disable with the password protected method provided by ghudson...
so... my question... is there any method that will ONLY allow enable or disable the key with a password?