If they have a webserver running from which you can connect to the RBase db using either RBase Driver or Oterro (I assume the RBase driver would be sufficient since it would be read-only access), you could just use ADO and the PersistXML feature to transfer the record as a Stream, then reassemble it locally using the reverse process. Actually, if it didn't have to be "Exactly" real time, you could do the same thing using a little bit of VBScript code and email....
----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, October 04, 2004 5:28 PM Subject: [RBG7-L] - Re: Remote ODBC connection > > Any thoughts as to how this is done and any major concerns on using it if > > possible. It is my understanding that one can make an ODBC use an IP address. > > It depends entirely on the ODBC driver supplied by AccPac. Most client server > systems allow you to attach over the internet using an IP address. File-server > based database (like R:Base) do not -- the running instance of the ODBC driver > must be able to "see" the files locally (including on a shared drive on a local > area network). > -- > Larry >
