I have an Access 2003 MDE with a SQL Server 2000 back-end using ODBC
linked tables. The MDE is shared among approximately 20 users.
This is the environment; I don't have the ability to change it at this
time.
New reporting requirements really need to use an UDF to supply the
result set. Which I believe requires a pass-through query.
After changes are made to the development MDB by the development staff
and approved for deployment, the MDE is compiled, the table links are
updated to point to the production database, and the shared MDE is
replaced.
But the pass-through queries wouldn't be updated with the existing
workflow and I'd like to have a technique to ensure that the queries
are updated.
I can examine the connection strings against the linked tables' and,
assuming that the tables' connection are correct, identify the need to
update the query connections.
But I'm concerned that updating the query connection string via VBA
will cause problems with sharing the MDE, even though it would only
happen the first time someone tried to run a report that used a
pass-through query.
Has anyone had a similar problem and, if so, how did you resolve it? 2 2338 me******@comcas t.net wrote: I have an Access 2003 MDE with a SQL Server 2000 back-end using ODBC linked tables. The MDE is shared among approximately 20 users.
This is the environment; I don't have the ability to change it at this time.
New reporting requirements really need to use an UDF to supply the result set. Which I believe requires a pass-through query.
After changes are made to the development MDB by the development staff and approved for deployment, the MDE is compiled, the table links are updated to point to the production database, and the shared MDE is replaced.
But the pass-through queries wouldn't be updated with the existing workflow and I'd like to have a technique to ensure that the queries are updated.
I can examine the connection strings against the linked tables' and, assuming that the tables' connection are correct, identify the need to update the query connections.
But I'm concerned that updating the query connection string via VBA will cause problems with sharing the MDE, even though it would only happen the first time someone tried to run a report that used a pass-through query.
Has anyone had a similar problem and, if so, how did you resolve it?
Your problem is that you are sharing a common MDE. Each user should have their
own local copy of the MDE. Then making modifications to queires
programmaticall y is no problem at all.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
> But I'm concerned that updating the query connection string via VBA will cause problems with sharing the MDE, even though it would only
No more problem than updating any other shared data in a shared database.
(david)
<me******@comca st.net> wrote in message
news:pk******** *************** *********@4ax.c om... I have an Access 2003 MDE with a SQL Server 2000 back-end using ODBC linked tables. The MDE is shared among approximately 20 users.
This is the environment; I don't have the ability to change it at this time.
New reporting requirements really need to use an UDF to supply the result set. Which I believe requires a pass-through query.
After changes are made to the development MDB by the development staff and approved for deployment, the MDE is compiled, the table links are updated to point to the production database, and the shared MDE is replaced.
But the pass-through queries wouldn't be updated with the existing workflow and I'd like to have a technique to ensure that the queries are updated.
I can examine the connection strings against the linked tables' and, assuming that the tables' connection are correct, identify the need to update the query connections.
But I'm concerned that updating the query connection string via VBA will cause problems with sharing the MDE, even though it would only happen the first time someone tried to run a report that used a pass-through query.
Has anyone had a similar problem and, if so, how did you resolve it?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Grasshopper |
last post by:
Hi,
I am automating Access reports to PDF using PDF Writer 6.0. I've
created a DTS package to run the reports and schedule a job to run this
DTS package. If I PC Anywhere into the server on where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
|
by: Serious_Practitioner |
last post by:
Good day all, and thank you in advance for your help. No - MANY thanks in
advance for your help - I know nothing about using databases on Web servers.
I am about to discuss a project with a client who is in the apartment rental
business. He solicits "For Rent" listings from property owners and managers,
advertises the apartments, shows them, takes applications and like that. His
inventory, as it were, is a list of vacant apartments that...
|
by: chellappa |
last post by:
hi
this simple sorting , but it not running...please correect error for
sorting using pointer or linked list sorting , i did value sorting in
linkedlist
please correct error
#include<stdio.h>
#include<stdlib.h>
int main(void)
{
|
by: Nedim |
last post by:
i have one table that i use for the details section of a crystal report, and
a linked table that should also be used in the details. the problem is i
cannot join them because the linked table has multiple entries and i choose
the corresponding one based on the current datetime (another column in the
linked table), and i select the top 1 row based on another column.
so, when i want to use the corresponding value from the linked table, the...
|
by: Henry |
last post by:
I have written an ASP/VB.Net application via VS 2003 (Crystal V9) that
uses MS Access 2000 as its database. I can export reports that have no
linked sub reports for printing. However, I'm unable to export reports
that have linked subreports. I receive (a "Missing parameter field
current value") on the following statement:
Me.crReportDocument.Export()
The main report requires 4 parameters. The linked reports do not
require any...
| |
by: lesperancer |
last post by:
I've got an access97 reporting mdb that pulls data (77,000 rows) from a
sql server table into a local table to run reports
if the local table is part of the reporting MDB, the insert statement
(16 fields) takes less than 30secs, but because of db-bloat, I moved
the local table to a 2nd MDB
and per postings, this 2nd MDB is copied into a folder and linked as a
'temp' MDB every time I run my reporting mdb
|
by: sk.rasheedfarhan |
last post by:
Hi ,
I am using C#
I am having 4 classes. like below.
public class A
{
String m_strRuleName;
String m_strRuleGuid;
// Some member functions.
public Object NextItem;
}
|
by: Josetta |
last post by:
I searched around a little bit, but didn't come up with the answer to
this question, but somewhere in the back of my mind, I think this can
be done...
Let's say we have two different company functions: Sales and
Operations
The Operations database is considered the "main" one...we are using
this daily and it works very well.
|
by: Blasting Cap |
last post by:
I'm using VS 2005, SQL 2005 reporting services.
SQL reporting services is working, and I have it both on my local
computer, as well as on a server.
I've created a report in the SQL Business Intelligence development
studio that works in that environment.
I've uploaded the same report to both the Reporting services on my local
computer as well as the server, and can log in to them and run the
|
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: 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: 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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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: 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
| |