Hi all
I have Aceess 2000 front end linking to SQLServer 2000 BE.
While developing the backend I work on an offline database. When happy I
update the live one. Any changes I've made to the testone are highlighted by
running some database comparison software that shows all the differencs
between the two. I then manually update the live one.
I am after something similar for the front ends. I need to set up 2
connections, one to the development front end and one to the live front end
and then it generates say a spilt screen showing me the difference between
the forms and code. Does anyone know if such a thing exists
many thanks
Andy 3 1994
Total Access Detective can compare two databases and list the differences.
It's available from FMS. I use it regularly; it's a fine tool but as with
anything like this use it with caution.
Is there any reason why you cannot simply replace the old FE with the new
FE? This is the most common upgrade scenario ... http://www.fmsinc.com/
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"Smash forehead on keyboard to continue ... "
"aaj" <a.*@c.com> wrote in message
news:40******** **************@ news.easynet.co .uk... Hi all
I have Aceess 2000 front end linking to SQLServer 2000 BE.
While developing the backend I work on an offline database. When happy I update the live one. Any changes I've made to the testone are highlighted
by running some database comparison software that shows all the differencs between the two. I then manually update the live one.
I am after something similar for the front ends. I need to set up 2 connections, one to the development front end and one to the live front
end and then it generates say a spilt screen showing me the difference between the forms and code. Does anyone know if such a thing exists
many thanks
Andy
Thanks for the link, will take a look Is there any reason why you cannot simply replace the old FE with the new FE? This is the most common upgrade scenario ...
I do on most of my front ends, but the test one I'm working on now needs
extra configuration (harcoded paths to harddrives and such), not just the
connection, plus it has bits of code I'm not ready to implement yet but I
have already written.
In this database only, I tend to make my changes/tests on the 'dirty' backup
and then when I'm happy just make the relevant changes to the working front
end and then retest the working front end with the test backup before
finally pointing it to the live backend
thanks again
Andy
"Scott McDaniel" <sc***@no.spam. thedatabaseplac e.net> wrote in message
news:os******** ************@co mcast.com... Total Access Detective can compare two databases and list the differences. It's available from FMS. I use it regularly; it's a fine tool but as with anything like this use it with caution.
Is there any reason why you cannot simply replace the old FE with the new FE? This is the most common upgrade scenario ...
http://www.fmsinc.com/
-- Scott McDaniel CS Computer Software Visual Basic - Access - Sql Server - ASP
"Smash forehead on keyboard to continue ... "
"aaj" <a.*@c.com> wrote in message news:40******** **************@ news.easynet.co .uk... Hi all
I have Aceess 2000 front end linking to SQLServer 2000 BE.
While developing the backend I work on an offline database. When happy I update the live one. Any changes I've made to the testone are
highlighted by running some database comparison software that shows all the differencs between the two. I then manually update the live one.
I am after something similar for the front ends. I need to set up 2 connections, one to the development front end and one to the live front end and then it generates say a spilt screen showing me the difference
between the forms and code. Does anyone know if such a thing exists
many thanks
Andy
I know of one specific one, "Total Access Detective" by FMS
( http://www.fmsinc.com/products/detective/index.html). It's pretty
good, although I don't use it anymoe (too cheap :-). I mostly create
my own comparison code to show me differences in table structures and
data, and try to keep meticulous notes.
There was another product that allowed you to work on your local copy,
and when happy, it automatically updated the master based on your
changes and had pretty good reviews. Saw it a few years back but never
looked much into it, so the name evades me at this time. Should I find
it again, I'll post it.
JV
"aaj" <a.*@c.com> wrote in message news:<40******* *************** @news.easynet.c o.uk>... Hi all
I have Aceess 2000 front end linking to SQLServer 2000 BE.
While developing the backend I work on an offline database. When happy I update the live one. Any changes I've made to the testone are highlighted by running some database comparison software that shows all the differencs between the two. I then manually update the live one.
I am after something similar for the front ends. I need to set up 2 connections, one to the development front end and one to the live front end and then it generates say a spilt screen showing me the difference between the forms and code. Does anyone know if such a thing exists
many thanks
Andy This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dave Brueck |
last post by:
Below is some information I collected from a *small* project in which I wrote
a Python version of a Java application. I share this info only as a data
point (rather than trying to say this data "proves" something) to consider
the next time the "Python makes developers more productive" thread starts up
again.
Background
==========
An employee who left our company had written a log processor we use to read
records from text files (1...
|
by: bettervssremoting |
last post by:
To view the full article, please visit
http://www.BetterVssRemoting.com
Better VSS Remote Access Tool
This article makes a detailed comparison among SourceAnyWhere,
SourceOffSite, VSS Remoting and possible others.
Keywords: VSS Remote Access, VSS Web Access, VSS Internet Access,
|
by: John |
last post by:
I need to upsize my Access 2002 "database" to a larger database. I
would like to use Access projects to manage the database. With this
preference, it would seem MS SQL Server 2000 is the ideal way to go.
Nothwithstanding scalability, performance, pricing, my question is
this: what are the distinct advantages MS SQL Server have over
Oracle when used in conjunction with Access? What are the drawbacks, if
any, to using an Access project...
|
by: mayamorning123 |
last post by:
A comparison among six VSS remote tools including SourceOffSite ,
SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET
To view the full article, please visit
http://www.BetterVssRemoting.com
Better VSS Remote Access Tool
This article makes a detailed comparison among SourceAnyWhere 4.0,
SourceOffSite 4.1, VSS Connect 1.5, SourceXT 2.1, VSS Remoting 2.5,
|
by: Paul Edwards |
last post by:
I have the following C program:
#include <stdio.h>
int main(void)
{
unsigned short x = 32768, y=16384;
if (x > y)
{
| |
by: bettervssremoting |
last post by:
To view the full article, please visit
http://www.BetterVssRemoting.com
Better VSS Remote Access Tool
This article makes a detailed comparison among SourceAnyWhere,
SourceOffSite, VSS Remoting and possible others.
Keywords: VSS Remote Access, VSS Web Access, VSS Internet Access,
|
by: Tom Kelleher |
last post by:
Folks,
I have a client who will likely be looking at ASP.NET in the near
future. They have an internal developer who is convinced there are
"scalability problems" with ASP.NET. This client has a very large, very
critical, growing ASP app that I built with them in classic ASP, so they
are interested in the benefits of moving up to something better.
I want to convince them to go with ASP.NET -- preferrably VB.NET, but C#
would be fine...
|
by: spam.noam |
last post by:
Hello,
Guido has decided, in python-dev, that in Py3K the id-based order
comparisons will be dropped. This means that, for example, "{} < "
will raise a TypeError instead of the current behaviour, which is
returning a value which is, really, id({}) < id().
He also said that default equality comparison will continue to be
identity-based. This means that x == y will never raise an exception,
as is the situation is now. Here's his reason:
|
by: Jim Devenish |
last post by:
I want to create a column alias to represent the comparison of two
columns (ie a boolean result of True or False). A simple example is:
Select VehicleFinanceID, SalePrice > PurchasePrice As isProfit
>From VehicleFinance
but I get an error 'Incorrect syntax near >'
Books online states that the select_list can contain column_name or
expression
|
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: 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: 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: 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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |