Re: Synchronising with remote server



Hi John

You may want to consider using replication, you may also want to consider
moving from Access to SQL Server 2005 Express and just using Access as the
front end.

John

"John" <John@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:T7Odneycs7SkbDDeRVnysg@xxxxxxxxxxxx
> Hi
>
> We have an internal ms access database which we need to synchronise with
> our
> website with sql server 2005 backend which is hosted on a public host. My
> question is; is there a way to keep the two databases synchronised using
> the
> technologies built in sql server 2005 and/or access? We also have the
> possibility of an in-house sql server 2000. Can this be used in anyway to
> help, perhaps by moving data from in house access to in house sql server
> 2000 and then synching sql server 2000 and remote sql server 2005?
>
> Thanks
>
> Regards
>
>
>


.



Relevant Pages

  • Re: Access 97 to a more powerfull platform!?
    ... Moving to SQL Server is common when a database "outgrows" ... Design problems are far and away the usual reason why a database ...
    (microsoft.public.access.gettingstarted)
  • Re: Copy database
    ... Best way is either do backup and restore or attach it. ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving ... http://www.support.microsoft.com/?id=168001 User Logon and/or Permission ... for SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Re: best method for switching to a new server
    ... I can get the moving the db thing, no prob, but it's the in between part ... > a Restore ... > for SQL Server ... >> to move the Sql Server 2K database from the old to the new. ...
    (microsoft.public.sqlserver.setup)
  • Re: MOVING SQL 2000 to a different computer, and domain
    ... http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving ... http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore ... for SQL Server ... articles on how to do a SQL move, but I cannot find one specific to my ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant read from database ??
    ... You also may need to worry about some permissions. ... http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ...
    (microsoft.public.sqlserver.connect)