Setting dao database

[macca the hacke]

Hi

This is a really simple question, but one I have never needed before.
I am using a recordset to obtain data from a table.
In the past I have only ever looked at current database (ie set db = currentdb())
I now need to look at another database, but am coming up with an error which I can't figure out (Compile error - type mismatch). I have set a public const (BackEnd) of the name of the other database (ie "drive\folder\database.mdb"), and have then set db to be BackEnd

What am I doing wrong - it is bound to be something so simple!

Thanks

 

[Bodisathva]

you must also use the OpenDatabase command:

Set db = OpenDatabase(BackEnd)

 

[macca the hacke]

Thanks Bodisathva