Hi,
I'm trying to figure out how I can "open" the database within an Access procedure to manipulate the records through code.
I tried doing the following:
dim db as database
dim rs as recordset
set db = opendatabase("mydata.mdb"
set rs = db.openrecordset("myrec",dbopendynaset)
Now, the 'set db' line is giving me an access error which is obvious because I have the database already open. My question then is how do I make reference to it so that I can create a recordset object to manage?
Any help would be greatly appreciated!
thanks
I'm trying to figure out how I can "open" the database within an Access procedure to manipulate the records through code.
I tried doing the following:
dim db as database
dim rs as recordset
set db = opendatabase("mydata.mdb"
set rs = db.openrecordset("myrec",dbopendynaset)
Now, the 'set db' line is giving me an access error which is obvious because I have the database already open. My question then is how do I make reference to it so that I can create a recordset object to manage?
Any help would be greatly appreciated!
thanks