Troubleshooting

While working with MSSQL-to-Access wizard you may encounter unexpected behavior or result. Use the following information to solve some common problems and get the result you want. This summary is organized as a list of problem-resolution pairs. Each problem description starts with "P:" and each resolution - with "R:".

P: Error message "User is not allowed to read the source database".

R: MS SQL server user should have enough permissions to execute SELECT queries on the source database.

P: In the resulting database certain fields are empty although in the original they are not.

R: MS Access maximum record size is 2000 bytes (it is a sum of all field sizes except MEMO and OLE fields). If MS SQL record size exceeds this limitation MSSQL-to-Access truncates some trailing fields.

P: Error message "Duplicate field values being used for an unique index were found..."

R: This error means that an attempt has been made to insert a record with a duplicate unique key. When migrating MS SQL data into a new MS Access database, you can either edit source database in order to resolve the conflict manually or restart the program with "Skip converting indexes" checkbox selected. When appending MS SQL data to an existing MS Access database, you should remove the conflicting unique index in the destination MS Access database.

If you came across some other kind of problem while using MSSQL-to-Access, please contact our support department at support@convert-in.com