Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to modify an .adp file

Posted on 2012-12-31
2
Medium Priority
?
773 Views
Last Modified: 2012-12-31
Hi all.

We have an Access project file (.adp) that is on the server (myServer) and all our end users have an .ade file where they work with the forms etc.

It's my understanding that I have to make changes to the .adp file and then release it to the end users. But the server where the original .adp file resides does not have Microsoft Access installed on it. So how can I edit that file? Can I do it from an end user workstation and just go to the path on the server? If so, do I hold the shift key and double click the file?

When I simply double click the file it opens the username and password screen. I don't know if they have an admin username and password for the database.

Any help would be great!

Thanks.
0
Comment
Question by:printmedia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 38732913
It doesn't matter where the adp file is located as long as you can see it from your local machine (that has a full copy of Access). Just start Access and then open the file.

The login screen you are describing is not part of Access - it must be something the developer has built.  You can try holding the Shift key down and see if that gets you in.

But no-one here will be able to help you by-passing any security settings.
0
 

Author Comment

by:printmedia
ID: 38733022
The workstation I'm on doesn't have Access installed on it yet I can see the the shortcut icon of Microsoft Access. That's probably because it is an .ade file.

What I will do is have them install Microsoft Access on that workstation and then try to hold the Shift Key. I'll post another question if I still have issues.

Thank you.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

618 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