When converting Access to SQL, a synchronization error appears

After converting an Access database to SQL the following synchronization error appears:

This is often the result of a data type that is not available for SQL databases due to size limitations. To fix this error, please make sure that "Long Text" data types are changed to "Short Text" within the Access file:

Note: This will limit the entries for this data field to 255 characters, which is much shorter than that of Long Text. Make sure that all of the data affected by this change does not make changes to the database that would be detrimental before changing this data type. 

• Related Articles

• Setting up MS SQL Library in HyDraw CAD 2022 gives Login failed error

  While trying to Login MS SQL Library in HyDraw CAD 2022 gives Login failed error. The error is coming possibly because of MDTools Library selected as MS SQL in HyDraw Options, and the database is missing in SQL server. Solution: Go to HyDraw Options ...

• How to create new user logins for a SQL Database

  For SQL Server Management Studio 2018 follow the below steps: 1.      Go to Security > Logins, right click and select New Login. 2.      Login New dialog pops up. Enter the Login Name, select SQL server authentication, Provide Password. Click Ok. See ...

• How to assign the correct SQL database permissions?

  To assign adequate SQL database permissions within SQL Server Management Studio, follow the below steps: 1. Select User mapping and select the Database Name and assign Database roles as “db_datareader” and “db_datawriter” (public is by default ...

• When logging into the SQL server management studio, can I log in with windows authentication?

  Yes, you can log in with either the Windows authentication or the SQL server authentication.  

• What DB Roles should I have to use SQL with HyDraw CAD and how do I change these roles?

  Within the SQL Database, users should have the dbcreator role assigned to their login credentials in order to read and write from the database. To change a user's role within the SQL database do the following steps: 1.     Open SQL Server Management ...