Hey,


I am in the process of doing some testing to try and move forward on implementing an upscale of our product from a single accdr (not split). To an access front end and SQL 2008 express back end.

However i have some problems as there is alot of custom code utilizing record sets.

[VBA]Dim myrs as dao.recordset
set myrs = currentdb().openrecords("Select * FROM patient")[/VBA]

What is going to be the best way to do something along these lines now that i have a split SQL back end ?

Any help is always appreciated