Solved

What protocol does the ADP use?

Posted on 2004-04-16
5
377 Views
Last Modified: 2011-09-20
I've got an Access 2000 ADP file that connects up to SQL Server 2000.  I have been asked by a client "What protocol does your software use?"  I know that the network uses TCP/IP, but that's not exactly what they're asking.  The client is asking if it's ODBC, OLE DB, or what?  I'm not sure exactly what the difference is but I gather that TCP/IP, Named Pipes, etc. are the means of actually passing the data, but ODBC, OLE DB, etc. are the means of communicating with the database.

Is that right?  If so, what do I tell the client?  This is 500 points due to the urgency of the question.
0
Comment
Question by:rstone
5 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 10842494
0
 

Author Comment

by:rstone
ID: 10842861
OK, but that article doesn't talk about MS Access or ADO.
0
 
LVL 5

Accepted Solution

by:
Krys_Wilson earned 500 total points
ID: 10842942
Rstone,

According to the book:  Access 2000 Developers Handbook.  Volume 2: Enterprise edition

ADP's use this method to access server data.

ACCESS -> SQL Server OLE DB Provider -> SQL Server Software -> SQL Server Database

Access 2000 uses a direct OLE DB connection to SQL server for data storage.

P.S  I would highly recommend both Volume 1 and Volume 2 of the above if you use a lot of ADP projects.  It has proved invaluable in creating and maintaining my ADP's.

HTH

Chris
0
 

Author Comment

by:rstone
ID: 10842988
I do have that book, but it's been quite some time since I've read it.  I didn't think to look there.
0
 
LVL 26

Expert Comment

by:Alan Warren
ID: 10842994
Hi rstone,

this may shed a little light.

From DAO to ADO
http://www.databasejournal.com/features/msaccess/article.php/1490571

Alan
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AddNew causes duplicate key in VBA Access 12 32
update query 4 25
set focus to tabbed sub form 10 39
Run an action on recently added records to a table 13 59
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question