Importing Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scott04 - 17 Mar 2008 19:21 GMT

When i am trying to import data from another database i am running into a
problem. It is allowing me to import all tables and queries however it will
not allow me to import forms or reports. I can see the forms and reports
however it is greyed out and will not let me hit select all. Any work around
so i can import the data?

Reply to this Message

Douglas J. Steele - 17 Mar 2008 19:32 GMT

Is it possible that the database from which you're trying to import is an
MDE? Forms and reports don't actually exist in any usable form in MDEs.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> When i am trying to import data from another database i am running into a
> problem. It is allowing me to import all tables and queries however it
[quoted text clipped - 3 lines]
> around
> so i can import the data?

Reply to this Message

scott04 - 17 Mar 2008 19:46 GMT

Doug,

It looks like thats what it is....the guy that used to manage this db has
left the company and i thought that i would simily try and re-create his db.
Any thoughts?

> Is it possible that the database from which you're trying to import is an
> MDE? Forms and reports don't actually exist in any usable form in MDEs.
[quoted text clipped - 6 lines]
> > around
> > so i can import the data?

Reply to this Message

Douglas J. Steele - 17 Mar 2008 22:42 GMT

Sorry, but you're pretty much out of luck.

I've heard of a couple of firms out there that are able to convert MDEs back
to MDBs (see, for instance,
http://accessblog.net/2006/04/live-test-reverse-engineering-mde-to.html or
http://www.everythingaccess.com/mdeconversion.htm), but there's nothing mere
mortals can do.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Doug,
>
[quoted text clipped - 15 lines]
>> > around
>> > so i can import the data?

Reply to this Message