question about converting code to ADP

[dp]

Hi,
I am investigating converting my access 2003 MDE to ADP. I have heard that
DAO cannot be used with SQL server. In terms of coding, does this mean
functions where I pass references from a form (Me) cannot be used (isnt this
DAO?) Also can form.recordset.recordsetclone be used?

thx,
David

 

[Van T. Dinh]

MDE file?

You cannot convert MDE file since the text component of the code has been
removed. In fact you can't even modify the design of an MDE file.

 

[dp]

sorry for confusing you. I meant MDB with jet

 

[Van T. Dinh]

I use Access Front-End with SQL Server Back-End without any problems.

If you link the SQL Server Tables to the Access Front-End as ODBC-linked
Tables then you can use the ODBC-linked Tables similar to linked Tables from
Access/JET Back-End. There are plenty of DAO codes, Me, RecordsetClones in
my databases using SQL Server Back-Ends.

If you want to convert your MDB to ADP, check Access Help Topic "About
upsizing a Microsoft Database". If you use A2003, check also the Online
Help.

--
HTH
Van T. Dinh
MVP (Access)

 

[dp]

I thank you. Its good to hear advise from ones that have had first hand
experience.

 

[Van T. Dinh]

You're welcome ... Glad to help ...