Rst Query -doing it wrong?

[kit_sune]

Help!

I need to refer to a query called "UserID Query" to create a record set!!!

I thought this would work but it seems to be locking out my database...

SQL = "[UserID Query]"
Set rst = DBEngine(0)(0).OpenRecordset(SQL)

It's possible that this is good and the error is elsewhere but at this time this is where I'm looking.

Thanks for all your help!!!

~Kit

 

[bob fitz]

Perhaps something like:

Set rst = Currentdb.OpenRecordset(SQL)

 

[MarkK]

Even if there is a space, don't use square brackets in the query name.

SQL = "UserID Query"
Set rst = CurrentDb.OpenRecordset(SQL)

 

[Cronk]

There's nothing wrong with
Set rst = DBEngine(0)(0).OpenRecordset(SQL)

except I think you might find SQL is a reserved word in Access.

Try using strSQL as your variable.

 

[MarkK]

Here's what Microsoft says about CurrentDb vs DBEngine(0)(0), and it's fine to use "SQL" in VBA.