By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,687 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Opening MDE Application using File Associations.

P: n/a
I am looking to open my MDE Application using the DB files associated
with the application I have created. My application is using a non
descript three digit extension that is related to the application
name. I would like to be able to lauch my app and open the file that
is being clicked. Any ideas?
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the application file is an .MDE then it's extension should be .mde.
That extension should be associated w/ Access.exe. You open the
application that uses the db files not the other way around 'cuz many
applications may be able to use the same db files.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDWzDoechKqOuFEgEQItlgCgh31uwLG7WUHFDlLROHT6u1 mEGzsAoICt
o7nYf9Z3wGya6xCCZV+yOKli
=0HBe
-----END PGP SIGNATURE-----
David Allison wrote:
I am looking to open my MDE Application using the DB files associated
with the application I have created. My application is using a non
descript three digit extension that is related to the application
name. I would like to be able to lauch my app and open the file that
is being clicked. Any ideas?


Nov 12 '05 #2

P: n/a
MGFoster <me@privacy.com> wrote in message news:<jq***************@newsread2.news.pas.earthli nk.net>...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the application file is an .MDE then it's extension should be .mde.
That extension should be associated w/ Access.exe. You open the
application that uses the db files not the other way around 'cuz many
applications may be able to use the same db files.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)


Thanks for the advice but I don't know if I communicated clearly
enough. What I am looking for is the ability to use alternate
extensions for my backend .mdb files so that the application .mde file
will be launched when the alternate extension (.mdb) file is double
clicked. I hope that makes more sense. Still looking for ideas.
Nov 12 '05 #3

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When the application is split into 2 files (front-end & back-end) you
can't open the front-end by opening the back-end. This would imply
there is something in the back-end (code) that will open the front
end. You could make an AutoExec macro in the back-end that opens the
front-end. This would be kinda crazy. What if there are more apps
that use the data - which app to open?

I believe Access needs to see an extension of .mde or .mdb on the back
end (data) file before it will use it as a JET (Access) data source.

You can go into the File Types & create an extension that will open
Access:

1. Open Windows Explorer
2. Under Tools menu select Folder Options
3. Click tab File Types
4. Click the New button
5. Follow the directions on creating the new extension & the
associated file.

I really don't recommend this. But, hey, its your computer. Of
course you realize that this change will only affect your computer.
If you want this file association to be available by other
users/computers you'll have to change their PC's File Type
associations.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDZggIechKqOuFEgEQIWxACeIVcU/0AEIqzJ7XWmZEbHHZMdmXMAoJZu
r+3jl7qW93iQOXYw1DRQceKc
=Wnq3
-----END PGP SIGNATURE-----
David Allison wrote:
Thanks for the advice but I don't know if I communicated clearly
enough. What I am looking for is the ability to use alternate
extensions for my backend .mdb files so that the application .mde file
will be launched when the alternate extension (.mdb) file is double
clicked. I hope that makes more sense. Still looking for ideas.

Nov 12 '05 #4

P: n/a
MGFoster <me@privacy.com> wrote:
I believe Access needs to see an extension of .mde or .mdb on the back
end (data) file before it will use it as a JET (Access) data source.


There have been a number of postings from folks who hide the fact that they are using
Access MDB/MDEs by putting a non MDB/MDE extension on the files. And that it works
just fine. This includes linking from the FE to the BE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.