Synchronize SQL Server with Access MDB?

I suspect this isn't possible, but I recently moved a app to SQL Server
and it contains a Project table. Now I have a new CRM tool that needs
to be mobile, but should also synch with the Project table on SQL Server.

I really like the idea of replicating an Access database for the mobile
users and somehow synching with the SQL server for the Projects. Is
that doable?

--
Danny J. Lesandrini
dlesandrini@xxxxxxxxxxx
http://amazecreations.com/datafast/




.

Relevant Pages

  • Re: Generate SQL Server Mobile Database
    ... central a base de dados SQL Mobile e depois copiar para o equipamento ... SQL Server e irão ser exportados os dados. ...
    (microsoft.public.sqlserver.ce)
  • Re: Alternatives to SQL Server Mobile?
    ... Intellisync offers robust database sync between SQL Mobile, ... > However the app is NOT SQL Server based, ...
    (microsoft.public.pocketpc.developer)
  • Re: SQL Server CE vs. DataTable
    ... The notification you want is part of Windows Mobile 5.0, ... honestly, if you really care about saving your data, I'd recommend writing ... >> If you truly don't care if you lose the data if your app ends or the ... I'm simply getting some data from a SQL Server ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Good Books on SQL Server Mobile
    ... the only book out so far specific to SQL Server Compact Edition is Bill Vaughn's eBook: http://www.hitchhikerguides.net/EBooks/default.aspx Recent books on general mobile development topics also tend to have a chapter or two covering SQL Mobile. ... You can create databases programmatically, and you can also use SQL Server Management Studio to create SSCE databases, test querires, etc. ... I tend to use Management Studio during development while I'm designing the database, but my apps that use SSCE always have the ability to create those databases as needed by the time they're production ready. ... In most cases for me that's a desktop app that creates the database and pushes the data down to the device, but increasingly I'm using SQL Compact for purely desktop apps for local data storage. ...
    (microsoft.public.sqlserver.ce)
  • Re: Application Security based on SQL Security
    ... Ammar S. Mitoori ... IT Head QIMCO Co. ... Mobile: +9745378400 ... Sometimes SQL Server throws not elegant messages to understand by the ...
    (microsoft.public.sqlserver.security)