473,320 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 1835
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Tim Tyler | last post by:
Windows Server2003 IIS SMTP Installed PHP VERSION: 4.3.3 Using Invision Power Board Mail sent from the IPB using PHP mail() ... (which is configured in php.ini to use...
2
by: Robizzle | last post by:
I've been working on some php scripts that I want to release under the GPL and I'm looking for the best way to share the code with everyone. I always liked websites that had a <textfield> and put...
24
by: Hardy | last post by:
I'm pretty new in this field. when reading some 70x material, I met with this term but cannot catch its accurate meaning. who can help me? thanks in advance:)~
1
by: jafries | last post by:
Sorry for such a n00b question, but does anyone know of a how-to on how to build access '03 template database like the ones that come with the DBMS (not template forms/reports but the whole DB)?...
2
by: irfan saeed | last post by:
How can i traverse through the direcotries sitting on a Network share. i used directoryInfo object, but somehow it does not work on UNC paths. any kind of assistance is appretiated. Irfan
2
by: Amihai | last post by:
hi, I have an ASP.NET application functioning properly on Windows 2000/iis5, built using Visual Studio 2003. The application use viewstate. when move the application to other computer using...
2
by: Mailing Lists | last post by:
ASP.Net 1.1, Windows Server2003, latest SPs, Corporate Intranet Environment We have a valid network share in the "file://machinename/share1/share2" format. A user typing it into IE browses to...
17
by: IC1(SW/AW) | last post by:
I am trying to create a unique type of registration form for my job upcoming Holiday Christmas Party. There will be 60 tables for seatings with 10 people max at table. How can I write some...
1
by: abhu50 | last post by:
hiiiiiiiiiiii to all of you ,,,,,, i am new to this forum,,,,,,i have one problem regarding sharing internet i dont know how to share it. i have one...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.