Create Query for mathing data

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

I have a Client\Server application

On the client side and on the server side i have many tables with the same
stracture and i want to compare with them.

I would like to get all the records on the Client side that don't match to
the server side or not exist on the server side

For this (as far as i know) i need to build Left\Right join between the same
tables and and use all the fields.

This way is static so i need to build query for each table.

Is there a way to create global query that do the maches and getting the
name of the tables by Parameter?

or create a global sql Sentance that do this by adding only the name of the
tables to it?

any help would be useful
 
No, but you can use VBA code to do the task.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thanks S.Clark for your attantion

I thought about diffrent way to do this with VB and SQL:

I have sqlExprassion that returns only the tables that were changed.

Then I use VB to get the names of the tables and use Execute method that do
two things:
1. Delete the data from the client side and insert the data from the server
side. For the insert and delete i don't need the table structure.

The main question is does this simple thing will cause bad performance?

From my experiance VB on data working slower then sql so what way it's
better to use?
 
Performance is sometimes irrelevant when it comes down to simply
accomplishing the task.
 
Back
Top