If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Last question for this week - I promise
Folks,
Thanks for all the help in getting my first database up and running. I'm showing it to my management team tomorrow, so wish me luck. I do have one or two other things I would like to fix before then. I went into Access 2003 Tools | Startup and selected the form that I want to start up when a user clicks on the icon. And for the user, that is all I want them to see is that particular form. Right now when I click on my icon, the form comes up, but behind it is the database list of objects (tables, forms, etc). Is there a way to turn that off so they don't see that list of objects? I want to be able to get to them myself, for editing purposes, but I would like my users not to see that. I'm afraid I could turn them off and never get them back myself. Also, if I put this database on a network share for multiple users to access it, can more than one person have it open at a time, or do I need to do something to allow that. Currently it's just a .mdb file. Thanks again. Mike |
#2
|
|||
|
|||
Last question for this week - I promise
Under Tools | Startup, uncheck the box for Show Database Window.
The user now won't see the database window. When you want to see it, press F11. Alternatively, hold down Shift while opening the database. Access is designed to be a multi-user program, so you don't have to do anything special for it to cope with multiple users changing the data at the same time. However, I would strongly recommend that you split the database. If that's a new concept, see: Split your MDB file into data and application at: http://allenbrowne.com/ser-01.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Mike" wrote in message ... Folks, Thanks for all the help in getting my first database up and running. I'm showing it to my management team tomorrow, so wish me luck. I do have one or two other things I would like to fix before then. I went into Access 2003 Tools | Startup and selected the form that I want to start up when a user clicks on the icon. And for the user, that is all I want them to see is that particular form. Right now when I click on my icon, the form comes up, but behind it is the database list of objects (tables, forms, etc). Is there a way to turn that off so they don't see that list of objects? I want to be able to get to them myself, for editing purposes, but I would like my users not to see that. I'm afraid I could turn them off and never get them back myself. Also, if I put this database on a network share for multiple users to access it, can more than one person have it open at a time, or do I need to do something to allow that. Currently it's just a .mdb file. Thanks again. Mike |
#3
|
|||
|
|||
Last question for this week - I promise
Thanks Allen. This makes sense.
Mike "Allen Browne" wrote: Under Tools | Startup, uncheck the box for Show Database Window. The user now won't see the database window. When you want to see it, press F11. Alternatively, hold down Shift while opening the database. Access is designed to be a multi-user program, so you don't have to do anything special for it to cope with multiple users changing the data at the same time. However, I would strongly recommend that you split the database. If that's a new concept, see: Split your MDB file into data and application at: http://allenbrowne.com/ser-01.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Mike" wrote in message ... Folks, Thanks for all the help in getting my first database up and running. I'm showing it to my management team tomorrow, so wish me luck. I do have one or two other things I would like to fix before then. I went into Access 2003 Tools | Startup and selected the form that I want to start up when a user clicks on the icon. And for the user, that is all I want them to see is that particular form. Right now when I click on my icon, the form comes up, but behind it is the database list of objects (tables, forms, etc). Is there a way to turn that off so they don't see that list of objects? I want to be able to get to them myself, for editing purposes, but I would like my users not to see that. I'm afraid I could turn them off and never get them back myself. Also, if I put this database on a network share for multiple users to access it, can more than one person have it open at a time, or do I need to do something to allow that. Currently it's just a .mdb file. Thanks again. Mike |
Thread Tools | |
Display Modes | |
|
|