Hi,
I'm looking for some thoughts/guidance about the following scenario.
A bit background first....
I have an Access database (BE) which has numerous linked tables
connected to our company Oracle database.
Each morning a scheduled task opens the database, and the FormOpen
event of a startup form imports the data from the Oracle linked tables
- this takes about 30 minutes to complete, and is not an issue as it
occurs out of business hours.
I have several Users, who have a frontend Access database with links to
the Access BE database. The frontend is used solely for querying and
reporting - no data input.
Now this is great, except the Users are looking at the same data
throughout the day, until the refresh occurs the following morning.
What I wanted to do was to trigger the BE database to run it's imports
around midday, but found this crashed the import routine as tables were
locked by Users using the frontend - which is what I would of expected
but want to overcome!
How or what can I do to cause a disconnection of any User's frontend
with the back end, so I can perform the import?
Ideally, I want to be able to do this automatically with very little
involvement with relinking tables for several Users!!
(BTW there is no security or groups established, the frontend database
just reports and presents our Company's system data in a more elegant
format!)
Also, it isnt feasible to allow each User a link directly to the Oracle
database.
I tried this and it can take upto an hour to do the import!
8 Users @ 2 refreshes per day = nearly 16 hours of productivity down
the swanny!
Any thoughts or guidance would be gratefully appreciated.
Thanks in advance,
Phil
2  1611 
Make a copy of the BE and give it a different name. Make a copy of the FE
and use the Linked Tables Manager to link to the copy of the BE.
Redistribute this FE to all the users.
Change what your scheduled task does slightly. You didn't say what happens
to the old data in the BE during the import of the Oracle data but do the
same thing. When the import is done, notify the users to shutdown their FEs.
Then programatically delete the BE the users are using and make a copy of
the BE with the Oracle data and rename the copy the same name as the deleted
file. All FEs will automatically link to the new users' BE.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
<ph****@globalnet.co.uk> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com... Hi,
I'm looking for some thoughts/guidance about the following scenario.
A bit background first....
I have an Access database (BE) which has numerous linked tables
connected to our company Oracle database.
Each morning a scheduled task opens the database, and the FormOpen
event of a startup form imports the data from the Oracle linked tables
- this takes about 30 minutes to complete, and is not an issue as it
occurs out of business hours.
I have several Users, who have a frontend Access database with links to
the Access BE database. The frontend is used solely for querying and
reporting - no data input.
Now this is great, except the Users are looking at the same data
throughout the day, until the refresh occurs the following morning.
What I wanted to do was to trigger the BE database to run it's imports
around midday, but found this crashed the import routine as tables were
locked by Users using the frontend - which is what I would of expected
but want to overcome!
How or what can I do to cause a disconnection of any User's frontend
with the back end, so I can perform the import?
Ideally, I want to be able to do this automatically with very little
involvement with relinking tables for several Users!!
(BTW there is no security or groups established, the frontend database
just reports and presents our Company's system data in a more elegant
format!)
Also, it isnt feasible to allow each User a link directly to the Oracle
database.
I tried this and it can take upto an hour to do the import!
8 Users @ 2 refreshes per day = nearly 16 hours of productivity down
the swanny!
Any thoughts or guidance would be gratefully appreciated.
Thanks in advance,
Phil
PC Datasheet wrote: Make a copy of the BE and give it a different name. Make a copy of
the FE and use the Linked Tables Manager to link to the copy of the BE.
Redistribute this FE to all the users.
Change what your scheduled task does slightly. You didn't say what
happens to the old data in the BE during the import of the Oracle data but do
the same thing. When the import is done, notify the users to shutdown
their FEs. Then programatically delete the BE the users are using and make a
copy of the BE with the Oracle data and rename the copy the same name as the
deleted file. All FEs will automatically link to the new users' BE.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<ph****@globalnet.co.uk> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com... Hi,
I'm looking for some thoughts/guidance about the following
scenario.
A bit background first....
I have an Access database (BE) which has numerous linked tables
connected to our company Oracle database.
Each morning a scheduled task opens the database, and the FormOpen
event of a startup form imports the data from the Oracle linked
tables - this takes about 30 minutes to complete, and is not an issue as
it occurs out of business hours.
I have several Users, who have a frontend Access database with
links to the Access BE database. The frontend is used solely for querying
and reporting - no data input.
Now this is great, except the Users are looking at the same data
throughout the day, until the refresh occurs the following morning.
What I wanted to do was to trigger the BE database to run it's
imports around midday, but found this crashed the import routine as tables
were locked by Users using the frontend - which is what I would of
expected but want to overcome!
How or what can I do to cause a disconnection of any User's
frontend with the back end, so I can perform the import?
Ideally, I want to be able to do this automatically with very
little involvement with relinking tables for several Users!!
(BTW there is no security or groups established, the frontend
database just reports and presents our Company's system data in a more
elegant format!)
Also, it isnt feasible to allow each User a link directly to the
Oracle database.
I tried this and it can take upto an hour to do the import!
8 Users @ 2 refreshes per day = nearly 16 hours of productivity
down the swanny!
Any thoughts or guidance would be gratefully appreciated.
Thanks in advance,
Phil This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Manlio Perillo |
last post by:
Hi.
This post follows "does python have useless destructors".
I'm not an expert, so I hope what I will write is meaningfull and
clear.
Actually in Python there is no possibility to write code that follows
C++ RAII pattern.
Of course Python objects are not statics like in C++, but in C++ the
auto_ptr class is used for enforcing this...
|
by: Lew |
last post by:
Hi all,
I'm trying to create a page that has a user-selectable page auto-refresh
option (IE 5.5). Essentially, it's a page that contains a checkbox, when
the user checks the checkbox, I'd like the page to auto-refresh every 4
seconds....if the user un-checks the checkbox, I'd like to turn off the auto
refresh.
The page is as follows:
|
by: Glabbeek |
last post by:
I'm changing the layout of my site. Instead of using tables, I will use
DIVs. It's working fine, except for 1 thing: In IE6 some DIVs are not
the correct width. Mozilla and Opera are showing the page the way I
want. Does anybody know a solution for this?
First of all, the code I am using:
CSS
-------
body {
|
by: Robert Downes |
last post by:
I'm using the following in a page that I'm testing in Mozilla:
p.actionLinkBlock {border: 1px #000000 dashed; padding: 0.2cm; width: auto}
But the dashed border is extending to the right-edge of the screen. I
want it to only extend as far as it needs to to nicely contain the
content within (a couple of links).
Is width: auto the wrong...
|
by: Vijay Kumar R. Zanvar |
last post by:
Hello,
Unlike register, auto keyword can not be used to
declare formal parameter(s). Is there any specific
reason for this?
Kind regards,
Vijay Kumar R. Zanvar
| | |
by: Samuel |
last post by:
Hi,
I am running into a problem of mixing UICulture = auto and allowing users to
select culture using a dropdown list.
I am detecting a querystring, "setlang", and when found, setting the
CurrentUICulture to what's specified in the querystring. Since I want to
allow UICulture auto detecting, I add UICulture = "auto" to page directive on...
|
by: maya |
last post by:
at work they decided to center divs thus:
body {text-align:center}
#content {width: 612px; text-align:left; margin: 0 auto 0 auto; }
this works fine in IE & FF, EXCEPT in FF it doesn't work if I change
'auto' to 0 for left and right margin values; I have to leave those at
'auto'.. so I would like to know what exactly means 'auto' -- what...
|
by: nospam_news |
last post by:
I currently get asked about my usage of "auto". What is it for?
The keyword is clearly superflous here.
In contrast to the huge majority of C/C++ developers I write
definitions very explicitly like that:
int main(char argc, char *argv, char *env) {
try {
auto Exception mainException(1);
mainException.setErrNo(42);
|
by: Piotr K |
last post by:
Hi,
I've encountered a strange problem with Firefox which I don't have any
idea how to resolve. To the point: I've <divelement with a style
"height: auto" and I want to retrieve this value ("auto") in
JavaScript - however instead of getting "auto" value, I get calculated
height. In IE and Opera it simply returns "auto".
Any ideas how to...
|
by: JOYCE |
last post by:
Look the subject,that's my problem!
I hope someone can help me, thanks
|
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...
| | |
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. ...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
