Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid use of New keyword
Message
From
30/03/2002 17:24:49
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00638804
Message ID:
00639196
Views:
16
For one I would day always explicitly specify your Object name as in:
Private mrsCon as ADODB.Recordset
Set mrsCon = New ADODB.Recordset
Also, make sure that your reference is turned on for ADO and turned off for DAO. If you have both loaded (and I do have a project that uses both DAO and ADO) you have to be explicit with the Object name or the app can get confused. Aadditionally, you should avoid using New for instatiation an use CreateObject instaed as .NET does not support the New instatiation and porting your code later on will be easier if you use CreateObject
Previous
Reply
Map
View

Click here to load this message in the networking platform