468,287 Members | 1,905 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,287 developers. It's quick & easy.

share an access03 database sitting on server2003

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
1 1621
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.

Similar topics

reply views Thread by Tim Tyler | last post: by
2 posts views Thread by Robizzle | last post: by
24 posts views Thread by Hardy | last post: by
2 posts views Thread by irfan saeed | last post: by
2 posts views Thread by Amihai | last post: by
2 posts views Thread by Mailing Lists | last post: by
17 posts views Thread by IC1(SW/AW) | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.