Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default Recordset Type?

Status
Not open for further replies.
Bill98

Bill98

Programmer
Jun 8, 2004
1
US
If you create a bound form in an Access 2000 .mdb file, it's recordset is a DAO recordset. Is this the case in Access 2003 as well?
 
Sort by date Sort by votes
'97 has a DAO default recordset. 2000's default is ADO. To use the DAO is rather simple and the thing to do if you have any '97 users. Just link the design Tools/Reference to one of the DAO's 3.51 or 3.6 and then define the recordset variable as a DAO.Recordset

Rollie
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
732
JanaLNelson
JanaLNelson
CreativeStrat
  • Locked
  • Question
Form Recordset Failing as SubForm Only
Replies
5
Views
100
CreativeStrat
CreativeStrat
TheresAlwaysAWay
  • Locked
  • Question
Put default text into text box without it being stored in the table
Replies
4
Views
83
sxschech
sxschech
StevenFromSouth
  • Locked
  • Question
Using .Fields() method in Recordsets for calculations. 1
Replies
1
Views
99
Andrzejek
Andrzejek
DeRochier
  • Locked
  • Question
Subform triggers error: "This expression is typed incorrectly..."
Replies
3
Views
164
DeRochier
DeRochier

Part and Inventory Search

Sponsor

Back
Top