Modifying an ADP file

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

Okay, I have this ADP file (Access 2002) that I need to open and modify. How
can I do that? I've tried digging around the MS Support website docs, but
cannot find anything on maintaining/modifying ADP project applications. Note
that the ADP autoexecutes when I start it, and holding SHIFT down DOES NOT
keep it from doing so. The autoexec disallows the Objects window from being
UNHIDDEN (I don't have the UNHIDE choice on the Window menu.)

Can someone please point me in the right direction?

Thanks!
 
The official newsgroup for ADP is m.p.access.adp.sqlserver.

In your case, try the F11 key to open the database window. If this doesn't
work, try the Alt+F11 to open the VBA window, then open the Immediate Window
(from the View menu) and enter the following command:

CurrentProject.Properties.Add "AllowBypassKey", True

If this doesn't work, then create a blank adp project and import everything
into it.
 
Thanks for this info. I'll give it a try and post back how it worked for me.
I probably want to replace the ADP with a simple MDE, because this
application is only deployed to one or two of our tech support people. I
inherited it, and really have NO IDEA why it was setup as an ADP (no rational
reason). Also, thatnks for the note on the correct newsgroup. Though I saw it
in the list, I didn't post there because it said SQL, and this isn't a SQL
issue.

Thanks again. I'll go try this right now!
 
Killer, that worked!!

Now, one more question (since I did start this thread here):

I need to see the actual linked-table information for my tables. As many
know, with an ADP, they show as local tables even though they're linked to a
SQL database somewhere. I need to know what database these tables are part
of. Any ideas?

Thanks!
 
Which one worked?

ADP doesn't have linked tables but has a connection to a single sql-server
database: File | Connection.
 
F11 worked. ANd THANKS for reminding me of the FILE / CONNECTION methodology.
I completely forgot. (I actually modified this project about two years ago,
but it's been the ONLY ADP project here, and I hadn't touched it since.
Bummer.) My goal is to "downgrade" this to a simple MDB because the userbase
is essentially a single person, and the app isn't deployed on the network
anywhere. So WHY the original author made it an ADP/ADE is quite beyond me...

Thanks again!!

Dennis
 
Back
Top