MS Access data conversion - Displaying Full Menus for MDE files on PC without Access installed

Author

Displaying Full Menus for MDE files on PC without Access installed

AlexT

2005-11-22, 8:24 pm

Hi, hopefully this is a basic no-brainer question. I've created an MDE file
which allows full menus to be displayed because users want to be able to
export reports into text files (Export is located in the file menu). One
user informed me that the "export" was not included under his File menu. I
found it strange since other users were able to use the export functionality.
I went to his PC and I noticed that Access was not installed. Since users
with Access installed on their machines could use the export functionality, I
made a simple deduction that full menus are not visible on users whose PC's
don't have Access installed.

Is this correct, and if so, is there any way around it? Thanks in advance.

Alex

Douglas J. Steele

2005-11-22, 8:24 pm

MDE files will not work without Access being installed, so I think your
analysis may be flawed...

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

"AlexT" <u15981@uwe> wrote in message news:57b88aab44104@u
we...
> Hi, hopefully this is a basic no-brainer question. I've created an MDE
> file
> which allows full menus to be displayed because users want to be able to
> export reports into text files (Export is located in the file menu). One
> user informed me that the "export" was not included under his File menu.
> I
> found it strange since other users were able to use the export
> functionality.
> I went to his PC and I noticed that Access was not installed. Since users
> with Access installed on their machines could use the export
> functionality, I
> made a simple deduction that full menus are not visible on users whose
> PC's
> don't have Access installed.
>
> Is this correct, and if so, is there any way around it? Thanks in
> advance.
>
> Alex

Brendan Reynolds

2005-11-23, 8:24 pm

As Doug says, MDE files will not run on a PC that does not have Access
installed. The behaviour you describe is, however, consistent with a PC that
has the runtime version of Access installed. Built-in menus are not
available when using the runtime, you must provide custom menus for
applications designed to work with the runtime version of Access.

--
Brendan Reynolds

"AlexT" <u15981@uwe> wrote in message news:57b88aab44104@u
we...
> Hi, hopefully this is a basic no-brainer question. I've created an MDE
> file
> which allows full menus to be displayed because users want to be able to
> export reports into text files (Export is located in the file menu). One
> user informed me that the "export" was not included under his File menu.
> I
> found it strange since other users were able to use the export
> functionality.
> I went to his PC and I noticed that Access was not installed. Since users
> with Access installed on their machines could use the export
> functionality, I
> made a simple deduction that full menus are not visible on users whose
> PC's
> don't have Access installed.
>
> Is this correct, and if so, is there any way around it? Thanks in
> advance.
>
> Alex

david epsom dot com dot au

2005-11-24, 3:24 am

As Doug says, MDE files will not run on a PC that does not have Access
As Brendon says, you have to use custom menu's when using the runtime.

But you're right, sometimes the Import/Export stuff doesn't
appear on the menu's, and it can depend on what's installed.

Since I don't have a test machine available with only a runtime
install, I can't tell you if what you see is standard or not.

You CAN re-create these menu items by writing VBA functions to
do the exports, but they will just crash if the export filters
aren't correctly installed.

Assuming that you HAVE fully dropped down the file menu, what you
are looking for are IISAM formats, so I guess the next question
would be, can you choose not to install the installable ISAMS
when you install the runtime?

I spent hours fighting this stuff, but that was on Windows 3.11,
so you're on your own now :~)

(david)

"AlexT" <u15981@uwe> wrote in message news:57b88aab44104@u
we...
> Hi, hopefully this is a basic no-brainer question. I've created an MDE
> file
> which allows full menus to be displayed because users want to be able to
> export reports into text files (Export is located in the file menu). One
> user informed me that the "export" was not included under his File menu.
> I
> found it strange since other users were able to use the export
> functionality.
> I went to his PC and I noticed that Access was not installed. Since users
> with Access installed on their machines could use the export
> functionality, I
> made a simple deduction that full menus are not visible on users whose
> PC's
> don't have Access installed.
>
> Is this correct, and if so, is there any way around it? Thanks in
> advance.
>
> Alex

Sponsored Links