ADP + MSSQL (ADO) vs. ACCDB + linked MSSQL (DAO).

[Misha]

We have 4 computers in a small network and we use ACCDB. In order to avoid
errors that can appear with unstable connection and improved back upping I’m
going to migrate from ACCDB to MSSQL Express. The question is following:
which technology to use? ADP + MSSQL (ADO) or ACCDB + linked MSSQL (DAO).

 

[Banana]

We have 4 computers in a small network and we use ACCDB. In order to avoid
errors that can appear with unstable connection and improved back upping I’m
going to migrate from ACCDB to MSSQL Express. The question is following:
which technology to use? ADP + MSSQL (ADO) or ACCDB + linked MSSQL (DAO).

Personally, I'd opt for ACCDB + linked tables.

Remember that even in a ACCDB, you still can use ADO where ADO actually
are useful (e.g. where you may want to bind a form to a stored
procedure's resultset for example) while having the simplicity of DAO &
linked table for the rest of development where one-one correspondence works.

Furthermore, MSSQL implements ODBC natively so there'll be very little
difference in performance.

ADP has not been updated in any significant manner for long time and
Microsoft has recommended using ACCDB/linked tables, though it continues
to be supported and can be used.

For more information & links:

Beginning SQL Server Development-
http://www.utteraccess.com/forums/s...=1732935&page=0&view=expanded&sb=5&o=&fpart=1

Beginner's Guide to ODBC-
http://www.utteraccess.com/forums/s...=1843709&page=0&view=expanded&sb=5&o=&fpart=1


(watch out for the line wraps that may break the link)

HTH.

 

[Tony Toews [MVP]]

We have 4 computers in a small network and we use ACCDB. In order to avoid
errors that can appear with unstable connection and improved back upping I’m
going to migrate from ACCDB to MSSQL Express. The question is following:
which technology to use? ADP + MSSQL (ADO) or ACCDB + linked MSSQL (DAO).

Agreed with what Banana posted.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[David W. Fenton]

Agreed with what Banana posted.

I don't see what Banana posted, but I'd certainly avoid ADP as it's
a dead-end format.