Change MS Access to SQL Server Compact

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
arusoft
Posts: 45
Joined: Thu 06 Sep 2012 20:19

Change MS Access to SQL Server Compact

Post by arusoft » Thu 12 Sep 2013 15:33

Currently we are using MS Access as portable database. We use TuniConnection to connect to it. Is there easy way to change from MS Access to SQL Server compact database?

Thanks.

AndreyZ

Re: Change MS Access to SQL Server Compact

Post by AndreyZ » Fri 13 Sep 2013 08:30

UniDAC supports SQL Server Compact Edition. To connect to SQL Server Compact database, you can use the following code:

Code: Select all

UniConnection.ProviderName := 'SQL Server';
UniConnection.Database := 'filename'; // .sdf
UniConnection.SpecificOptions.Values['OLEDBProvider'] := 'prCompact';
UniConnection.LoginPrompt := False;
UniConnection.Open;
Migrating from MS Access to SQL Server Compact is out of scope of our support. You can take a look at the following topic: http://social.msdn.microsoft.com/Forums ... rom-access . For more information, please write to the Microsoft support.

Post Reply