Page 1 of 1
Change MS Access to SQL Server Compact
Posted: Thu 12 Sep 2013 15:33
by arusoft
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.
Re: Change MS Access to SQL Server Compact
Posted: Fri 13 Sep 2013 08:30
by AndreyZ
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.