Hello Guy, You got me stumped on this one. I'm not even sure http is the right protocol for what you want to do.
Mostly replication is used on each end of the net, between machines, not terminating on the net. I think you may have to contact your ISP and see if they know anything. Regards Robin. PS I'll be very interested in hearing how you finally solve the problem. --- In ms_access@yahoogroups.com, "Guy Harley" <[EMAIL PROTECTED]> wrote: > The MS article did envision that the master would be created on the server > which I cannot do. If I create the replica on my machine, the MS Access > system tables record that the replica is located on my computer. If I > subsequently upload the replica to the server, the master will not > synchronize with it as (a) there is no way to make the connection over the > Internet by browsing to it using the MS Access replication manager and (b) > MS Access determines that the replica is in the wrong place (i.e. not still > on my computer) and will not synchronize with it. > > The MS Access replication manager does allow you to browse to an ftp > location but it doesn't permit you to browse to a directory within an ftp > location and does not seem to be able to "see" a database located in my ftp > root. > > What I really need is a step by step guide to replication over the Internet > rather than MS's "clear as mud" articles in the knowledgebase. > > Guy Harley > 1 Driftwood Crt > TERINGIE SA 5072 > AUSTRALIA > Tel: (W) (08) 8211 9211 > (H) (08) 8332 9928 > (M) 0404 177 342 > > -----Original Message----- > From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Robin > Sent: Monday, 9 May 2005 10:53 PM > To: ms_access@yahoogroups.com > Subject: [ms_access] Re: Replication > > Hello Guy, > Intresting, I would think you'd only need admin rights if the master > was on the web. Of course this is not the case and the only thing I > can think of, off hand, is that the URL is actually a set of numbers > shown as words so us poor humans can understand it so maybe you need > the number equivelant. > > I'm guessing here. Are there any entries in the table that look like > something? > > Regards > Robin. > > > --- In ms_access@yahoogroups.com, "Guy Harley" <[EMAIL PROTECTED]> wrote: > > I posted this last week but got no response so I thought I'd give > it another > > try. > > > > I want to replicate an MS Access database. One copy would be > placed on a web > > server, the other on my own computer. I would then synchronise the > two via > > the Internet. > > > > > > I cannot work out how to do this. The paper on the Microsoft web > site on > > this topic assumes that you have administrator rights on the > server and can > > configure it. I don't have admin rights (I only rent the space). > Another > > article suggests using the following code (interestingly it says > you only > > have to specify the web site not the directory or filename of the > database): > > > > > > Dim db As DAO.Database > > > > Set db = CurrentDb() > > > > db.Synchronize "http://www.harley.net.au";, dbRepSyncInternet + > > dbRepImpExpChanges > > > > However, when I run the code, I get "Invalid http address". Help > explains: > > "The HTTP address specified is not valid for this replica set. The > HTTP > > address supplied did not match any values in the field > InternetAddress in > > the system table MSysTranspAddress". Of course, I cannot alter > > MSysTranspAddress. > > > > Any suggestions? > > > > Guy Harley Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
