Weird Access 97 MDE behavior

[Angel Mazo]

Dear all,

I have a very weird Access 97 MDE behavior that I don't know how to
explain and, of course, how to solve:

.. I have a site with 14 PC's, mixed Windows XP Pro and Windows 98,
running an application developed on my laptop with Windows XP Pro.
Front Ends are located on user's PC's and Back End is located on a
"Windows 2000 Server".
Eveything is working properly.

.. Recently, 3 folders have been created "on server" to give remote
access using Terminal Server. I have copied the Access 97 MDE over
those folders and, here it is the problem, application does not run.
When application starts I can see the first Microsoft Access splash
Access screen and immediately, application ends.
I have put the typical "Hello World" message as first code line and
application ends without displaying the message, that is, no one code
line is executed.

But curiously, if I run the same application, but the MDB instead of
MDE, application works.

Even more, if I execute the MDE application directly on the server the
result is the same, does not work, so anything related to Terminal
Server.

This morning I tried a workaround and I "created a new MDE file
directly on the server" and, application worked.

So the difference is between MDE created on my laptop and MDE created
on the server; I have checked references, etc, and everything is
right.

Maybe the Office 97 installation over the server is different that one
installed on a local PC, due operating system?

I don't understand, I would appreciate your help.

Regards.

Angel.

[Brendan Reynolds]

Re: Weird Access 97 MDE behavior

I'm guessing here, because I don't have access to a Windows 2000 Server PC
with Office 97 installed, but my guess, for whatever that might be worth, is
that some components - the DAO or ADO object libraries, perhaps - might be
installed into different locations by the different operating systems.

The solution you've already found is, in my experience, the simplest and
most reliable - create the MDE using the same version of Windows under which
it will be installed.

--
Brendan Reynolds (MVP)

"Angel Mazo" <angel.mazo@vod afone.es> wrote in message
news:e2a85bbc.0 402050725.649b3 958@posting.goo gle.com...[color=blue]
> Dear all,
>
> I have a very weird Access 97 MDE behavior that I don't know how to
> explain and, of course, how to solve:
>
> . I have a site with 14 PC's, mixed Windows XP Pro and Windows 98,
> running an application developed on my laptop with Windows XP Pro.
> Front Ends are located on user's PC's and Back End is located on a
> "Windows 2000 Server".
> Eveything is working properly.
>
> . Recently, 3 folders have been created "on server" to give remote
> access using Terminal Server. I have copied the Access 97 MDE over
> those folders and, here it is the problem, application does not run.
> When application starts I can see the first Microsoft Access splash
> Access screen and immediately, application ends.
> I have put the typical "Hello World" message as first code line and
> application ends without displaying the message, that is, no one code
> line is executed.
>
> But curiously, if I run the same application, but the MDB instead of
> MDE, application works.
>
> Even more, if I execute the MDE application directly on the server the
> result is the same, does not work, so anything related to Terminal
> Server.
>
> This morning I tried a workaround and I "created a new MDE file
> directly on the server" and, application worked.
>
> So the difference is between MDE created on my laptop and MDE created
> on the server; I have checked references, etc, and everything is
> right.
>
> Maybe the Office 97 installation over the server is different that one
> installed on a local PC, due operating system?
>
> I don't understand, I would appreciate your help.
>
> Regards.
>
> Angel.[/color]

[Angel Mazo]

Re: Weird Access 97 MDE behavior

Brendan,

Thanks for your quick answer. The worst (to me) is that makes me to
visit the customer site to deploy new versions for Terminal Server
Users because for site Users I do that remotely thru FTP from my home.

Next time I visit customer site I will try to investigate a little bit
more about your suggestion related to different folders, etc.

Regards.

Angel.

"Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message news:<OTKw9GA7D HA.3804@tk2msft ngp13.phx.gbl>. ..[color=blue]
> I'm guessing here, because I don't have access to a Windows 2000 Server PC
> with Office 97 installed, but my guess, for whatever that might be worth, is
> that some components - the DAO or ADO object libraries, perhaps - might be
> installed into different locations by the different operating systems.
>
> The solution you've already found is, in my experience, the simplest and
> most reliable - create the MDE using the same version of Windows under which
> it will be installed.
>
> --
> Brendan Reynolds (MVP)
>
> "Angel Mazo" <angel.mazo@vod afone.es> wrote in message
> news:e2a85bbc.0 402050725.649b3 958@posting.goo gle.com...[color=green]
> > Dear all,
> >
> > I have a very weird Access 97 MDE behavior that I don't know how to
> > explain and, of course, how to solve:
> >
> > . I have a site with 14 PC's, mixed Windows XP Pro and Windows 98,
> > running an application developed on my laptop with Windows XP Pro.
> > Front Ends are located on user's PC's and Back End is located on a
> > "Windows 2000 Server".
> > Eveything is working properly.
> >
> > . Recently, 3 folders have been created "on server" to give remote
> > access using Terminal Server. I have copied the Access 97 MDE over
> > those folders and, here it is the problem, application does not run.
> > When application starts I can see the first Microsoft Access splash
> > Access screen and immediately, application ends.
> > I have put the typical "Hello World" message as first code line and
> > application ends without displaying the message, that is, no one code
> > line is executed.
> >
> > But curiously, if I run the same application, but the MDB instead of
> > MDE, application works.
> >
> > Even more, if I execute the MDE application directly on the server the
> > result is the same, does not work, so anything related to Terminal
> > Server.
> >
> > This morning I tried a workaround and I "created a new MDE file
> > directly on the server" and, application worked.
> >
> > So the difference is between MDE created on my laptop and MDE created
> > on the server; I have checked references, etc, and everything is
> > right.
> >
> > Maybe the Office 97 installation over the server is different that one
> > installed on a local PC, due operating system?
> >
> > I don't understand, I would appreciate your help.
> >
> > Regards.
> >
> > Angel.[/color][/color]

[Brendan Reynolds]

Re: Weird Access 97 MDE behavior

There are at least two alternatives to having to go on-site to do these
things. One is remote control software, such as PC Anywhere (Symantec).

Provided the client has retail Access on the target PC, you can develop the
MDB on your PC, then log on to the target PC using PC Anywhere or one of the
alternatives, transfer the MDB, then create the MDE on the target PC.

Another alternative is something like Virtual PC (formerly Connectix, now
Microsoft, included in the MSDN subscription). This creates a 'virtual' PC
running in a window on your desktop, on which you can install an operating
system and applications, and to the operating system and applications it
appears to be a physical PC, completely independent of the host PC on which
it is running. You can set up one of these virtual PCs with the same
environment as the target PC. It does use up a fair chunk of hard disk space
for each virtual PC, and a fair chunk of RAM while the virtual PC is
running, but in my experience the time it saves me more than compensates for
that.

--
Brendan Reynolds (MVP)

"Angel Mazo" <angel.mazo@vod afone.es> wrote in message
news:e2a85bbc.0 402051420.4e303 07a@posting.goo gle.com...[color=blue]
> Brendan,
>
> Thanks for your quick answer. The worst (to me) is that makes me to
> visit the customer site to deploy new versions for Terminal Server
> Users because for site Users I do that remotely thru FTP from my home.
>
> Next time I visit customer site I will try to investigate a little bit
> more about your suggestion related to different folders, etc.
>
> Regards.
>
> Angel.
>
> "Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message[/color]
news:<OTKw9GA7D HA.3804@tk2msft ngp13.phx.gbl>. ..[color=blue][color=green]
> > I'm guessing here, because I don't have access to a Windows 2000 Server[/color][/color]
PC[color=blue][color=green]
> > with Office 97 installed, but my guess, for whatever that might be[/color][/color]
worth, is[color=blue][color=green]
> > that some components - the DAO or ADO object libraries, perhaps - might[/color][/color]
be[color=blue][color=green]
> > installed into different locations by the different operating systems.
> >
> > The solution you've already found is, in my experience, the simplest and
> > most reliable - create the MDE using the same version of Windows under[/color][/color]
which[color=blue][color=green]
> > it will be installed.
> >
> > --
> > Brendan Reynolds (MVP)
> >
> > "Angel Mazo" <angel.mazo@vod afone.es> wrote in message
> > news:e2a85bbc.0 402050725.649b3 958@posting.goo gle.com...[color=darkred]
> > > Dear all,
> > >
> > > I have a very weird Access 97 MDE behavior that I don't know how to
> > > explain and, of course, how to solve:
> > >
> > > . I have a site with 14 PC's, mixed Windows XP Pro and Windows 98,
> > > running an application developed on my laptop with Windows XP Pro.
> > > Front Ends are located on user's PC's and Back End is located on a
> > > "Windows 2000 Server".
> > > Eveything is working properly.
> > >
> > > . Recently, 3 folders have been created "on server" to give remote
> > > access using Terminal Server. I have copied the Access 97 MDE over
> > > those folders and, here it is the problem, application does not run.
> > > When application starts I can see the first Microsoft Access splash
> > > Access screen and immediately, application ends.
> > > I have put the typical "Hello World" message as first code line and
> > > application ends without displaying the message, that is, no one code
> > > line is executed.
> > >
> > > But curiously, if I run the same application, but the MDB instead of
> > > MDE, application works.
> > >
> > > Even more, if I execute the MDE application directly on the server the
> > > result is the same, does not work, so anything related to Terminal
> > > Server.
> > >
> > > This morning I tried a workaround and I "created a new MDE file
> > > directly on the server" and, application worked.
> > >
> > > So the difference is between MDE created on my laptop and MDE created
> > > on the server; I have checked references, etc, and everything is
> > > right.
> > >
> > > Maybe the Office 97 installation over the server is different that one
> > > installed on a local PC, due operating system?
> > >
> > > I don't understand, I would appreciate your help.
> > >
> > > Regards.
> > >
> > > Angel.[/color][/color][/color]

[Angel Mazo]

Re: Weird Access 97 MDE behavior

Brendan,

Again thanks for your advice, they are very helpful.

So according to that and as I already have a Terminal Server
connection to server, could I use it to open MDB file and to create
the MDE ? (after transmitting the MDB file, of course) ... I think
that would be the solution.

Thanks again.

Angel.

"Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message news:<OVGnarJ7D HA.2480@TK2MSFT NGP12.phx.gbl>. ..[color=blue]
> There are at least two alternatives to having to go on-site to do these
> things. One is remote control software, such as PC Anywhere (Symantec).
>
> Provided the client has retail Access on the target PC, you can develop the
> MDB on your PC, then log on to the target PC using PC Anywhere or one of the
> alternatives, transfer the MDB, then create the MDE on the target PC.
>
> Another alternative is something like Virtual PC (formerly Connectix, now
> Microsoft, included in the MSDN subscription). This creates a 'virtual' PC
> running in a window on your desktop, on which you can install an operating
> system and applications, and to the operating system and applications it
> appears to be a physical PC, completely independent of the host PC on which
> it is running. You can set up one of these virtual PCs with the same
> environment as the target PC. It does use up a fair chunk of hard disk space
> for each virtual PC, and a fair chunk of RAM while the virtual PC is
> running, but in my experience the time it saves me more than compensates for
> that.
>
> --
> Brendan Reynolds (MVP)
>
> "Angel Mazo" <angel.mazo@vod afone.es> wrote in message
> news:e2a85bbc.0 402051420.4e303 07a@posting.goo gle.com...[color=green]
> > Brendan,
> >
> > Thanks for your quick answer. The worst (to me) is that makes me to
> > visit the customer site to deploy new versions for Terminal Server
> > Users because for site Users I do that remotely thru FTP from my home.
> >
> > Next time I visit customer site I will try to investigate a little bit
> > more about your suggestion related to different folders, etc.
> >
> > Regards.
> >
> > Angel.
> >
> > "Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message[/color]
> news:<OTKw9GA7D HA.3804@tk2msft ngp13.phx.gbl>. ..[color=green][color=darkred]
> > > I'm guessing here, because I don't have access to a Windows 2000 Server[/color][/color]
> PC[color=green][color=darkred]
> > > with Office 97 installed, but my guess, for whatever that might be[/color][/color]
> worth, is[color=green][color=darkred]
> > > that some components - the DAO or ADO object libraries, perhaps - might[/color][/color]
> be[color=green][color=darkred]
> > > installed into different locations by the different operating systems.
> > >
> > > The solution you've already found is, in my experience, the simplest and
> > > most reliable - create the MDE using the same version of Windows under[/color][/color]
> which[color=green][color=darkred]
> > > it will be installed.
> > >
> > > --
> > > Brendan Reynolds (MVP)
> > >
> > > "Angel Mazo" <angel.mazo@vod afone.es> wrote in message
> > > news:e2a85bbc.0 402050725.649b3 958@posting.goo gle.com...
> > > > Dear all,
> > > >
> > > > I have a very weird Access 97 MDE behavior that I don't know how to
> > > > explain and, of course, how to solve:
> > > >
> > > > . I have a site with 14 PC's, mixed Windows XP Pro and Windows 98,
> > > > running an application developed on my laptop with Windows XP Pro.
> > > > Front Ends are located on user's PC's and Back End is located on a
> > > > "Windows 2000 Server".
> > > > Eveything is working properly.
> > > >
> > > > . Recently, 3 folders have been created "on server" to give remote
> > > > access using Terminal Server. I have copied the Access 97 MDE over
> > > > those folders and, here it is the problem, application does not run.
> > > > When application starts I can see the first Microsoft Access splash
> > > > Access screen and immediately, application ends.
> > > > I have put the typical "Hello World" message as first code line and
> > > > application ends without displaying the message, that is, no one code
> > > > line is executed.
> > > >
> > > > But curiously, if I run the same application, but the MDB instead of
> > > > MDE, application works.
> > > >
> > > > Even more, if I execute the MDE application directly on the server the
> > > > result is the same, does not work, so anything related to Terminal
> > > > Server.
> > > >
> > > > This morning I tried a workaround and I "created a new MDE file
> > > > directly on the server" and, application worked.
> > > >
> > > > So the difference is between MDE created on my laptop and MDE created
> > > > on the server; I have checked references, etc, and everything is
> > > > right.
> > > >
> > > > Maybe the Office 97 installation over the server is different that one
> > > > installed on a local PC, due operating system?
> > > >
> > > > I don't understand, I would appreciate your help.
> > > >
> > > > Regards.
> > > >
> > > > Angel.[/color][/color][/color]

[Brendan Reynolds]

Re: Weird Access 97 MDE behavior

I would expect so - can't hurt to try, anyway.
--
Brendan Reynolds (MVP)

"Angel Mazo" <angel.mazo@vod afone.es> wrote in message
news:e2a85bbc.0 402061115.42dae 369@posting.goo gle.com...[color=blue]
> Brendan,
>
> Again thanks for your advice, they are very helpful.
>
> So according to that and as I already have a Terminal Server
> connection to server, could I use it to open MDB file and to create
> the MDE ? (after transmitting the MDB file, of course) ... I think
> that would be the solution.
>
> Thanks again.
>
> Angel.
>
> "Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message[/color]
news:<OVGnarJ7D HA.2480@TK2MSFT NGP12.phx.gbl>. ..[color=blue][color=green]
> > There are at least two alternatives to having to go on-site to do these
> > things. One is remote control software, such as PC Anywhere (Symantec).
> >
> > Provided the client has retail Access on the target PC, you can develop[/color][/color]
the[color=blue][color=green]
> > MDB on your PC, then log on to the target PC using PC Anywhere or one of[/color][/color]
the[color=blue][color=green]
> > alternatives, transfer the MDB, then create the MDE on the target PC.
> >
> > Another alternative is something like Virtual PC (formerly Connectix,[/color][/color]
now[color=blue][color=green]
> > Microsoft, included in the MSDN subscription). This creates a 'virtual'[/color][/color]
PC[color=blue][color=green]
> > running in a window on your desktop, on which you can install an[/color][/color]
operating[color=blue][color=green]
> > system and applications, and to the operating system and applications it
> > appears to be a physical PC, completely independent of the host PC on[/color][/color]
which[color=blue][color=green]
> > it is running. You can set up one of these virtual PCs with the same
> > environment as the target PC. It does use up a fair chunk of hard disk[/color][/color]
space[color=blue][color=green]
> > for each virtual PC, and a fair chunk of RAM while the virtual PC is
> > running, but in my experience the time it saves me more than compensates[/color][/color]
for[color=blue][color=green]
> > that.
> >
> > --
> > Brendan Reynolds (MVP)
> >
> > "Angel Mazo" <angel.mazo@vod afone.es> wrote in message
> > news:e2a85bbc.0 402051420.4e303 07a@posting.goo gle.com...[color=darkred]
> > > Brendan,
> > >
> > > Thanks for your quick answer. The worst (to me) is that makes me to
> > > visit the customer site to deploy new versions for Terminal Server
> > > Users because for site Users I do that remotely thru FTP from my home.
> > >
> > > Next time I visit customer site I will try to investigate a little bit
> > > more about your suggestion related to different folders, etc.
> > >
> > > Regards.
> > >
> > > Angel.
> > >
> > > "Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message[/color]
> > news:<OTKw9GA7D HA.3804@tk2msft ngp13.phx.gbl>. ..[color=darkred]
> > > > I'm guessing here, because I don't have access to a Windows 2000[/color][/color][/color]
Server[color=blue][color=green]
> > PC[color=darkred]
> > > > with Office 97 installed, but my guess, for whatever that might be[/color]
> > worth, is[color=darkred]
> > > > that some components - the DAO or ADO object libraries, perhaps -[/color][/color][/color]
might[color=blue][color=green]
> > be[color=darkred]
> > > > installed into different locations by the different operating[/color][/color][/color]
systems.[color=blue][color=green][color=darkred]
> > > >
> > > > The solution you've already found is, in my experience, the simplest[/color][/color][/color]
and[color=blue][color=green][color=darkred]
> > > > most reliable - create the MDE using the same version of Windows[/color][/color][/color]
under[color=blue][color=green]
> > which[color=darkred]
> > > > it will be installed.
> > > >
> > > > --
> > > > Brendan Reynolds (MVP)
> > > >
> > > > "Angel Mazo" <angel.mazo@vod afone.es> wrote in message
> > > > news:e2a85bbc.0 402050725.649b3 958@posting.goo gle.com...
> > > > > Dear all,
> > > > >
> > > > > I have a very weird Access 97 MDE behavior that I don't know how[/color][/color][/color]
to[color=blue][color=green][color=darkred]
> > > > > explain and, of course, how to solve:
> > > > >
> > > > > . I have a site with 14 PC's, mixed Windows XP Pro and Windows 98,
> > > > > running an application developed on my laptop with Windows XP Pro.
> > > > > Front Ends are located on user's PC's and Back End is located on a
> > > > > "Windows 2000 Server".
> > > > > Eveything is working properly.
> > > > >
> > > > > . Recently, 3 folders have been created "on server" to give remote
> > > > > access using Terminal Server. I have copied the Access 97 MDE over
> > > > > those folders and, here it is the problem, application does not[/color][/color][/color]
run.[color=blue][color=green][color=darkred]
> > > > > When application starts I can see the first Microsoft Access[/color][/color][/color]
splash[color=blue][color=green][color=darkred]
> > > > > Access screen and immediately, application ends.
> > > > > I have put the typical "Hello World" message as first code line[/color][/color][/color]
and[color=blue][color=green][color=darkred]
> > > > > application ends without displaying the message, that is, no one[/color][/color][/color]
code[color=blue][color=green][color=darkred]
> > > > > line is executed.
> > > > >
> > > > > But curiously, if I run the same application, but the MDB instead[/color][/color][/color]
of[color=blue][color=green][color=darkred]
> > > > > MDE, application works.
> > > > >
> > > > > Even more, if I execute the MDE application directly on the server[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > > > result is the same, does not work, so anything related to Terminal
> > > > > Server.
> > > > >
> > > > > This morning I tried a workaround and I "created a new MDE file
> > > > > directly on the server" and, application worked.
> > > > >
> > > > > So the difference is between MDE created on my laptop and MDE[/color][/color][/color]
created[color=blue][color=green][color=darkred]
> > > > > on the server; I have checked references, etc, and everything is
> > > > > right.
> > > > >
> > > > > Maybe the Office 97 installation over the server is different that[/color][/color][/color]
one[color=blue][color=green][color=darkred]
> > > > > installed on a local PC, due operating system?
> > > > >
> > > > > I don't understand, I would appreciate your help.
> > > > >
> > > > > Regards.
> > > > >
> > > > > Angel.[/color][/color][/color]

[Angel Mazo]

Re: Weird Access 97 MDE behavior

Brendan,

I just tried it and it worked.

Thank you so much.

Angel.


"Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message news:<O1qKF1v7D HA.696@tk2msftn gp13.phx.gbl>.. .[color=blue]
> I would expect so - can't hurt to try, anyway.
> --
> Brendan Reynolds (MVP)[/color]