Converting to ADP with SQL Server (1 Viewer)

[mattP]

I have attached a basic logon function, that I originally got from these forums.
I am trying to use this type of logon example for my new DB, that I am creating in ADP with a SQL backend.

I am experiencing problems trying to get the recordset function to work correctly, in particular in the initial logon form "frmLogon", when you enter your password, click "logon" and it compares the records etc..
The current code is as follows:
Dim db As DAO.Database
Dim rst As DAO.Recordset

Set db = CurrentDb()
Set rst = db.OpenRecordset("tblUserDetails", dbOpenDynaset)

However when I try to run this I get the following error on my ADP DB:

Run-time error '91':
Object variable or with block variable not set.

Would appreciate any help that can be offered.

MattP

 

[RuralGuy]

Maybe you already know this but are you aware that it is not necessary to convert to ADP to have SQL Server as your BackEnd?

 

[mattP]

RuralGuy,

yes I know I can use the upsizing wizard to convert to a SQL backend, however I was advised that creating the Access part using ADP would be "Cleaner".

MattP

 

[RuralGuy]

Here's a link to a response by MVP Pat Hartman. She seems to have some pretty strong opinions on the subject. http://www.access-programmers.co.uk/forums/showthread.php?t=96596