Dear all,
I have a form within the forms tab of my .mdb file with combo boxes
filled with data from my master tables. The user needs to select his
choice from these combo boxes and press the Go button. the GO_click
event is supposed to open a recordset based on the parameters provided
by the user.
My question: how do i set the activeconnectio n property of the
recordset? creating a connection object with full path of db is
returning an error saying that the database is locked for use.
I have seen that is case of dao, currentdb object is used to set the
database. what is the procedure in ADO.
Please help!!
Thanks in advance,
Yash Poddar
I have a form within the forms tab of my .mdb file with combo boxes
filled with data from my master tables. The user needs to select his
choice from these combo boxes and press the Go button. the GO_click
event is supposed to open a recordset based on the parameters provided
by the user.
My question: how do i set the activeconnectio n property of the
recordset? creating a connection object with full path of db is
returning an error saying that the database is locked for use.
I have seen that is case of dao, currentdb object is used to set the
database. what is the procedure in ADO.
Please help!!
Thanks in advance,
Yash Poddar
Comment