Solved: Access front end SQL backend recordsets

[Movian]

When using DAO with the additional parameter you specified i get the error

Runtime error 91

Object Variable or with block variable not set

[vba]Dim myrs As DAO.Recordset
Set myrs = CurrentDb().OpenRecordset("Settings", dbOpenDynaset)[/vba]
I will look into using stored procedures, however this is a LARGE DB (90 mb without only default table information.)

This is going to be a long process, however im sure it will be worth it in the end. Also i have one other question,

I have the new adp file on my machine connected to a DB. How would i go about setting it up so that i can deliver it to a client so that they can connect it to a different SQL express DB ?


~Ok having some issues with a stored procedure conversion.
[VBA]
SELECT tblLookupValues.Value, tblLookupValues.Order
FROM tblLookupValues
WHERE (((tblLookupValues.Form1)=ActiveControlParentFormName()) AND ((tblLookupValues.Control)=ActiveControlName()))
ORDER BY tblLookupValues.Order;[/VBA]

its complaining that it doesn't know the function activecontrolparentformname()

Which of course the server will not as thats an internet access function. How would i get around this.

I use this to setup user definable dropdown lists. for the whole system based on form name and control name.

As im not too comfortable with SQL yet am having some minor issues (il get through them). Any help in the mean time is appreciated.