Access2003 ADo with Jet and SQL Server

[KenReay]

Hi

I am attempting to write an application (front end) which will be able to use either a Jet (mdb) or SQL Server Backend.

My approach thus far has been to use forms and set the recordset "on the fly", using code like so:

Set Rs = New ADODB.Recordset
'Rs.CursorLocation = adUseClient
Rs.CursorLocation = adUseServer
Rs.Open strSQL, gcn, adOpenDynamic, adLockOptimistic
'
Set Me.Recordset = Rs

has anyone done this and willing to share information/pitfalls?

First problem I have found is that jet only lets you update record if 'Rs.CursorLocation = adUseClient while SQL Server only lets you update if Rs.CursorLocation = adUseServer

Regards

Ken

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Ed2020]

Ken,

I haven't used ADO very much as my Access system are primarily using Jet as the DB engine.

One thing I will say is that, in my experience, ADO is *much* slower when using tables in Jet databases than DAO.

Ed Metcalfe.

Please do not feed the trolls.....