Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / March 2005

Tip: Looking for answers? Try searching our database.

replicas and MSDataShape

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lothar Geyer - 10 Mar 2005 22:11 GMT
I am using an Access 2000 database with my VB application. After opening
the database I want to know if it is replicated. So I do

  Set repReplica = New JRO.Replica
  With repReplica
    Set .ActiveConnection = dbCNN
    ReplikationGenutzt = .ReplicaType <> jrRepTypeNotReplicable
  End With
  Set repReplica = Nothing

This works fine with an ADO connection defined using

  .Provider = "Microsoft.Jet.OLEDB.4.0"
  .Properties("Data Source") = dbDatabasePfad
  .Properties("Jet OLEDB:System Database") = SystemDB

However, when I create the connection with

  .Provider = "MSDataShape.1"
  .Properties("Data Provider") = "MICROSOFT.JET.OLEDB.4.0"
  .Properties("Data Source") = dbDatabasePfad
  .Properties("Extended Properties") = "Jet OLEDB:System Database=" &
SystemDB

I get an error at Set .ActiveConnection: connection closed or invalid.
But normal access to the database works without problems.

As I need the MSDataShape for the Data Report Designer: What's the best
was to solve the problem? Should I create an extra connection for the
Data Report Designer?

Lothar Geyer
Cheval - 10 Mar 2005 22:22 GMT
Sorry but huh? How do(es) the question(s) relate to MS Access replication?

I am using an Access 2000 database with my VB application. After opening
the database I want to know if it is replicated. So I do

  Set repReplica = New JRO.Replica
  With repReplica
    Set .ActiveConnection = dbCNN
    ReplikationGenutzt = .ReplicaType <> jrRepTypeNotReplicable
  End With
  Set repReplica = Nothing

This works fine with an ADO connection defined using

  .Provider = "Microsoft.Jet.OLEDB.4.0"
  .Properties("Data Source") = dbDatabasePfad
  .Properties("Jet OLEDB:System Database") = SystemDB

However, when I create the connection with

  .Provider = "MSDataShape.1"
  .Properties("Data Provider") = "MICROSOFT.JET.OLEDB.4.0"
  .Properties("Data Source") = dbDatabasePfad
  .Properties("Extended Properties") = "Jet OLEDB:System Database=" &
SystemDB

I get an error at Set .ActiveConnection: connection closed or invalid.
But normal access to the database works without problems.

As I need the MSDataShape for the Data Report Designer: What's the best
was to solve the problem? Should I create an extra connection for the
Data Report Designer?

Lothar Geyer
Lothar Geyer - 10 Mar 2005 23:10 GMT
I think it is a replication related question as the JRO.Replica seems
not to work with the MSDataShape provider. So I wanted to know whether
this is true or I am wrong.

> Sorry but huh? How do(es) the question(s) relate to MS Access replication?
>
[quoted text clipped - 30 lines]
>
> Lothar Geyer
Lothar Geyer - 11 Mar 2005 20:56 GMT
Once more my questions:

1)
Obviously JRO.Replica does not allow an .ActiveConnection using
MSDataShape as provider. Could someone give me a link to related
documentation?

2)
Why is the MSDataShape provider not supported? Is this "by design" or a bug?

Thank you.
Lothar Geyer

> I think it is a replication related question as the JRO.Replica seems
> not to work with the MSDataShape provider. So I wanted to know whether
[quoted text clipped - 35 lines]
>>
>> Lothar Geyer
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.