Jet Replication in Access 2007

**David W. Fenton** · Jun 27 '08, 07:25 PM

Re: Jet Replication in Access 2007

Peter <peter.grman@gm ail.comwrote in
news:c9ac9e8d-f028-46ad-a5a1-a8443b97532e@x4 1g2000hsb.googl egroups.co
m:

i've got an older Access program, which is written in the version
2000 and i'd like to use it with my new office 2007, so access
2007.
>
In the program, there is an replication written with the Jet
Replica Library, and i read on a microsoft site, that replications
in jet schould still work in access 2007, if you still use the old
extension .mdb
>
so i tried it, but there comes the error -2147467259 - "The
Microsoft Office Access - Databasemodul was not initialized."
>
Here is the connection-string, i use to connect to the replicable
datafile:
"Provider=Micro soft.ACE.OLEDB. 12.0;User ID=Entwickler;
Password=qwerAS DF12;Data Source=c:\Progr amme\BAP
\BAP_Prog_V13_F INAL.mdb;Mode=S hare Deny None;Extended
Properties="";J et OLEDB:System
database=c:\Pro gramme\BAP\BAP. mdw;Jet OLEDB:Registry
Path=Software\M icrosoft\Office \12.0\Access\Ac cess Connectivity
Engine;Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet
OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1; Jet OLEDB:New Database
Password="";Jet OLEDB:Create System Database=False; Jet
OLEDB:Encrypt Database=False; Jet OLEDB:Don't Copy Locale on
Compact=False;J et OLEDB:Compact Without Replica Repair=False;Je t
OLEDB:SFP=False ;Jet OLEDB:Support Complex Data=True;"

This is an OLEDB connect string, and makes no sense, since you can't
have linked tables with ADO.

and here is the code, i use to replicate the data:
>
Dim repMaster As New JRO.Replica
>
repMaster.Activ eConnection = GetJetConnectio n(GetINIData("P fade",
"Daten"))
repMaster.Creat eReplica strPfad, "Repliziert Daten von BAP"
>
Does anyone has in idea?
The Office 2007 is installed complete. I also tried to change the
Jet OLEDB:Engine Type to version 6, but this also didn't help
anything.

Why are you using OLEDB?

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

**Peter** · Jun 27 '08, 07:25 PM

Re: Jet Replication in Access 2007

Why are you using OLEDB?

I just take the connection string from the currentproject and add a
password and change the Data Source property to connect to the other
database, because i tried to connect to it, as it is shown in the
msdn, but it didn't work, so i tried it this way and with access 2000
and 2003 it worked

so you mean the connection string is wrong, and i have to change it?

**David W. Fenton** · Jun 27 '08, 07:25 PM

Re: Jet Replication in Access 2007

Peter <peter.grman@gm ail.comwrote in
news:9eaeee78-cd14-4214-acb1-361a756d4d09@d1 g2000hsg.google groups.com
:

>Why are you using OLEDB?

>
I just take the connection string from the currentproject and add
a password and change the Data Source property to connect to the
other database, because i tried to connect to it, as it is shown
in the msdn, but it didn't work, so i tried it this way and with
access 2000 and 2003 it worked
>
so you mean the connection string is wrong, and i have to change
it?

I don't know how you manage to get an OLEDB connect string for your
current connection. Then again, I've never used any form of
ADO/OLEDB, so maybe I'm confused. I'd think your front end would
have linked tables (which are, by definition, DAO). Of course,
you're using JRO, which works counterintuitiv ely, because it's one
of the ugly stepchildren of the ADO debacle.

I don't have any advice to offer, except to dump JRO, which never
made the slightest sense to me in the first place.

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

**Peter** · Jun 27 '08, 07:25 PM

Re: Jet Replication in Access 2007

I just take the connection string from the currentproject and add

a password and change the Data Source property to connect to the
other database, because i tried to connect to it, as it is shown
in the msdn, but it didn't work, so i tried it this way and with
access 2000 and 2003 it worked

>

so you mean the connection string is wrong, and i have to change
it?

>
I don't know how you manage to get an OLEDB connect string for your
current connection. Then again, I've never used any form of
ADO/OLEDB, so maybe I'm confused. I'd think your front end would
have linked tables (which are, by definition, DAO). Of course,
you're using JRO, which works counterintuitiv ely, because it's one
of the ugly stepchildren of the ADO debacle.

i just take CurrentProject. Connection
and yes there are linked tables in the forntend
and firstly i programmed the synchronization in DAO, but this isn't
supported by Access 2007 anymore, so now i had to recode it using JET
whichs works in the older Access versions as the DAO but doesn't work
in Access 2007

**David W. Fenton** · Jun 27 '08, 07:25 PM

Re: Jet Replication in Access 2007

Peter <peter.grman@gm ail.comwrote in
news:2622d502-987c-4959-8486-4e66b19e83ae@a1 g2000hsb.google groups.com
:

I just take the connection string from the currentproject and
add a password and change the Data Source property to connect
to the other database, because i tried to connect to it, as it
is shown in the msdn, but it didn't work, so i tried it this
way and with access 2000 and 2003 it worked

>>

so you mean the connection string is wrong, and i have to
change it?

>>
>I don't know how you manage to get an OLEDB connect string for
>your current connection. Then again, I've never used any form of
>ADO/OLEDB, so maybe I'm confused. I'd think your front end would
>have linked tables (which are, by definition, DAO). Of course,
>you're using JRO, which works counterintuitiv ely, because it's
>one of the ugly stepchildren of the ADO debacle.

>
i just take CurrentProject. Connection
and yes there are linked tables in the forntend
and firstly i programmed the synchronization in DAO, but this
isn't supported by Access 2007 anymore, so now i had to recode it
using JET whichs works in the older Access versions as the DAO but
doesn't work in Access 2007

Eh? Yes, of course, DAO is still supported in A2K7. However, there
was a bug in the initial shipping release of A2K7 that caused DAO
synchs to fail, but that was fixed (first by a hotfix, and then in
the first service pack).

The idea that JRO would be preferable in A2K7 is ridiculous, as MS
is deprecating ADO (and its ugly stepchildren) for work with Jet
data. DAO is the way to go -- it's the live, in-development data
interface for Jet data. ADO/JRO on the other hand, are completely
dead.

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

Jet Replication in Access 2007

Jet Replication in Access 2007

Comment

Comment

Comment

Comment

Comment