Forum Discussion

m_essaid's avatar
m_essaid
Valued Contributor
10 years ago

comparing dbtables

Hi,

 

I need a simple way to compare .mdb tables.

 

I wish I could work in the same way as I work with Files or XML files... Like putting a MS Access table into Stores as a baseline and comparing everyday this to a table in a location through a odbc connection or other.

 

I stored a datatable, but every comparison says that the content is the same even if I modify the content of the table pointed by the odbc connector.

 

I have to modify the stored dbtable to get a difference, ok, but where is the other table on which the comparision is made ?

 

I must be missing something obvious...

 

Help please !

 

Mehdi

3 Replies

    • m_essaid's avatar
      m_essaid
      Valued Contributor
      10 years ago

      Hi Tanya,

       

      I don't understand why my checkpoint always pass whenever I change some datas in the table or not.

      • m_essaid's avatar
        m_essaid
        Valued Contributor
        10 years ago

        Ah that's ok.

        I don't know why using an ODBC connector wasn't working,

        I use OLE DB for Jet now

        Mehdi