General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Open method of recorset gives error
I use open method of recorset to open a table like
rsAccess1.Open "SELECT * FROM 5_CREDENTIAL", connAccess1, _
adOpenKeyset, adLockOptimistic, adCmdText
If the table doesnot exist, it gives me run time error. Is there any way I can check whether the table exists before I open it in the recordset?
Thanks
Bharat
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only