Payer 10 - Export of a single client from the SQL database to an MDB file

Long time ago, I did something like this and succeeded, and this time I can not deal with this problem. Is Płatnik 10, which operates on the basis of SQL 2012 Express. I need to export data from one client to an MDB file (Access). I progress w / g THIS guide. I assume a new SQL database, I export the data of the selected client (payer) to it, and on the basis of MASTER performs the query:

I switch to this database and try to convert it to MDB, which unfortunately ends with various errors.

Or I have a mistake:

... or when I move the SQL database to another server:

If I try to give full permissions for Everyone to the directory in which I want to create an MDB file, I get a similar error, only with the tip "Disk or network error". If I install Payer on the same computer as SQL Server, the tip is "Unspecified error".

I tried on Windows 7 x86 and x64 and respectively on the 32 and 64 bit version of SQL Server 2012.

maybe this:

http://sqlish.com/msg-7302-level-16-state-1-l...-ole-db-provider-%E2%80%9Cmicrosoft-ace-oledb -12-0% E2% 80% 9D-for-linked-server-% E2 9Cnull% 80%%% 80% E2 9D /

or this:
https://www.codeproject.com/Questions/747570/...t-create-an-instance-of-OLE-DB-provider-MSDAS

possibly
https://www.codykonior.com/2014/05/02/msdainitialize-minimum-required-permissions/

pogoogluj because the results a lot, and as you can see and different solutions are the problem.

It seems to me that by default in Microsoft SQL Server there is no database creation function enabled from program levels - https://msdn.microsoft.com/en-us/library/ms187569(v=sql.110).aspx

tzok wrote:

Long time ago, I did something like this and succeeded

I think Microsoft SQL Server 2005 worked OK.

work: Googlował and a lot, but so far it did not bring results.

Dra98: The problem is with the creation of the Access database, not SQL. Even better - an empty database is created, an error occurs when you try to import data into it.

I do not know what the credit goes to the end (Windows XP or SQL Server 2005) but I installed the payer on the Windows XP virtual machine with SQL Server 2005, to which I moved the database from SQL Server 2008 through the SQL script, and thus I was able to migrate the SQL database to Access from the Payer level.