One of the more challenging things on my app's wishlist is to make it
multi-user on a LAN.
For the record my app was always intended to a single-user but things have
changed. It's mostly composed of bound forms handling records numbered in
the hundreds, sometimes a few thousand. The code of course refers to tables
in the local mdb.
I allow the user to create external backups of the tables in the database
and to restore them. Because of this feature there is no workgroup security
as I have to allow enough permissions for these backup/restore tasks to
work.
After opening the app I allow different users to be created to access
different areas - this also restricts the tables they can backup or restore.
In a network scenario I guess I would need to split the database and put the
tables on a server.
I would like any user to be able to log on from any workstation and use the
app according to their level of access.
I would stop the existing backup/restore functions obviously but how would I
backup the tables on the server? (Creating an external mdb with backed up
tables is quite useful to us).
The tough part would be rewriting the code to refer to the server,
implementing locking etc.
I'm wondering whether to implement workgroup security given that the tables
will be on the server and the front-end will be a locked down MDE using the
Access Runtime. It's more important that I can have user accounts that
allow different areas of the app to be accessed. I *think* I could do this
with Access security - i.e determine the user who's logged on then allow
certain buttons on the form to work - is that the best way given that I want
users to be able to roam?
So would anyone be able to offer some general advice and perhaps a
recommended series of steps that one should take when embarking on this
task? (or a web link if there is one).
Apologies for the verbosity!
cheers
Martin
2  1520 
Take a look at Tony Toews web page: http://www.granite.ab.ca/accsmstr.htm
Specifically look at : http://www.granite.ab.ca/access/splitapp/index.htm
for information on splitting your application to FE(front end) and BE(back
end), and using Access in a multiuser configuration.
Tony also has some links to other places that will be helpful.
If you don't have it, purchase the AccessXX Developer's Handbook by (where
XX=version). If your version is 2000 or above, there are two volumes. The
second volume contains tons of info
regarding Access as Client/Server or over a Lan.
Look at this newgroup: microsoft.publi c.access.multiu ser for a lot of good
info.
Do a google search on THIS ng for "multiuser" .
HTH
Ruben Baumann
"Deano" <de*********@ho tmail.com> wrote in message
news:41******** *************@p tn-nntp-reader02.plus.n et... One of the more challenging things on my app's wishlist is to make it
multi-user on a LAN.
For the record my app was always intended to a single-user but things have
changed. It's mostly composed of bound forms handling records numbered in
the hundreds, sometimes a few thousand. The code of course refers to
tables in the local mdb.
I allow the user to create external backups of the tables in the database
and to restore them. Because of this feature there is no workgroup
security as I have to allow enough permissions for these backup/restore tasks to
work.
After opening the app I allow different users to be created to access
different areas - this also restricts the tables they can backup or
restore.
In a network scenario I guess I would need to split the database and put
the tables on a server.
I would like any user to be able to log on from any workstation and use
the app according to their level of access.
I would stop the existing backup/restore functions obviously but how would
I backup the tables on the server? (Creating an external mdb with backed up
tables is quite useful to us).
The tough part would be rewriting the code to refer to the server,
implementing locking etc.
I'm wondering whether to implement workgroup security given that the
tables will be on the server and the front-end will be a locked down MDE using
the Access Runtime. It's more important that I can have user accounts that
allow different areas of the app to be accessed. I *think* I could do this
with Access security - i.e determine the user who's logged on then allow
certain buttons on the form to work - is that the best way given that I
want users to be able to roam?
So would anyone be able to offer some general advice and perhaps a
recommended series of steps that one should take when embarking on this
task? (or a web link if there is one).
Apologies for the verbosity!
cheers
Martin
R Baumann wrote: Take a look at Tony Toews web page:
http://www.granite.ab.ca/accsmstr.htm
Specifically look at :
http://www.granite.ab.ca/access/splitapp/index.htm for information on
splitting your application to FE(front end) and BE(back end), and
using Access in a multiuser configuration.
Tony also has some links to other places that will be helpful.
If you don't have it, purchase the AccessXX Developer's Handbook by
(where XX=version). If your version is 2000 or above, there are two
volumes. The second volume contains tons of info
regarding Access as Client/Server or over a Lan.
Look at this newgroup: microsoft.publi c.access.multiu ser for a lot of
good info.
Do a google search on THIS ng for "multiuser" .
HTH
Ruben Baumann
cheers thanks for the tips. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jacek Generowicz |
last post by:
Functions defined in Python have type types.FunctionType, and are
descriptors whose __get__ method turns them into bound or unbound
methods. Functions defined in extension modules have type
types.BuiltinFunctionType, and have no __get__ method. Adding them as
attributes to classes and calling them through an instance of the
class does not result in them being called as methods: self is lost.
What's the simplest way of getting around this...
|
by: laredotornado |
last post by:
Hello, Is there any way to guarantee that the horizontal scrollbars in
an iframe are always turned off but the vertical scrollbars appear when
needed? Ideally, I'm looking for a solution on IE6+ and Netscape 7+,
but am open to any single-browser solutions.
Thanks, - Dave
|
by: Alex |
last post by:
Hello,
does anybody know how to turn off the autocomplete feature for a certain
text field?
I am aware of the "autocomplete" attribute, but I have seen other
implementions achieving it without any such attribute and am wondering
whether there is another way to do it .... like via CSS or a naming
convention or .......
|
by: Lee |
last post by:
Hello All,
First of all I would like to say thank you for all of the help I have
received here. I have been teaching myself Access for about 4 years
now and I've always been able to find a solution here - until now.
This one is driving me crazy.
I am making my first attempt at creating a runtime application. I am
using Access 2003 Developer Extensions. Initially I developed the
database without planning on creating a runtime app...
|
by: Yodai |
last post by:
Hi all!
I have an int that comes with a value like 0x07fa and I have to turn it into
a float value of 204.2 decimal to display it.... if I try to divide it by
10 I get bogus numbers. I presume I have to make it decimal before
calculating, but I am not sure about it. Any light upon this simple (or it
seems to me so, at least) begginner problem?
TIA..
| | |
by: Erik Cruz |
last post by:
Hi.
I have a repeater control bound to an ArrayList. When displaying the data, I
need to show 3 columns per row, each column being one entry of my ArrayList,
but the repeater understands that each record is a new line. Using
ItemTemplate and AlternateItemTemplate I could display two columns but I
need another one. How can I display records on columns instead of rows using
the repeater control?
TIA,
|
by: DC Gringo |
last post by:
I want to turn off viewstate for an application. I added the code below
into my web.config, but I'm still getting lotsa viewstate data in my hidden
form field:
<configuration>
<appSettings>
<Pages EnableViewState="false" />
</appSettings>
.....
|
by: hardcode |
last post by:
I can't do it in Crystal Repots either without making a formula for each field so I thought about using 'copy an existing table structure wo/the data' (like to make a new table and append records to eliminate duplicates) to an increased field element table but that did not work even adding a qry...
I just want to take a random number of rows of patient id's containing lab data and as the qry reads the rows, post the lab data from each row into...
|
by: bluesteel |
last post by:
I wanted to make a program to turn on my bedroom lights. I wanted to use the serial port, and i need to know a function that handles serial port outputs. I wanted to give either 0 or 1 at the output of a single pin, then i would make a circuit that let AC go through the wires if the computer returned 1 via such pin. I need to know what function can handle this, this would be great for learning but also it would be awesome to turn on the lights...
|
by: bugboy |
last post by:
I have a comma delineated string from an html form:
"wind, sun, ocean, lake"
i can use explode to turn it into an array but what i want to do is take each word and assign it to it's own variable (The number of words in the string may change), to end up with this:
$word1 == 'wind'
$word2 == 'sun'
$word3 == 'ocean'
$word4 == 'lake'
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
