Hi
I am converting my access front-end/backend mdb app to adp. Are there any
pitfalls I should be aware of?
Thanks
Regards 16 1587
John,
1. If the new back-end is SQL Server and the old back-end was Jet/Access
then much and perhaps all of the SQL in service may need to be revisited to
ensure it runs as intended on SQL Server. Things like DCount, etc., don't
exist on SQL Server. IIf() is implemented as CASE and works differently.
Date() is GETDATE(), "" has to be '', lots of little details are different.
2. A straight dump of Jet SQL with bug fixes & workarounds to just make the
existing SQL function on SQL Server risks really crappy performance on SQL
Server because it's possible to cause Access to do some really boneheaded
translation of SQL into something that will run on SQL Server.
3. TransactSQL is lightyears more capable than JetSQL & VBA. The
performance & stability gains possible will come from a thorough review of
the business processes implemented in Access and a study of the best way to
implement them on SQL Server.
--
Alan Webb kn*******@SPAMh otmail.com
"It's not IT, it's IS
"John" <Jo**@nospam.in fovis.co.uk> wrote in message
news:42******** *************@n ews-text.dial.pipex .com... Hi
I am converting my access front-end/backend mdb app to adp. Are there any pitfalls I should be aware of?
Thanks
Regards
John wrote: I am converting my access front-end/backend mdb app to adp. Are there any pitfalls I should be aware of?
Only a few minor ones:
ADPs are unreliable, exhibit erratic anomalies (they happen one day but
not the next), open many connections (all of which are wonderfully
slow), have difficulty in opening a form at a specific record, have
recurring and sometimes unsolvable updating problems, require arcane
procedures for report filtering, and create a vulnerable insecure route
to the database.
Other than that they're fabulous.
Did I mention that they make your data insecure?
that's INSECURE
I-N-S-E-C-U-R-E!
--
--
Lyle
"The aim of those who try to control thought is always the same. They
find one single explanation of the world, one system of thought and
action that will (they believe) cover everything; and then they try to
impose that on all thinking people."
- Gilbert Highet
I need the sql server backend to establish replication/sync with some laptop
users who would like to disconnect and then sync when they reconnect. In my
case what is the solution? Should I keep the mdb front-end and link the
tables off sql server? Anything else?
Thanks
Regards
"Lyle Fairfield" <ly******@yahoo .ca> wrote in message
news:0P******** *************@r ead2.cgocable.n et... John wrote:
I am converting my access front-end/backend mdb app to adp. Are there any pitfalls I should be aware of?
Only a few minor ones:
ADPs are unreliable, exhibit erratic anomalies (they happen one day but not the next), open many connections (all of which are wonderfully slow), have difficulty in opening a form at a specific record, have recurring and sometimes unsolvable updating problems, require arcane procedures for report filtering, and create a vulnerable insecure route to the database.
Other than that they're fabulous.
Did I mention that they make your data insecure? that's INSECURE I-N-S-E-C-U-R-E!
-- -- Lyle
"The aim of those who try to control thought is always the same. They find one single explanation of the world, one system of thought and action that will (they believe) cover everything; and then they try to impose that on all thinking people." - Gilbert Highet
I yield to the replication experts.
John wrote: I need the sql server backend to establish replication/sync with some laptop users who would like to disconnect and then sync when they reconnect. In my case what is the solution? Should I keep the mdb front-end and link the tables off sql server? Anything else?
Thanks
Regards
"Lyle Fairfield" <ly******@yahoo .ca> wrote in message news:0P******** *************@r ead2.cgocable.n et...
John wrote:
I am converting my access front-end/backend mdb app to adp. Are there any pitfalls I should be aware of?
Only a few minor ones:
ADPs are unreliable, exhibit erratic anomalies (they happen one day but not the next), open many connections (all of which are wonderfully slow), have difficulty in opening a form at a specific record, have recurring and sometimes unsolvable updating problems, require arcane procedures for report filtering, and create a vulnerable insecure route to the database.
--
Lyle
"The aim of those who try to control thought is always the same. They
find one single explanation of the world, one system of thought and
action that will (they believe) cover everything; and then they try to
impose that on all thinking people."
- Gilbert Highet
There's a whole newsgroup at microsoft.publi c.access.replic ation.
It can certainly be done in Access, without requiring SQL Server.
"Lyle Fairfield" <ly******@yahoo .ca> wrote in message
news:xE******** ********@read1. cgocable.net... I yield to the replication experts.
John wrote: I need the sql server backend to establish replication/sync with some
laptop users who would like to disconnect and then sync when they reconnect. In
my case what is the solution? Should I keep the mdb front-end and link the tables off sql server? Anything else?
Thanks
Regards
"Lyle Fairfield" <ly******@yahoo .ca> wrote in message news:0P******** *************@r ead2.cgocable.n et...
John wrote:
I am converting my access front-end/backend mdb app to adp. Are there
anypitfalls I should be aware of?
Only a few minor ones:
ADPs are unreliable, exhibit erratic anomalies (they happen one day but not the next), open many connections (all of which are wonderfully
slow),have difficulty in opening a form at a specific record, have recurring
andsometimes unsolvable updating problems, require arcane procedures for report filtering, and create a vulnerable insecure route to the
database. -- Lyle
"The aim of those who try to control thought is always the same. They find one single explanation of the world, one system of thought and action that will (they believe) cover everything; and then they try to impose that on all thinking people." - Gilbert Highet
From the quesitons you are asking, I'm assuming your situation is that you
have a central LAN with a connection to the internet, laptop users who will
have Internet access where they're trying to do their remote work, and an IT
administrator capable of managing your LAN's firewall ports, etc. If that's
the case, then your best bet is probably to use some kind of remote control
software and allow users to run their desktop systems from remote.
If remote control will not work for you, then your next best choice is
probably replication since Access may not handle the flakey SQL Server
connections you may get over the Internet, and you'll have to add a VPN layer
for security or live with the lack of security (probably not a good idea).
Note that Access replicaiton may or may not be the best way to do replication.
Sometimes, it's better to implement a replication scheme at the application
level. One way to do this is to implement a record ID generation system that
includes a machine identifier so there can't be collisions between IDs
generated on different machines, and add fields for a current and previous
record revision ID so you can tell if a record in the central database is the
same revision that a remote system made a change to while off-line, and allow
the change to post if so.
On Sun, 24 Apr 2005 15:49:14 +0100, "John" <Jo**@nospam.in fovis.co.uk> wrote: I need the sql server backend to establish replication/sync with some laptop users who would like to disconnect and then sync when they reconnect. In my case what is the solution? Should I keep the mdb front-end and link the tables off sql server? Anything else?
Thanks
Regards
"Lyle Fairfield" <ly******@yahoo .ca> wrote in message news:0P******* **************@ read2.cgocable. net... John wrote:
I am converting my access front-end/backend mdb app to adp. Are there any pitfalls I should be aware of?
Only a few minor ones:
ADPs are unreliable, exhibit erratic anomalies (they happen one day but not the next), open many connections (all of which are wonderfully slow), have difficulty in opening a form at a specific record, have recurring and sometimes unsolvable updating problems, require arcane procedures for report filtering, and create a vulnerable insecure route to the database.
Other than that they're fabulous.
Did I mention that they make your data insecure? that's INSECURE I-N-S-E-C-U-R-E!
-- -- Lyle
"The aim of those who try to control thought is always the same. They find one single explanation of the world, one system of thought and action that will (they believe) cover everything; and then they try to impose that on all thinking people." - Gilbert Highet
Is access replication reliable enough?
Regards
"MacDermott " <ma********@nos pam.com> wrote in message
news:VF******** ***********@new sread2.news.atl .earthlink.net. .. There's a whole newsgroup at microsoft.publi c.access.replic ation. It can certainly be done in Access, without requiring SQL Server.
"Lyle Fairfield" <ly******@yahoo .ca> wrote in message news:xE******** ********@read1. cgocable.net... I yield to the replication experts.
John wrote: > I need the sql server backend to establish replication/sync with some laptop > users who would like to disconnect and then sync when they reconnect. > In my > case what is the solution? Should I keep the mdb front-end and link the > tables off sql server? Anything else? > > Thanks > > Regards > > "Lyle Fairfield" <ly******@yahoo .ca> wrote in message > news:0P******** *************@r ead2.cgocable.n et... > >>John wrote: >> >> >>>I am converting my access front-end/backend mdb app to adp. Are there any >>>pitfalls I should be aware of? >> >>Only a few minor ones: >> >>ADPs are unreliable, exhibit erratic anomalies (they happen one day but >>not the next), open many connections (all of which are wonderfully slow), >>have difficulty in opening a form at a specific record, have recurring and >>sometimes unsolvable updating problems, require arcane procedures for >>report filtering, and create a vulnerable insecure route to the database. -- Lyle
"The aim of those who try to control thought is always the same. They find one single explanation of the world, one system of thought and action that will (they believe) cover everything; and then they try to impose that on all thinking people." - Gilbert Highet
John,
It was good enough for a Y2K inventory done at a financial services company
I worked for back when I was getting paid for this stuff. As Steve points
out, there are cases where writing your own replication code ends up being
cheaper/better than what Microsoft provides in Access without code.
--
Alan Webb kn*******@SPAMh otmail.com
"It's not IT, it's IS"
"John" <Jo**@nospam.in fovis.co.uk> wrote in message
news:42******** *************@n ews-text.dial.pipex .com... I need the sql server backend to establish replication/sync with some laptop users who would like to disconnect and then sync when they reconnect. In my case what is the solution? Should I keep the mdb front-end and link the tables off sql server? Anything else?
Thanks
Regards
"Lyle Fairfield" <ly******@yahoo .ca> wrote in message news:0P******** *************@r ead2.cgocable.n et... John wrote:
I am converting my access front-end/backend mdb app to adp. Are there any pitfalls I should be aware of?
Only a few minor ones:
ADPs are unreliable, exhibit erratic anomalies (they happen one day but not the next), open many connections (all of which are wonderfully slow), have difficulty in opening a form at a specific record, have recurring and sometimes unsolvable updating problems, require arcane procedures for report filtering, and create a vulnerable insecure route to the database.
Other than that they're fabulous.
Did I mention that they make your data insecure? that's INSECURE I-N-S-E-C-U-R-E!
-- -- Lyle
"The aim of those who try to control thought is always the same. They find one single explanation of the world, one system of thought and action that will (they believe) cover everything; and then they try to impose that on all thinking people." - Gilbert Highet
Steve Jorgensen <no****@nospam. nospam> wrote in
news:10******** *************** *********@4ax.c om: Note that Access replicaiton may or may not be the best way to do replication. Sometimes, it's better to implement a replication scheme at the application level. One way to do this is to implement a record ID generation system that includes a machine identifier so there can't be collisions between IDs generated on different machines, and add fields for a current and previous record revision ID so you can tell if a record in the central database is the same revision that a remote system made a change to while off-line, and allow the change to post if so.
This is an enormously difficult task, even if it is only one-way
between a mere two copies of the data file.
I've done it. It's complicated (think about how deletions are
propagated; think about order of inserts and referential integrity).
If you're trying to have multiple dbs in the field, all being
updated, and you want those changes pushed up to the server, and you
also want to make the changes made by people on the servers to be
pulled down to the db in the field, it becomes a hugely complicated
task, unless a few conditions are met:
1. no records are edited in more than one location.
2. each person in the field has their own dataset that they work on
alone, and no other people actually edit that data (though they may
view it and analyze it).
But even then, you have to solve the PK issue. You have three
choices:
1. use a natural key, and run the risk of the same natural key being
used in two different copies of the database.
2. pre-allocated blocks of surrogate keys to each copy of the
database.
3. include a source db identifier in a compound PK in every table.
But if everyone's working on the same datasets, it becomes nearly
impossible to program from scratch.
Keep in mind that, theoretically speaking, there is a form of
heterogenous replication where the main mother ship is a SQL Server
db and the laptops have Jet dbs that synchronize with the SQL
Server. However, like pure SQL Server replication itself, the whole
scenario is much more limited than the capabilities of pure Jet
replication, and the rules much more strict.
I don't think replication is the answer here.
I think the problem needs to be completely re-thought from the
ground up.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Stub |
last post by:
Docs says that "The compiler does not use an explicit constructor to
implement an implied conversion of types. It's purpose is reserved
explicitly for construction."
I put up code of three cases at the bottom. Hope you can help me understand
the "explicit" keyword and its usage. Specifically,
Is "explicit" keyword only associated with constructor in C++?
What's "implied conversion of types"?
|
by: Michael Lehn |
last post by:
Hi,
I have a question regarding the conversion of objects. When is the
conversion done by the constructor and when by the operator. My feeling
tells me that the constructor is preferred. But I couldn't find the
exact rule in the C++ standard.
And what if the classes have template parameters?
It would be great if somebody could get me a rough hint where in the
|
by: TTroy |
last post by:
Hello, I'm relatively new to C and have gone through more than 4 books
on it. None mentioned anything about integral promotion, arithmetic
conversion, value preserving and unsigned preserving. And K&R2
mentions "signed extension" everywhere.
Reading some old clc posts, I've beginning to realize that these books
are over-generalizing the topic. I am just wondering what the
difference between the following pairs of terms are:
1)...
|
by: Bjørn Augestad |
last post by:
Below is a program which converts a double to an integer in two
different ways, giving me two different values for the int. The basic
expression is 1.0 / (1.0 * 365.0) which should be 365, but one variable
becomes 364 and the other one becomes 365.
Does anyone have any insight to what the problem is?
Thanks in advance.
Bjørn
|
by: Steve Gough |
last post by:
Could anyone please help me to understand what is happening here? The
commented line produces an error, which is what I expected given that
there is no conversion defined from type double to type Test. I
expected the same error from the following line, but it compiles fine.
The double is silently truncated to an int and then fed in to the
implicit conversion operator. Why does this happen? Is there any way
that I can keep the implicit...
| |
by: Alex Sedow |
last post by:
Why explicit conversion from SomeType* to IntPtr is not ambiguous (according
to standart)?
Example:
// System.IntPtr
class IntPtr
{
public static explicit System.IntPtr (int);
public static explicit System.IntPtr (long);
|
by: Steve Richter |
last post by:
here is a warning I am getting in a C++ .NET compile:
c:\SrNet\jury\JuryTest.cpp(55) : warning C4927: illegal conversion;
more than one user-defined conversion has been implicitly applied
while calling the constructor 'MyString::MyString(const
wchar_t *)'
c:\SrNet\jury\JuryTest.h(21) : see declaration of
'MyString::MyString'
The class "StringData" uses a, whatever you call it, operator const
|
by: Lou Evart |
last post by:
DOCUMENT CONVERSION SERVICES
Softline International (SII) operates one of the industry's largest
document and data conversion service bureaus. In the past year, SII
converted over a million pages to a variety of formats.
SII's service bureau has a reputation as being a least-cost provider
that can offer a timely turnaround with 100% accuracy. Here are some of
the formats SII has converted over the last 20 years:
|
by: dataentryoffshore |
last post by:
Get a Discount up to 60% on data entry, data capture, dataentry
services, large volume data processing and data conversion services
through offshore facilities in India. Offshore data entry also
provides form data entry, data capture, HTML/SGML coding, image
scanning, file conversion with low cost, high quality,99.98% accuracy
and time bound.
Data Conversion Services offer cost effective data conversion
projects, Outsourcing Data...
|
by: REH |
last post by:
It it permissible to use the constructor style cast with primitives
such as "unsigned long"? One of my compilers accepts this syntax, the
other does not. The failing one chokes on the fact that the type is
not a single identifier or keyword. Which one is correct? For example:
unsigned long x = unsigned long(y);
REH
|
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: 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: 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: 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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |