DataBase - Make an mdb replicable via DAO in A07

Asked By Chris V.

06-Oct-09 05:11 PM

Hi newsgroup

The following code works fine in A03 to create a new replication master:
Dim ws As DAO.Workspace
Dim db As DAO.Database
Dim prp As DAO.Property
Set ws = DBEngine(0)
Set db = ws.CreateDatabase("d:\Master.mdb", dbLangGeneral, dbVersion40)
Set prp = db.CreateProperty("Replicable", dbText, "T")
db.Properties.Append prp
db.Close

But it fails in A07 at the line:
db.Properties.Append prp
with Error 3251: Operation is not supported for this type of object

I tried:
Set prp = db.CreateProperty("ReplicableBool", dbBool, True)
which should be equivalent, but gives the same error.

I also tried other version numbers instead of dbVersion40 (30, 20, ...) with
no success.

Please do not answer that A07 does not support replication. It should for
mdb's, it only does not for accdb's.

I am working with A07 (12.0.6423.1000) SP2 MSO (12.0.6425.1000)

Can anybody help me? I would appreciate very much!
Thank you.

06-Oct-09 09:24 PM

This sounds suspiciously like the bug in DAO synchronization in the
original shipping version of A2007. It was fixed in SP1. Perhaps it
has reverted?

I do not use A2007 (though I just downloaded O2007 via MSDN so I can
start working with it), so I cannot test your code myself.

Have you gone through the Object Browser in A2007 and checked that
there are not different objects in teh new version of DAO? I have
reviewed it in A2003, and note that there are a number of new
properties that are designed to account for the differences between
plain old Jet 4 and the new ACE features. For instance, from outside
A2007, there are two Field types/Field, Field and Field2. If you
examine the properties/methods of Field2, you will see that it is the
same as the traditional Field object type, but extended to support
new field types in the ACE, such as Attachments and Multivalue
fields.

While I would not expect what you are doing to cause a problem,
perhaps there are some differences there in the database properties
data type or in the properties collection that are causing the
problem.

I know it is a long shot, but it is a place to look.

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

07-Oct-09 04:46 AM

Hi David

Thank you for your help. I must admit that it was not helpfull directly, but
indirectly by knowing that there is somebody out there believing there could
be a solution. I must also admit, that I was not quite correct in my
description of the problem. In fact the code works fine if I use the
parameter dbVersion40 to create a mdb file in format A02-A03. As I was
debuging for hours already I thought I had tested it this way, but obviously
I was not.

So for users that get the same error in A07: Make sure to use an mdb file in
the format of A02-A03 and do not try it with a format of A00!

Cheers

08-Oct-09 12:28 AM

Er, what? You mean A2007? Or A2000?

Have you tested it with an A2007-format MDB?

It really ought to work with all versions, though.

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/