CODEWITHSUNDEEP
sql-serversql-server-2008ms-accessupsizing
PeteTheFish
PeteTheFish

Reputation: 11

MS Access Upgrade to SQL Server

I have developed an MS Access 2007 database with forms that works fine in access, but when I upsize the back end to SQL Server, I completely lose functionality on a sub-form. Has anyone else run in to this problem? Is there a work around?

Upvotes: 0

Views: 172

Answers (2)

PeteTheFish
PeteTheFish

Reputation: 11

In my case, after making all of the suggested changes, it turns out that the problematic sub-form was corrupt. I rebuilt the project from scratch in Access 2007 and everything worked fine.

Upvotes: 1

James Sinclair
James Sinclair

Reputation: 407

I'm just in the middle of a similar project and have encountered something similar. For me the problem was with datetime fields.

Please check that your forms data/recordset has a datetime field... if it does try changing it to a datetime2 (this seemed to fix it for me in 90% of cases), though you'll probably have to re-import/re-run the ssma app to get the dates imported as datatime2.

@David-w-fenton afaik when you link a table in access it insists on you choosing some field(s) as primary keys

Upvotes: 1

Related Questions