asp : compare records in two access databases

[Charlotte]

Hi,

i've googeled to find a asp-script that can compare all the records in two
different access databases
the mdb's have exactly the same tables
what i want is that (the output) all the differences comes in a html-table
in a webpage
can anybody help me, are give me a example ?

thanks
charlotte

[McKirahan]

Re: compare records in two access databases

"Charlotte" <charlotte.dele euw@SPAMtelenet .bewrote in message
news:%PKrj.2819 6$9Z2.22687@new sfet14.ams...

>
Hi,
>
i've googeled to find a asp-script that can compare all the records in two
different access databases
the mdb's have exactly the same tables
what i want is that (the output) all the differences comes in a html-table
in a webpage
can anybody help me, are give me a example ?

Is a primary key defined?
What do you want the output to look like?

Given this layout: "key,field1,fie ld2"
where table 1 contains
1,a,b
2,c,d
and table 2 contains::
1,a,b
3,e,f
How would you want the differences reported?

Perhaps just identifying the "key" differences?
table1 : 1=,2+,3-
table2 : 1=,2-,3+

[Bob Barrows [MVP]]

Re: compare records in two access databases

Evertjan. wrote:

Bob Barrows [MVP] wrote on 11 feb 2008 in
microsoft.publi c.inetserver.as p.general:
>
I don't think, in the case of the OP, Bob, this is about users and
about large databases, but about the owner wanting to do some
houeshold jobs on her database on a semi regular basis, say once a
year.

I'm not sure how you came to that conclusion.

>
Setting a process in motion that takes 10 minutes or perhaps an hour
in ASP is not that bad.

It is if a busy web server is involved.

Being able to do that from different
locations is a nice plus of the ASP method.

Along with various other remote procedure techniques.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Charlotte]

Re: compare records in two access databases

Hi,
>
i've googeled to find a asp-script that can compare all the records in two
different access databases
the mdb's have exactly the same tables
what i want is that (the output) all the differences comes in a html-table
in a webpage
can anybody help me, are give me a example ?
>
thanks
charlotte

example:
I have two MDB and both have exactly the same table (table1)
table1 from MDB1 and table1 from MDB2 have exactly the same structure
each containing these fields:
id , lastname , firstname

in MDB1 are 100 records
in MDB2 are 90 records
(records with id 91,92,93,.....1 00 aren't there)
and record with id 50 has a different firstname

so, this will be:

50 - nothing - wrong firstname that is in MDB1
91 - peeters - kurt
92 - hannivoort - evertjan
93 - deleeuw - charlotte
....
....
100 - travolta - john

the html-table is:

<table>
<tr>
<td>50</td>
<td></td>
<td>wrong firstname</td>
</tr>
<tr>
<td>91</td>
<td>peeters</td>
<td>kurt</td>
</tr>
<tr>
<td>92</td>
<td>hannivoor t</td>
<td>evertjan</td>
</tr>
<tr>
<td>93</td>
<td>deleeuw</td>
<td>charlotte </td>
</tr>
....
....
<tr>
<td>100</td>
<td>travolta</td>
<td>john</td>
</tr>
</table>

so, the records that aren't the same in the two MDB comes in the html-table
and also all the records witch aren't in MDB1

I hope this is ubderstandable

charlotte

[Bob Barrows [MVP]]

Re: compare records in two access databases

Charlotte wrote:

>Hi,
>>
>i've googeled to find a asp-script that can compare all the records
>in two different access databases
>the mdb's have exactly the same tables
>what i want is that (the output) all the differences comes in a
>html-table in a webpage
>can anybody help me, are give me a example ?
>>
>thanks
>charlotte

>
>
example:
I have two MDB and both have exactly the same table (table1)
table1 from MDB1 and table1 from MDB2 have exactly the same
structure each containing these fields:
id , lastname , firstname
>
in MDB1 are 100 records
in MDB2 are 90 records
(records with id 91,92,93,.....1 00 aren't there)
and record with id 50 has a different firstname
>

Will mdb2 ever contain records that aren't in mdb1?

Are the two databases on the same network (allowing a linked table to be
used to enable an easy query solution)?


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Charlotte]

Re: compare records in two access databases

>>Hi,
>>>
>>i've googeled to find a asp-script that can compare all the records
>>in two different access databases
>>the mdb's have exactly the same tables
>>what i want is that (the output) all the differences comes in a
>>html-table in a webpage
>>can anybody help me, are give me a example ?
>>>
>>thanks
>>charlotte

>>
>>
>example:
>I have two MDB and both have exactly the same table (table1)
>table1 from MDB1 and table1 from MDB2 have exactly the same
>structure each containing these fields:
>id , lastname , firstname
>>
>in MDB1 are 100 records
>in MDB2 are 90 records
>(records with id 91,92,93,.....1 00 aren't there)
>and record with id 50 has a different firstname
>>

>
Will mdb2 ever contain records that aren't in mdb1?
>
Are the two databases on the same network (allowing a linked table to be
used to enable an easy query solution)?

the two databases are in the same LAN
MDB1 is on webserver 1
and MDB2 is on webserver 2

webserver 1 is the real webserver for everyone on are LAN
webserver 2 is my test-webserver

[Bob Barrows [MVP]]

Re: compare records in two access databases

Charlotte wrote:

>>>Hi,
>>>>
>>>i've googeled to find a asp-script that can compare all the records
>>>in two different access databases
>>>the mdb's have exactly the same tables
>>>what i want is that (the output) all the differences comes in a
>>>html-table in a webpage
>>>can anybody help me, are give me a example ?
>>>>
>>>thanks
>>>charlotte
>>>
>>>
>>example:
>>I have two MDB and both have exactly the same table (table1)
>>table1 from MDB1 and table1 from MDB2 have exactly the same
>>structure each containing these fields:
>>id , lastname , firstname
>>>
>>in MDB1 are 100 records
>>in MDB2 are 90 records
>>(records with id 91,92,93,.....1 00 aren't there)
>>and record with id 50 has a different firstname
>>>

>>
>Will mdb2 ever contain records that aren't in mdb1?
>>
>Are the two databases on the same network (allowing a linked table
>to be used to enable an easy query solution)?

>
>
the two databases are in the same LAN
MDB1 is on webserver 1
and MDB2 is on webserver 2
>
webserver 1 is the real webserver for everyone on are LAN
webserver 2 is my test-webserver

Do you know how to create a linked table in Access? That will make this
relatively easy since you will be able to create a query using a full outer
join to generate the records for your report.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Charlotte]

Re: compare records in two access databases

>>>>Hi,
>>>>>
>>>>i've googeled to find a asp-script that can compare all the records
>>>>in two different access databases
>>>>the mdb's have exactly the same tables
>>>>what i want is that (the output) all the differences comes in a
>>>>html-table in a webpage
>>>>can anybody help me, are give me a example ?
>>>>>
>>>>thanks
>>>>charlotte
>>>>
>>>>
>>>example:
>>>I have two MDB and both have exactly the same table (table1)
>>>table1 from MDB1 and table1 from MDB2 have exactly the same
>>>structure each containing these fields:
>>>id , lastname , firstname
>>>>
>>>in MDB1 are 100 records
>>>in MDB2 are 90 records
>>>(records with id 91,92,93,.....1 00 aren't there)
>>>and record with id 50 has a different firstname
>>>>
>>>
>>Will mdb2 ever contain records that aren't in mdb1?
>>>
>>Are the two databases on the same network (allowing a linked table
>>to be used to enable an easy query solution)?

>>
>>
>the two databases are in the same LAN
>MDB1 is on webserver 1
>and MDB2 is on webserver 2
>>
>webserver 1 is the real webserver for everyone on are LAN
>webserver 2 is my test-webserver

>
Do you know how to create a linked table in Access? That will make this
relatively easy since you will be able to create a query using a full
outer join to generate the records for your report.

yes, I know how to make linked tables, but that's not our intention
our intention is an ASP-page with an html-table like I wrote above

thanks

[Charlotte]

Re: compare records in two access databases


so, ....... is there someone who can (will) give me an example

thanks
charlotte

[Bob Barrows [MVP]]

Re: compare records in two access databases

Charlotte wrote:

so, ....... is there someone who can (will) give me an example
>
thanks
charlotte

Patience ... i'm working on it. :-)
It's not something I have ever done, so I have nothing to copy and paste.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Jeff Dillon]

Re: compare records in two access databases


"Charlotte" <charlotte.dele euw@SPAMtelenet .bewrote in message
news:Pk4sj.4954 3$vu5.19456@new sfet12.ams...

>
so, ....... is there someone who can (will) give me an example
thanks
charlotte
>
>

How often do you have to do this? I'm wondering "why" an ASP page?

Jeff

[McKirahan]

Re: compare records in two access databases

Jeff Dillon" <jeffdillon@hot mailremove.comw rote in message
news:OdPMajQbIH A.1960@TK2MSFTN GP02.phx.gbl...

>
"Charlotte" <charlotte.dele euw@SPAMtelenet .bewrote in message
news:Pk4sj.4954 3$vu5.19456@new sfet12.ams...

so, ....... is there someone who can (will) give me an example
thanks
charlotte

>
How often do you have to do this? I'm wondering "why" an ASP page?

Why not do it offline and generate a static HTML page?

[Bob Barrows [MVP]]

Re: compare records in two access databases

Jeff Dillon wrote:

"Charlotte" <charlotte.dele euw@SPAMtelenet .bewrote in message
news:Pk4sj.4954 3$vu5.19456@new sfet12.ams...

>>
>so, ....... is there someone who can (will) give me an example
>thanks
>charlotte
>>
>>

>
How often do you have to do this? I'm wondering "why" an ASP page?
>
Jeff

Oh no, you're not allowed to wonder that ... ;-)

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Jeff Dillon]

Re: compare records in two access databases

<snip>

Why do you need an ASP page for this? How often do you plan to do this?

Jeff