I created an Access 97 database a while ago. It is protected by Workgroup
Security, and it is not split.
In order to compare different sets of results, a colleague has suggested
that it would be useful to run two instances of the same database on
separate screens of a two monitor set up.
I have actually tried this, and you can indeed open the file twice, log in
with the same Login/Password Details and view/navigate through the
application.
So, I seem to have answered my own question, but as a newbie, I am worried
about 'missing something'. I never actually intended the database to be used
as such, and so I am concerned about what impact running two instances of
the same database would have.
Is there potential for the database to be damaged by using it in this
manner?
Regards to all who can help with this issue,
Chris
(Splitting the database is not an option at this stage)
(The interface is purely via forms, and the suggested comparison of data is
not possible in the current version, hence running to versions) 6 2247
No particular harm. You've simply demonstrated to yourself that Access is a
multi-user system.
--
-Larry-
--
"Chris Tyson" <ch***********@btinternet.com> wrote in message
news:ca**********@sparta.btinternet.com... I created an Access 97 database a while ago. It is protected by Workgroup Security, and it is not split.
In order to compare different sets of results, a colleague has suggested that it would be useful to run two instances of the same database on separate screens of a two monitor set up.
I have actually tried this, and you can indeed open the file twice, log in with the same Login/Password Details and view/navigate through the application.
So, I seem to have answered my own question, but as a newbie, I am worried about 'missing something'. I never actually intended the database to be
used as such, and so I am concerned about what impact running two instances of the same database would have.
Is there potential for the database to be damaged by using it in this manner? Regards to all who can help with this issue,
Chris
(Splitting the database is not an option at this stage) (The interface is purely via forms, and the suggested comparison of data
is not possible in the current version, hence running to versions)
My earlier reply assumed that you had two front ends pointed at the same
back end tables. If that's not the case you've done nothing any more
exciting than opening two instances of Excel or another application.
--
-Larry-
--
"Larry Daugherty" <La********************@verizon.net> wrote in message
news:Sf******************@nwrddc02.gnilink.net... No particular harm. You've simply demonstrated to yourself that Access is
a multi-user system.
-- -Larry- --
"Chris Tyson" <ch***********@btinternet.com> wrote in message news:ca**********@sparta.btinternet.com... I created an Access 97 database a while ago. It is protected by
Workgroup Security, and it is not split.
In order to compare different sets of results, a colleague has suggested that it would be useful to run two instances of the same database on separate screens of a two monitor set up.
I have actually tried this, and you can indeed open the file twice, log
in with the same Login/Password Details and view/navigate through the application.
So, I seem to have answered my own question, but as a newbie, I am
worried about 'missing something'. I never actually intended the database to be used as such, and so I am concerned about what impact running two instances
of the same database would have.
Is there potential for the database to be damaged by using it in this manner? Regards to all who can help with this issue,
Chris
(Splitting the database is not an option at this stage) (The interface is purely via forms, and the suggested comparison of data is not possible in the current version, hence running to versions)
Thanks for swift response Larry. I kinda thought it would be OK, but the
reassurance is welcome.
Cheers,
Chris
"Larry Daugherty" <La********************@verizon.net> wrote in message
news:Sf******************@nwrddc02.gnilink.net... No particular harm. You've simply demonstrated to yourself that Access is
a multi-user system.
-- -Larry- --
"Chris Tyson" <ch***********@btinternet.com> wrote in message news:ca**********@sparta.btinternet.com... I created an Access 97 database a while ago. It is protected by
Workgroup Security, and it is not split.
In order to compare different sets of results, a colleague has suggested that it would be useful to run two instances of the same database on separate screens of a two monitor set up.
I have actually tried this, and you can indeed open the file twice, log
in with the same Login/Password Details and view/navigate through the application.
So, I seem to have answered my own question, but as a newbie, I am
worried about 'missing something'. I never actually intended the database to be used as such, and so I am concerned about what impact running two instances
of the same database would have.
Is there potential for the database to be damaged by using it in this manner? Regards to all who can help with this issue,
Chris
(Splitting the database is not an option at this stage) (The interface is purely via forms, and the suggested comparison of data is not possible in the current version, hence running to versions)
Hi Larry, thanks for your responses.
The difference between Excel/Word etc and Access is that I cannot open
the same file as two instances.
With hindsight I should have gone the FrontEnd-BackEnd route, but never
did and it is too late to change now.
It is this that worries me. Access allows me to run two instances of the
same database/file on the same machine (regardless of whether it is single
or double monitor). If it was FrontEnd-BackEnd, then I would be entirely
happy. However it isn't, so I am concerned that something untoward may
happen. Since Access doesn't throw up any errors/warnings stating that
'another copy is open' or 'do you wish to revert to the saved version' etc
etc, I assume it knows what it is doing ;-)
As I said, bit of newbie, I wondered if more experienced users can shed
light on it.
(I promise, next time it will be FrontEnd-BackEnd...)
Cheers,
Chris
"Larry Daugherty" <La********************@verizon.net> wrote in message
news:ZQ*******************@nwrddc03.gnilink.net... My earlier reply assumed that you had two front ends pointed at the same back end tables. If that's not the case you've done nothing any more exciting than opening two instances of Excel or another application.
-- -Larry- --
"Larry Daugherty" <La********************@verizon.net> wrote in message news:Sf******************@nwrddc02.gnilink.net... No particular harm. You've simply demonstrated to yourself that Access
is a multi-user system.
-- -Larry- --
"Chris Tyson" <ch***********@btinternet.com> wrote in message news:ca**********@sparta.btinternet.com... I created an Access 97 database a while ago. It is protected by Workgroup Security, and it is not split.
In order to compare different sets of results, a colleague has
suggested that it would be useful to run two instances of the same database on separate screens of a two monitor set up.
I have actually tried this, and you can indeed open the file twice,
log in with the same Login/Password Details and view/navigate through the application.
So, I seem to have answered my own question, but as a newbie, I am worried about 'missing something'. I never actually intended the database to
be used as such, and so I am concerned about what impact running two instances of the same database would have.
Is there potential for the database to be damaged by using it in this manner? Regards to all who can help with this issue,
Chris
(Splitting the database is not an option at this stage) (The interface is purely via forms, and the suggested comparison of
data is not possible in the current version, hence running to versions)
Hi Larry, thanks for your responses.
The difference between Excel/Word etc and Access is that I cannot open
the same file as two instances.
With hindsight I should have gone the FrontEnd-BackEnd route, but never
did and it is too late to change now.
It is this that worries me. Access allows me to run two instances of the
same database/file on the same machine (regardless of whether it is single
or double monitor). If it was FrontEnd-BackEnd, then I would be entirely
happy. However it isn't, so I am concerned that something untoward may
happen. Since Access doesn't throw up any errors/warnings stating that
'another copy is open' or 'do you wish to revert to the saved version' etc
etc, I assume it knows what it is doing ;-)
As I said, bit of newbie, I wondered if more experienced users can shed
light on it.
(I promise, next time it will be FrontEnd-BackEnd...)
Cheers,
Chris
"Larry Daugherty" <La********************@verizon.net> wrote in message
news:ZQ*******************@nwrddc03.gnilink.net... My earlier reply assumed that you had two front ends pointed at the same back end tables. If that's not the case you've done nothing any more exciting than opening two instances of Excel or another application.
-- -Larry- --
"Larry Daugherty" <La********************@verizon.net> wrote in message news:Sf******************@nwrddc02.gnilink.net... No particular harm. You've simply demonstrated to yourself that Access
is a multi-user system.
-- -Larry- --
"Chris Tyson" <ch***********@btinternet.com> wrote in message news:ca**********@sparta.btinternet.com... I created an Access 97 database a while ago. It is protected by Workgroup Security, and it is not split.
In order to compare different sets of results, a colleague has
suggested that it would be useful to run two instances of the same database on separate screens of a two monitor set up.
I have actually tried this, and you can indeed open the file twice,
log in with the same Login/Password Details and view/navigate through the application.
So, I seem to have answered my own question, but as a newbie, I am worried about 'missing something'. I never actually intended the database to
be used as such, and so I am concerned about what impact running two instances of the same database would have.
Is there potential for the database to be damaged by using it in this manner? Regards to all who can help with this issue,
Chris
(Splitting the database is not an option at this stage) (The interface is purely via forms, and the suggested comparison of
data is not possible in the current version, hence running to versions)
You'd be better off to split the database and have all front ends point at
the same back end. No matter how late in the day it seems it's almost
always better than a monolithic design. Consider the case of modifying the
design: If your table design hasn't changed then you'd only need to change
the front end without risk to your data (make a backup before changing
things anyway :-) ).
Tony Toews has a nifty tool for synchronizing things that's downloadable
from his site. Look for FE Updater.
HTH
--
-Larry-
--
"Chris Tyson" <ch***********@btinternet.com> wrote in message
news:ca**********@titan.btinternet.com... Thanks for swift response Larry. I kinda thought it would be OK, but the reassurance is welcome.
Cheers,
Chris
"Larry Daugherty" <La********************@verizon.net> wrote in message news:Sf******************@nwrddc02.gnilink.net... No particular harm. You've simply demonstrated to yourself that Access
is a multi-user system.
-- -Larry- --
"Chris Tyson" <ch***********@btinternet.com> wrote in message news:ca**********@sparta.btinternet.com... I created an Access 97 database a while ago. It is protected by Workgroup Security, and it is not split.
In order to compare different sets of results, a colleague has
suggested that it would be useful to run two instances of the same database on separate screens of a two monitor set up.
I have actually tried this, and you can indeed open the file twice,
log in with the same Login/Password Details and view/navigate through the application.
So, I seem to have answered my own question, but as a newbie, I am worried about 'missing something'. I never actually intended the database to
be used as such, and so I am concerned about what impact running two instances of the same database would have.
Is there potential for the database to be damaged by using it in this manner? Regards to all who can help with this issue,
Chris
(Splitting the database is not an option at this stage) (The interface is purely via forms, and the suggested comparison of
data is not possible in the current version, hence running to versions)
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: bdj |
last post by:
Hello!
Can anyone tell me where to read more about best practices about this:
Should I put data in a seperate scheme for tables,
packages in anoter schema
and create a lot of users that have...
|
by: Mike |
last post by:
Looking to find any information on how to properly configure multiple
instances of DB2. This is on Win2k db2 ver 7.2. I am basically looking
for information on how the multiple instance settings...
|
by: Yasaswi Pulavarti |
last post by:
I have a Aix 5.2 server with DB2 UDB 8.1
I created three different instances using the db2setup utility three
times. The default instance is db2inst1. When I su - db2inst2 and su -
db2inst3 and...
|
by: (Pete Cresswell) |
last post by:
I know I can open many instances of a given form, but I've never done it.
Now I'm analyzing an application where that seems like just the ticket: Many
investment funds, *lots* of data points for...
|
by: Johan |
last post by:
If a user happens to open multiple instances of her frontend, what kind of
problems can occur?
For example, one user reported that she was able to, once or twice, bypass
the evaluation...
|
by: Dave Wright |
last post by:
Hi,
We have implemented a IIS NLB farm and would like to know if a SQL
Session database can be used to host multiple sites? As the entry in
web.config does not allow a database name to be...
|
by: Jeff |
last post by:
We have multiple ASP.Net web apps in development. As a standard we
are looking to go with SQL Server to hold state information.
Can we have the multiple apps all point to a single State DB? Or...
|
by: CNN_news |
last post by:
I would like to run multiple instances of TYPO3 (a cms written in PHP)
on a single server.
You can run multiple websites in two methods: multisite or multiple
instances.
In multiple...
|
by: jdokos |
last post by:
Hi,
Has anyone used STMM with multiple instances on the same machine in
V9? From all the documentation I have read it looks like this should
work and that there is nothing 'special' that needs...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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,...
|
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...
| |