<div>
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.<br />
<br />
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.<br />
<br />
Thank you.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
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.<br />
<br />
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?<br />
<br />
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.<br />
<br />
Any help would be great!<br />
<br />
Thanks.
</div>
</div>


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.

How to modify an .adp file

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.