By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,024 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,024 IT Pros & Developers. It's quick & easy.

share an access03 database sitting on server2003

P: n/a
Hi,
firstly, I am new to access03 and server03

Originally, I had written an access 2002 database.
Then, we transferred (for another reason) to server 2003.
Then, we got access 2003.
Then I wanted to setup the system in the following way:
The database (now in access2003) sits in a shared folder on the
server2003 machine. Anybody else who has access to that server and the
folder can open the database form that folder, add data, write
queries/reports/forms,... and save the changes on that file on the
server2003.

Here my questions:

1) I could open the access2002 database easily in access2003. So I
assume I don't have to convert it?

2) is the idea of sharing the database possible at all?

2.1) What happens if more than one person tries to access it at the same
time?

2.2) according to the access2003 help pages, this is relatively easy:
Share a database (MDB)
Note The information in this topic applies only to a Microsoft Access
database (.mdb).
To access the shared Microsoft Access database (Microsoft Access
database: A collection of data and objects (such as tables, queries, or
forms) that is related to a particular topic or purpose. The Microsoft
Jet database engine manages the data.) from another computer, you must
have one of following on the other computer: a local installation of
Access, a network installation of Access (licensed on a per-user basis),
or a run-time application.
- Set up a shared folder.
For information about sharing folders, use the Microsoft Windows Help
Index. If the shared folder is on a network server, you might need
assistance from your network administrator.
- Copy the Microsoft Access database to the shared folder.
- Make sure the Access database is set to open in shared mode, which is
the default setting.

3.) When playing with the system I somehow got into "security". There
are two parts to that
a) Only those users have access to the shared folder, that I provide
with the priveleges
b) Under tools -- security I can setup passwords and priveleges for
different users
Is a) alone sufficient? Or b) alone? Or both together?

3.1) Does somebody have good references (on the web) that explain the
issues here, especially the setup of a shared database and the security
issue? I was not very successful with google yet.
Thanks for your help,
Claus
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Even in Access 2002, you couldn't change the database design (e.g add forms,
reports, queries) while multiple users have it open. You won't be able to
do that in 2003, either.
"Best Practice" is to split your database, putting only the tables (back
end) on the server, while giving each user a copy of the front end (reports,
forms, etc) for their local desktop, and linking to the tables on the
server.
Now each user can customize the front end independently.

All users will need to have full permissions (create, delete, modify) on the
folder on the server where the back end resides.
"Claus Haslauer" <ch******@scimail.uwaterloo.ca> wrote in message
news:dk**********@rumours.uwaterloo.ca...
Hi,
firstly, I am new to access03 and server03

Originally, I had written an access 2002 database.
Then, we transferred (for another reason) to server 2003.
Then, we got access 2003.
Then I wanted to setup the system in the following way:
The database (now in access2003) sits in a shared folder on the
server2003 machine. Anybody else who has access to that server and the
folder can open the database form that folder, add data, write
queries/reports/forms,... and save the changes on that file on the
server2003.

Here my questions:

1) I could open the access2002 database easily in access2003. So I
assume I don't have to convert it?

2) is the idea of sharing the database possible at all?

2.1) What happens if more than one person tries to access it at the same
time?

2.2) according to the access2003 help pages, this is relatively easy:
Share a database (MDB)
Note The information in this topic applies only to a Microsoft Access
database (.mdb).
To access the shared Microsoft Access database (Microsoft Access
database: A collection of data and objects (such as tables, queries, or
forms) that is related to a particular topic or purpose. The Microsoft
Jet database engine manages the data.) from another computer, you must
have one of following on the other computer: a local installation of
Access, a network installation of Access (licensed on a per-user basis),
or a run-time application.
- Set up a shared folder.
For information about sharing folders, use the Microsoft Windows Help
Index. If the shared folder is on a network server, you might need
assistance from your network administrator.
- Copy the Microsoft Access database to the shared folder.
- Make sure the Access database is set to open in shared mode, which is
the default setting.

3.) When playing with the system I somehow got into "security". There
are two parts to that
a) Only those users have access to the shared folder, that I provide
with the priveleges
b) Under tools -- security I can setup passwords and priveleges for
different users
Is a) alone sufficient? Or b) alone? Or both together?

3.1) Does somebody have good references (on the web) that explain the
issues here, especially the setup of a shared database and the security
issue? I was not very successful with google yet.
Thanks for your help,
Claus

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.