DAO-ADO question

[Sirocco]

I have an mdb front end and back end. Will the same DAO code work if I link
my mdb front end to a SQL Server, or do I have to make my code ADO-compliant
as if I were converting my front end to an access project (i.e., ADP)?

With that in mind, is "Forms!Formname.Form.RecordsetClone.RecordCount <> )"
ADO compliant?

Many thanks in advance.

 

[John Nurick]

Hi Sirocco,

As I understand it, a basic "upsizing" simply leaves you with linked
tables connected to the SQL Server database rather than to the mdb back
end, with little if any code changes required. On the other hand
extensive re-working will be needed to take full advantage of SQL
Server. Tony Toews has links to upsizing information at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

 

[George Nicholson]

AFAIK, the recordset returned by Form.RecordsetClone is a DAO recordset, not
ADO.

 

[Sirocco]

You say "the recordset returned by Form.RecordsetClone is a DAO recordset,
not ADO". Then will this function not work with a SQL backend if my front
end is an MDB file?

 

[david epsom dot com dot au]

This function will not work in a number of circumstances:

"Forms!Formname.Form.RecordsetClone.RecordCount <> )"

For a start, a recordcount on an ODBC connection will
typically return "-1".

Also, the recordsetclone object is invalidated by stuff
like changing the RowSource -- precisely when you want a
record count.

(david)

 

[Sirocco]

You state "the recordset returned by Form.RecordsetClone is a DAO recordset,
not ADO." In order to return an ADO recordset with this method, what
syntax should I use? Any suggestion would be appreciated.

Thanks!

 

[Brendan Reynolds]

As I understand it, the recordset returned by Form.RecordsetClone will
always be a DAO recordset *unless* you specifically assigned an ADO
recordset to the Recordset property of the form. But check out
www.trigeminal.com - that's where I read about this, so you might as well go
straight to the source rather then relying on my memory.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Sirocco]

Could you give me a more specific link please?

Thanks.

 

[Brendan Reynolds]

http://www.trigeminal.com/usenet/usenet022.asp?1033

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.