[AccessD] Anyone used dbSync?

[Dan Waters]

Hi Fred,

It looks to me like you may not need the synchronization product.  I went to
the site - what it does is keep two databases (or two backends) in synch
with each other on a periodic basis (for $149).  But it sounds like what you
need to do is this:

1) From your Access BE, upsize the Access tables to SQL Server tables. (do a
search for 'upsize Access tables to SQL Server tables')
2) In the Access FE, remove the FE table links to the Access database with
the data tables.
3) In the Access FE, create ODBC links to the same tables in the SQL Server
database.  (do a search for 'link Access to SQL Server)
4) Try out your application - it should run exactly like it did with the
Access tables.

You won't need to do this again so a synchronization product won't be of any
help.  Once it's all working, you won't need your Access BE file anymore.

HTH,
Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Fred Hooper
Sent: Monday, November 02, 2015 9:47 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Anyone used dbSync?

I found this product: https://dbconvert.com/access/mssql/, which claims to
keep an Access database in sync with a SQL Server database. Has anyone used
it?

I'm converting the record-keeping program for my brother-in-law's software
program from an Access back end to a SQL Server back end. If the program
works as described, it would reduce the risk of the switchover.

I'm not interested in their convert product as I've written something I'm
happy with and that gives me control at the points where I need it.
As I have plenty of time right now, I've tried every permutation of how to
link the front and back end that I've read or thought of; this was necessary
as the first test of simple links to SQL Server brought a critical form from
10 seconds to 3 minutes -- so I did a lot of rethinking. If anyone is
interested I'd be happy to provide more detail.

Thanks,
Fred

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com