Last question for this week - I promise

[Mike]

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

 

[Allen Browne]

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

 

[Mike]

Thanks Allen. This makes sense.

Mike

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