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  1622 
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******@pcdata sheet.com www.pcdatasheet.com
<ph****@globaln et.co.uk> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.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******@pcdata sheet.com
www.pcdatasheet.com
<ph****@globaln et.co.uk> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.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 pattern for dynamical
|
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 property to do this? Is Mozilla rendering the
style 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
each page.
|
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
value it represents exactly (and does it apply for all elements/values
you might apply 'auto' to?)
|
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 check in Firefox if element height was set to
"auto" ? I'll be grateful for any help.
|
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 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: 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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
