Click a shortcut in the Open dialog box, or in the Look in box, click the drive or folder that contains the database that you want.
Double-click the database to open it in the default mode specified in the Access Options dialog box or the mode that was set by an administrative policy. Click Open to open the database for shared access in a multi-user environment so that you and other users can read and write to the database. Click the arrow next to the Open button and then click Open Read-Only to open the database for read-only access so that you can view but not edit it. Other users can still read and write to the database.
Click the arrow next to the Open button and then click Open Exclusive to open the database with exclusive access. When you have a database open with exclusive access, anyone else who tries to open the database receives a "file already in use" message.
Click the arrow next to the Open button and then click Open Exclusive Read-Only to open the database for read-only access. Other users can still open the database, but they are limited to read-only mode. In the list of drives, right-click the drive that you think might contain the database, and click Search. Since the search was initiated from the Open dialog box, you must click Cancel in that dialog box before the database will open.
Access automatically creates a new Access database in the same folder as the data file and adds links to each table in the external database.
To open one of the last several databases you had open, click the file name in the Recent list on the getting started page. Access opens the database with the same option settings it had the last time you opened it.
If the list of recently used files is not displayed:. Under Display , type a number in the Show this number of Recent Databases box. In a single instance of Access, you can have only one database open at a time. In other words, you cannot start Access, open one database, and then open another database without closing the first database.
However, you can run multiple instances of Access at the same time, each with a database open in it. Each time you start Access, you open a new instance of it. For example, to have two Access databases open at the same time, start Access and open the first Access database, and then start a new instance of Access and open the second database. Note: The number of instances of Access that you can run at the same time is limited by how much memory is available.
Available memory depends on how much RAM your computer has and how much memory is being used by the other programs running at the time. Each instance of Access runs in a separate window. Both settings work together. To access the Startup options, choose Startup from the Tools menu. In Access , click the Office button and then click the Access Options button.
Select Current Database in the left pane and you'll find these options in the Application Options section. Access doesn't have a Database window, but you can hide the Navigation Pane in a similar manor. That option is in the Navigation section just below the Application Options section. Deselecting the Display Database Window option will also disable the Startup command. Users can bypass all these options by holding down the [Shift] key while opening the database.
That trick's handy for you, but it leaves the database vulnerable to anyone else who knows about it. A user can also import objects into a blank database to bypass startup settings. Luckily, there's a bypass to the bypass. To close the bypass crack, set the AllowBypassKey property to False when the database closes. You can automate this process by calling the following code from a close task -- just which task is up to you:.
After setting this property during the close process, the database will ignore the [Shift] key bypass if one of your users is wily enough to try it. You can use this approach to set any of the startup properties. Does anyone have an idea why this is happening? It's driving me crazy. Follow Post Reply. Danny J. Does it appear when you press F11? Have you set the startup option to hide the window?
Shannon, In Access, after you've opened the db and can't see it, go to your File menu option and choose it from the recent file list. It will alternately open between showing and not showing the db window.
No, it doesn't appear with the F I'm familiar with all the startup options, and this seems to be something different. Moreover, it's happening with ALL my Access databases. With my Access 97 databases, I get a disk or network error followed by a low memory error. It's not something I've run across before.
Unfortunately, I've tried all that. I'm an Access programmer myself, so I've done a fair amount work with the startup options. This problem is happening to all my databases, even the blank ones.
I'm thinking it comes from a virus although I searched the virus sites and didn't find anything , or a security change I updated from windowsupdate the other day , or maybe from when I installed VS.
NET, but so far I've got no real clues. I'm tearing my hair out now David W. If it doesn't appear and the startup options for disabling that have not been set, do you see scrollbars?
Way back when, with some earlier service release of A97, occasionally the MDB file would relocate itself several screens down and to the right, with the result that I'd have both horizontal and vertical scrollbars.
0コメント