470,590 Members | 1,812 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,590 developers. It's quick & easy.

Ms Access front end MS SQL backend

I have an access database which uses 2 forms to enter data in 1 table. The other form is a subform and is continuos whereas the other (Primary) is not continuos.

It works fine in an access database but when I migrate the database to MS sql server database, the access front end especially the continuos subform does not work fine. I have the repeating records for a particular Id in the primary form that is why I use the continuous subform.

Please help me. Help urgently needed.
Jul 8 '06 #1
2 4844
1,754 Expert 1GB
Hi there,

"repeating records" you say?? well.. check the primary key.. good luck my fren.. :)
Jul 8 '06 #2
All I am saying is this: I have 2 forms. the other form is a subform. The information that these 2 forms enters go to a single table.
e.g. Form1 will enter the Item ID and the sub form will enter all the people who have ordered that item.
Hence the subform will have many rows coressponding to one ID in the main form. That is, we can loop in the subform. It works fine in the access tables, but when I migrate it to Ms SQL database, it does not. Hence I have the subform as a continuos form but when I migrate the back end to SQL server database, it looks like the continuos property does not work in the subform. The problem here is a subform being continuos not datasheet or single form.

I hope I have made my point clear.
Jul 9 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

63 posts views Thread by Jerome | last post: by
3 posts views Thread by Jim Devenish | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.