Ms access install location

Ultimately, I want to use VBA to create a email message that has a link to a database in it. I will format the link to open Access and then the database on a server. When the email is sent out to users, they can click on the link and the link will open Access and automatically search and display the correct record.

I have discovered that you can include command line arguments with Access if you open it from a command line. So my VBA code will use this command line argument data to search for and display the correct record when the database opens.

But one problem that I may run into is that some users may not have Office11, they may have a different version of Access or it may be stored somewhere other than where my link specifies.

Does any of this make sense? David Why not use CreateObject to create an instance of Access? You could then use subsequent code to do what you want, without having to use command line arguments. Norie, I am not sure I understand you suggestion. Let me try to explain again what I need to do.

I have a database that users will enter a tool number when they want to remove a tool from production. When this happens, there are other people that need to know so that they can plan extra inventory to cover the amount of time that the tool is going to be out of production.

My plan was to have the database create a email message that would contain a link. The email would then get sent out to several people that need to know about tools that are taken out of production. When these people get their emails, I wanted them to be able to click on the link which would open Access and automatically find the record in the database that matches the email.

Do you have any ideas on how I could accomplish the above in the simplest way? The way I am currently accomplishing the above is I attach a text file to the email. The text file contains the record information. When the database opens, it looks for this text file. If the text file is found, it opens it up and gets the record information and then does a search on the database to find the record and display it.

I want to avoid requiring the user to save this text file containing the record information. Thanks again for listening and your suggestions, David. Joined Apr 30, Messages 1, Something like this from within Access would give you the full path to the database.

I don't think this answers your question, but it might get you closer. Sub testpath Debug. Print Application. Name End Sub. That is very close but I think I need the path to Access rather than the path to the current database. I will keep looking. There must be some easy way to accomplish my task. You've mentioned VBA, Access, email, text files, batch files etc. Yes No. Sorry this didn't help. Thanks for your feedback. If you already have Access full edition installed, then thankfully installing the runtime edition does NOTHING at all since you would not want to over write your full edition.

Keep in mind that the location of the runtime install and even the dll';s and location of msaccess. So AFTER you install access either full or runtime , then you can copy your mdb, accdb files to that computer and click on them.

This approach works for the runtime and thus no different connection exists between runtime and full edition — when you double click on a file then the Access application is launched based on the file extension. There is no special "connection" between your applications and the runtime or full edition of Access. So after you install the runtime, then you just copy the mdb or accdb files to that computer and double click on them to launch them. As noted the path names and locations of runtime vs full are the same.

In fact quite sure even the binary msaccess. So I don't know where actual code goes that allows the "design" mode that the full version gives. Just keep in mind that the runtime is much the same as the full edition. This includes the whopping megs in size, and often the need to re-boot the computer during a install. This thread is locked. Improve this question. If a non standard path is used,you can e. Add a comment. Active Oldest Votes. It depends on 2 things, 32 or 64 bit and the version number.

Improve this answer. I suppose it is possible to override the standard install locations listed in the answer Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.