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 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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:)~
|
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)?...
|
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
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
| |