Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open method of recorset gives error
Message
From
30/01/2003 11:40:27
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Open method of recorset gives error
Miscellaneous
Thread ID:
00747212
Message ID:
00747212
Views:
52
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
Map
View

Click here to load this message in the networking platform