Hi there,
I'm new to SQL Server and I've upsized an Access 2003 client/server
application and am testing if the current code still works.
Previously all data retrieval and saving was done like this:
1 strSQL = "SELECT * FROM tbl_Info WHERE InfoID = " & lngID
2 Set dbs = currentDB
3 Set qry = dbs.openquery("",strSQL)
4 do something with the result
I've noticed that line 3 doesn't work any longer.
Could someone please point me in the right direction as to what needs to
be
changed and how...
Thank you very much in advance.
Kind regards
Michael
