What is a ADP file?

  • Thread starter Thread starter Guest
  • Start date Start date
Access Data Project

Short definition is that it is a different "flavor" of Access that ties
directly to a SQL Server back-end, has no local storage for tables and uses
the SQL Server engine instead of Jet. Many use ADP as a way to manipulate
database level objects in SQL Server.

I'm sure others will add to or "Wiki" the above, but those are the basics

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
 
Access Database Project, to be used with database server such as MS SQL
Server. There is an ADP community site here.
 
'needs no local tables' since it can use temp tables in SQL Server

-Aaron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CurrentDb() in adp file 3
Call stored procedure in SSMS from Access 2016 doesn't work. 0
How can I tell if an Access ADP is open 3
Future of ADP - new article 12
What's the steps to modify a .adp connect string & convert DAO to 2
Redirecting connection of ADP *before* startup 3
.mdb or .adp which is best to use with SQL 2K 10
Secure an adp file? 3

Back
Top