Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Open method of recorset gives error
Message
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Open method of recorset gives error
Divers
Thread ID:
00747212
Message ID:
00747212
Vues:
55
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
Répondre
Fil
Voir

Click here to load this message in the networking platform