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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

type mismatch error on opening a table.

Status
Not open for further replies.
proggy

proggy

Programmer
Apr 21, 2002
46
US
i have this code as
Set rs = db.OpenRecordset("Userinfo", dbOpenTable)
it gives me an error as type mismatch..
can anyone please help me ??
 
Sort by date Sort by votes
Hi,

I'm not sure if this is of any help but I had a similar problem with a recordset and I just added a reference to
"Microsoft DAO 2.5/3.5 compatibility library" in Tools/References... in Module view.

Hope this helps you out Salvatore Grassagliata
 
Upvote 0 Downvote
If this is Access 2000, it is probably due to not qualifying the recordset object.

DAO.Recordset should do it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
268
OzFoxy
OzFoxy
serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
751
Andrzejek
Andrzejek
C
  • Question
Query expression negative to a 0
Replies
6
Views
381
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
879
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top