Remote Data Access

Remote Data Access

Post by Craig Mrllo » Thu, 12 Nov 1998 04:00:00

Hi All,

I am writing  a program which I need to use Remote Data Access With.

There will be a server located in Manchester in the UK, and There will be
roughly about 20 sites around the uk.  The main machine (Server) in
Manchester wants to be able to syncronize all the databases from every other
site.  They want to be able to view the data from every site.

They also want to when needed get data on demand, I.e call into the site and
view data.

Has anybody got any good suggestions as the way to go about acheiving this.

I have not RDA before, But I am quite upto date with Data Access. I am
currently using VB 6, with the ADO data objects.

I thought about syncronizing the databases every night.

I would be very greatful for any input on this situation.

Thanks in advance.



1. Remote data access - how access a database on the web

    How can I access with my vb application a database on the phidji server
( ?
    My database is in the db directory.
    Ive been trying the code below:

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim SQL As String
Dim DB As String

DB = "Provider=MS Remote;Remote Provider=Microsoft.Jet.OLEDB.4.0;Persist
Security Info=False;Data Source = " & Server.MapPath("/db/Biblio.mdb") & "
;Remote Server=;"

cn.Open DB
SQL = "SELECT * FROM Authors"

rs.Open SQL, cn, adOpenStatic, adLockReadOnly

'Displays the first field in the first Record
MsgBox rs(0)

But it doesnt works .
Someone can help me , please...


2. Where is the declaration of the IDBPromptInitialize interface??

3. remote data access failure from a job

4. Stored procedure question SQL Server 6.5

5. remote data access through modem

6. D3-ODBC Almost There - Please Help

7. remote data access fails in a job

8. Redistribution and confusing behavior

9. Best modem settings for remote data access

10. Fastest Remote Data Access?

11. Automatic Remote Data Access

12. Remote Data Access

13. remote data access