database types in Access 2000,2002,2003

D

Dariusz Tomoñ

Hello

Some time ago I used following construction in my modules to open
recordsets:

Dim mazars As Database
Dim R0 As Recordset
Set mazars = CurrentDb()

s1 = "SELECT * FROM emp"
Set R0 = mazars.OpenRecordset(s1)

.... but it was in Access 97. The question is: what is equivalent to database
type etc. in newer version of Access?
When I try to launch the programs I get the message: "Compile error -
user-defined type not defined"

best regards

D.T.
 

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

newbie needs examples of creating a recordset and inserting datausing it in Access 2007? 6
Problem with function on Access 97 4
Help in connecting to a Recordset in Access 2002 2
VBA error - please help with explanation 3
Database variant type 2
migrating code from Access 2000 to 2003 and 2007 5
Help - no variable type Database 6
Help. User defined type not defined. "Dim myDB as Database" 2

Top