Not sure if this has been discussed already, forum searches yielded no results:
I have an mdb that I have ported to SQL server.
I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO.
While it seems that most operations can be replicated using ADO, I am having trouble with subforms, especially those where the users currently enter more records i.e. inputting order lines which correspond to a single order record.
(They enter the order line records into a subform setup as a datasheet).
So far, I have been able to create a form accesing the "Orders" table, and a subform accessing the "OrderLines" table, however, the orderl lines appear as read-only and no input is allowed (the usual 'empty' record is not present).
Can anyone advise me on how to proceed?
I would like to retain the simple method of entering order lines into the datasheet as the users are familiar with it, but if there's a better way or only certain methods are allowed, I'd like to know.
Thank you.
I have an mdb that I have ported to SQL server.
I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO.
While it seems that most operations can be replicated using ADO, I am having trouble with subforms, especially those where the users currently enter more records i.e. inputting order lines which correspond to a single order record.
(They enter the order line records into a subform setup as a datasheet).
So far, I have been able to create a form accesing the "Orders" table, and a subform accessing the "OrderLines" table, however, the orderl lines appear as read-only and no input is allowed (the usual 'empty' record is not present).
Can anyone advise me on how to proceed?
I would like to retain the simple method of entering order lines into the datasheet as the users are familiar with it, but if there's a better way or only certain methods are allowed, I'd like to know.
Thank you.
