Simple Access 2000 query in VBA doesn't work

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

sql = "SELECT * FROM Devices WHERE OwningDevice=3"
Set rcs = CurrentDb.OpenRecordset(sql)

When I run the above code in Access 2000's VBA I get a "type mismatch" error
on the second line. But the query is correct and runs ok as a regular
Access query.

What am I doing wrong??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Access Query using VBA 1
Access 2000 Query very slow compared to SQL Query Analyzer 5
Combine Duplicates in Query 0
Make Table Dynamic Table Name using INTO 2
Converted from LINUX time ok, but having issues with the between date. 4
Append query in Access to SQL Server 2
Calling Parameterized Query Using SQL Syntax 3
Access 2003 Append query hangs 1

Back
Top