Access to SQL upsizing problem?

Question

When I upsize my Access database in the upsizing wizard, none of my existing forms and reports carry over. Anyone know how to resolve this?

Answer 1

The upsizing wizard will move your data to the SQL Server. Your reports are handled by Access; they really have nothing to do with SQL Server. You would either have to maintain the Access database for the reports, or build your reports with another tool like Crystal Reports, Active Reports, etc.



I would suggest utilizing a third party application like Navicat for your SQL needs. (This is for MySQL but supports converting Access Datases to a SQL dump file). If you're looking for something free you could try Aqua Data Studio.

Answer 2

Rebulid the database with the forms and reports existed.Try upsizing again.If not working,run the old Access program and import the the database you worked on.Export it to SQL version format.

Answer 3

you are able to set the sector to integer in sq. and then motor vehicle increment the variety so it is going to create an incremental type assigned to the sector. that's often completed in MySQL pretty fairly.