Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 3rd, 2004, 06:29 PM
Authorized User
 
Join Date: Sep 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default comparing access and Oracle rows

Hi everyone,

I have 2 seperate databases and I need to check for rows that are different from each other in a table. One database is running on SQL Server and the other on Oracle.

I used access to link the tables in a database and am using queries to check the tables. I used joins to make such a comparison and it seems to work fine. However, I am having a few problems.

When I try to compare entries that are null, it always shows that the records are different. It seems that SQL Server and Oracle handle null values seperately. Is there any way to compare these null values properly in Access?

How can I compare BLOB and Memo fields of the databases. Access would not let me compare entries that have these datatypes.

Thanks,
Sincerely,
Pankaj

Any help would be appreciated.

Thanks,
Pankaj







Similar Threads
Thread Thread Starter Forum Replies Last Post
comparing rows of two workbooks nasirmunir Excel VBA 2 July 9th, 2008 08:10 PM
Access 2000 has many (demo) rows fizzerchris Access 3 April 8th, 2008 11:59 AM
comparing rows of two DataGridViews R48 C# 0 November 7th, 2006 04:03 AM
Comparing certain rows in one table MrHicks Access 2 November 8th, 2004 04:00 PM
prob with comparing date in access nilesh_parmar Access 1 March 29th, 2004 10:59 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.