Case when problem after migrating MSAccess to MSSQLServer

[bitse]

I got error Nested Case When reached level t0 10. I got this problem while migrating my MSAccess Queries to MSSql server with SSMa migration Tool and another problem i have, Empty record is disabled in one of my form.Please help me.

 

[MSAccessRookie]

I got error Nested Case When reached level t0 10. I got this problem while migrating my MSAccess Queries to MSSql server with SSMa migration Tool and another problem i have, Empty record is disabled in one of my form.Please help me.

I am sorry to say that this I found this request to be a bit confusing as it is currently worded. Most of the people who post in this particular Forum have worked with SSMA, so if you are able to provide a little more details, we might be able to assist. Showing the original SQL Code and the resulting SQL Code could be a great start.

 

[bitse]

Ok thanks for reply...

I attached two Images. Image 1 represent the Access file as frontend and backend.
Image :1

Image:2

Image2 represent Migrated Access file with access as front end and DB MSSQL server as backend using SSMA. That form having 3 fields. Mode_Milestone(Combobox), Percentage,NO of days.

In Image 1 file shows the combo box and Allow to enter data but Image 2 is not allowing to insert and all the fields are disabled.Another problem is one of subform is showing the same error.

If u need any info i ll provide in next post.

 

[MSAccessRookie]

I assumed that your problem was related to an IIf() statement based on your original post, and therefore was expecting to see SQL Code in Access Format, and SQL Code in SQL Server Format. The images provided do not show the information that i was looking for. Are you able to provide the SQL Code?

 

[pbaldy]

Does the SQL Server table have a key field defined? If not, it will be read only in Access and you will not see the row to add a new record.

 

[bitse]

I assumed that your problem was related to an IIf() statement based on your orignal post, and therefore was expecting to see SQL Code in Access Format, and SQL Code in SQL Server Format. The images provided do not show the information that i was looking for. Are you able to provide the SQL Code?

I attached the code in word doc. Check it and tell

 

[bitse]

Does the SQL Server table have a key field defined? If not, it will be read only in Access and you will not see the row to add a new record.

Ya it having the key field.

 

[SOS]

I suggest getting rid of the CASE statements and create a USER DEFINED FUNCTION to return the value you want.

 

[bitse]

Subform is not loading in SQL migrated Access

Access Form:

SQL Migrated Form:

This Sub form is not displaying the new record to insert or update record. The buttons are disabled in SQL form. Pls help me

 

[pbaldy]

Start here:

http://allenbrowne.com/casu-20.html

Can you add or modify records directly in SQL Server?

 

[bitse]

Start here:

http://allenbrowne.com/casu-20.html

Can you add or modify records directly in SQL Server?

Ya if we open the subform directly it shows the records. If we call it from main form its not working.

 

[pbaldy]

Is there any code running? Are the Master/Child links set appropriately?

 

[bitse]

Sorry my friend . When i opened the form seperately i cant add new record.

 

[MSAccessRookie]

Sorry my friend . When i opened the form seperately i cant add new record.

Once in a while when I was using use the SQL Server Migration Assistant (SSMA) I discovered that the target SQL Server columns were not exactly the same as original Access ones. I then had to use the SQL Server Management Studio (SSMS) to verify that they were all the same, including Field sizes and data types, adjusting any that were not.