Re: Jet Replication in Access 2007

Peter <peter.grman@xxxxxxxxx> wrote in
news:c9ac9e8d-f028-46ad-a5a1-a8443b97532e@xxxxxxxxxxxxxxxxxxxxxxxxxxx
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=Microsoft.ACE.OLEDB.12.0;User ID=Entwickler;
Password=qwerASDF12;Data Source=c:\Programme\BAP
\BAP_Prog_V13_FINAL.mdb;Mode=Share Deny None;Extended
Properties="";Jet OLEDB:System
database=c:\Programme\BAP\BAP.mdw;Jet OLEDB:Registry
Path=Software\Microsoft\Office\12.0\Access\Access 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;Jet OLEDB:Compact Without Replica Repair=False;Jet
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.ActiveConnection = GetJetConnection(GetINIData("Pfade",
"Daten"))
repMaster.CreateReplica 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/
.

Relevant Pages

  • Re: Internet Sync with TSI
    ... Server replication as I don't have a good feeling about Jet (or ... Just looking at Vista, Jet replication seems to have been ... that replication support is going to die out. ...
    (microsoft.public.access.replication)
  • Re: Internet Sync with TSI
    ... Server replication as I don't have a good feeling about Jet (or ... Just looking at Vista, Jet replication seems to have been ... that replication support is going to die out. ...
    (microsoft.public.access.replication)
  • Re: Internet Sync with TSI
    ... Server replication as I don't have a good feeling about Jet (or ... Just looking at Vista, Jet replication seems to have been ... that replication support is going to die out. ...
    (microsoft.public.access.replication)
  • Re: Do Transactions guard against corruption?
    ... into one, that is called replication. ... But Jet replication does not use ... In replication or a multi-user database? ... they are not locked out as soon as the transaction also append ...
    (microsoft.public.access.modulesdaovba)
  • Re: Can I edit the MSys* tables directly?
    ... The only way to eliminate replication errors is to ... I'm pretty sure the TSISynchronizer uses defined Jet calls, ... and write directly to the MDB file. ... The Jet engine provides a way to eliminate recoreds in MSysErrors -- ...
    (microsoft.public.access.replication)