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