468,145 Members | 1,377 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,145 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 4769
sashi
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.
Thanks
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
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.