Microsoft Access Project (adp)

J

Jan

Hi, I am a fairly seasoned MS Access user but would like to learn more about
MS Access Project files. I am trying to find a class, online learning or a
book to address this topic. Most of what I find stops short of adp. Thanks
in advance for your help.
 
K

Klatuu

adps stop short of being useful.
I suggest you stay with mdb.
You can use SQL Server with an mdb application, but you can't use Access
tables with an adp.
 
J

Jan

I would prefer to not have to maintain ODBC connections with an mdb file. My
ultimate goal is a SQL database with a front end that a novice programmer
like me could create. I thought ADP might be the solution. Do you have
another suggestion? A web front end would be ideal but I don't have the time
to learn .NET.
 
K

Klatuu

no, i really don't have another suggestion.
adp programming requires ADO which is more involved than DAO. ODBC
connections are really very easy.
 
A

Armen Stein

no, i really don't have another suggestion.
adp programming requires ADO which is more involved than DAO. ODBC
connections are really very easy.
Click to expand...

ADPs aren't getting as much attention from the Access team, so I don't
recommend building new systems using them.

Dave's right, ODBC connections are easy to manage, especially
DSN-less. There's lots of example code available online. And we
often find reasons to link to local JET/ACE tables for work tables,
merges, imports, etc.

I've written a slideshow on techniques for using Access as a
client-server front-end to SQL Server databases. It's called "Best of
Both Worlds" at www.JStreetTech.com/Downloads. It includes some
thoughts on when to use SQL Server, performance and security
considerations, concurrency approaches, and techniques to help
everything run smoothly. It focuses on using MDB/ACCDB instead of
ADP. We've built many systems using these techniques.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
P

Peter

We have the reverse situation. I inherited an adp project. I want to
convert it to an mdb. Other than buying 3rd party tools to convert like
microtools.us, is there a manual method or does MS have a utility to help me
convert?
 

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

Access Project Automatically Creates Files: adp1.adp, adp2.adp... 4
Shortcuts in OneDrive 0
Automation of scanned file storage based on content 0
Unable to make design changes in .adp connected to SQL server 2008 1
Dynamic Naming of Form Button 3
Modifying an ADP file? 2
Converting Access Project (ADP) from 2000 to 2003 when source controlis involved 5
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0

Top