[thelist] Replicated Access-97 Databases and MDAC 2.1 Problem

[david.landy at somerfield.co.uk]

Ken,

Long time since, but found it!! Here's that article detailing the problem
with replicated Access-97 databases and MDAC 2.1/Access ODBC Driver 4.xx,
requiring rollback:

"The MDAC 2.1 and MDAC 2.5 version of the Access ODBC Driver does not write
to older format-replicated databases. If you have an Access design master or
replica database in Access 97 format (or Access 95 format), the MDAC 2.1 (or
MDAC 2.5) Access ODBC driver can open this database, but only in read-only
mode. In order to both read and write with ODBC, you need to use the
Microsoft Access ODBC driver that shipped with MDAC 2.0. The error reported
when attempting to update an older format replica database is "Operation not
supported on replicable databases that have not been converted to the
current version." Workarounds include converting the database to Access 2000
format, dropping back to the MDAC 2.0 SP2 version of the ODBC driver, or
unreplicating the database."

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q237/9/94.asp&NoWebContent=1

David

-- 
David Landy, IT Consultant, Business Intelligence
Somerfield/KwikSave Support Centre
Whitchurch, Bristol, UK. Tel: 0117 301 8977
david.landy at somerfield.co.uk   

This is the true joy of life. The being used for a purpose 
Recognized by yourself as a mighty one. 
George Bernard Shaw
 
If you are not the intended recipient of this e-mail, please preserve the
confidentiality of it and advise the sender immediately of any error in
transmission. Any disclosure, copying, distribution or action taken, or
omitted to be taken, by an unauthorised recipient in reliance upon the
contents of this e-mail is prohibited. Somerfield cannot accept liability
for any damage which you may sustain as a result of software viruses so
please carry out your own virus checks before opening an attachment. In
replying to this e-mail you are granting the right for that reply to be
forwarded to any other individual within the business and also to be read by
others. Any views expressed by an individual within this message do not
necessarily reflect the views of Somerfield.  Somerfield reserves the right
to intercept, monitor and record communications for lawful business
purposes.