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

Link to objects in an mdb with a non-"mdb" extension

P: n/a
Hello --

I am using Enterprise Architect, a UML modeling tool, which is built on a
pre-Access 2000 mdb. The database describing the model has the extension
".eap".

I want to build some queries, reports, etc., on this model and want to store
them in a separate mdb.

Is there a way to link to objects in an Access database that has a non-"mdb"
extension?

Thanks for any help.

L Mehl

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 10/16/2003
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Assuming there are tables that are not secured from other access, as they
might be, then make a copy of the .eap file, change the extension to .mdb,
link the tables of interest, then use the Linked Table Manager to relink to
the same tables in the original .eap. Discard the renamed .mdb.

The problem is that, although the tables can be in a file of any extension
if it is a valid Access database, the File | Get External Data dialog limits
the file extensions from which you can do the original Link.

Larry Linson
Microsoft Access MVP

"L Mehl" <me*********@cyvest.com> wrote in message
news:dL************@newsread4.news.pas.earthlink.n et...
Hello --

I am using Enterprise Architect, a UML modeling tool, which is built on a
pre-Access 2000 mdb. The database describing the model has the extension
".eap".

I want to build some queries, reports, etc., on this model and want to store them in a separate mdb.

Is there a way to link to objects in an Access database that has a non-"mdb" extension?

Thanks for any help.

L Mehl

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 10/16/2003

Nov 12 '05 #2

P: n/a
Thank you, Larry

Larry

"Larry Linson" <bo*****@localhost.not> wrote in message
news:V4*****************@nwrddc03.gnilink.net...
Assuming there are tables that are not secured from other access, as they
might be, then make a copy of the .eap file, change the extension to .mdb,
link the tables of interest, then use the Linked Table Manager to relink to the same tables in the original .eap. Discard the renamed .mdb.

The problem is that, although the tables can be in a file of any extension
if it is a valid Access database, the File | Get External Data dialog limits the file extensions from which you can do the original Link.

Larry Linson
Microsoft Access MVP

"L Mehl" <me*********@cyvest.com> wrote in message
news:dL************@newsread4.news.pas.earthlink.n et...
Hello --

I am using Enterprise Architect, a UML modeling tool, which is built on a pre-Access 2000 mdb. The database describing the model has the extension ".eap".

I want to build some queries, reports, etc., on this model and want to

store
them in a separate mdb.

Is there a way to link to objects in an Access database that has a

non-"mdb"
extension?

Thanks for any help.

L Mehl

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 10/16/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.556 / Virus Database: 348 - Release Date: 12/26/2003
Nov 12 '05 #3

P: n/a
"L Mehl" wrote
Thank you, Larry


Another, even easier, approach was suggested to me by Eric Fleischmann,
Microsoft:

Use the File | Get External Data | Link, choose Access Tables. When the file
selection dialog opens up with only "Access type" files, simply put *.* in
the File Name, enter, and it will show all the files in that folder.

So simple, and it's just the way Windows works.

Larry Linson
Microsoft Access MVP


Nov 12 '05 #4

P: n/a
Larry,

Thanks for this, too.

Larry

"Larry Linson" <bo*****@localhost.not> wrote in message
news:Wh*****************@nwrddc01.gnilink.net...
"L Mehl" wrote
> Thank you, Larry
Another, even easier, approach was suggested to me by Eric Fleischmann,
Microsoft:

Use the File | Get External Data | Link, choose Access Tables. When the

file selection dialog opens up with only "Access type" files, simply put *.* in
the File Name, enter, and it will show all the files in that folder.

So simple, and it's just the way Windows works.

Larry Linson
Microsoft Access MVP

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.556 / Virus Database: 348 - Release Date: 12/27/2003
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.