swapna.raj,
This is how I ended up doing the DAO recordsets. It works just fine.
'set these up on first entering the database
Public gdbTables As DAO.Database
Set gdbTables = DBEngine(0)(0) 'used for SQL Server linked tables
'set this up the first time the user downloads the...