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.
6  1713 
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" <an********@vodafone.es> wrote in message
news:e2**************************@posting.google.c om... 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,
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:<OT**************@tk2msftngp13.phx.gbl>... 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" <an********@vodafone.es> wrote in message
news:e2**************************@posting.google.c om... 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.
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" <an********@vodafone.es> wrote in message
news:e2**************************@posting.google.c om... 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:<OT**************@tk2msftngp13.phx.gbl>... 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" <an********@vodafone.es> wrote in message
news:e2**************************@posting.google.c om... 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,
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:<OV**************@TK2MSFTNGP12.phx.gbl>... 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" <an********@vodafone.es> wrote in message
news:e2**************************@posting.google.c om... 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:<OT**************@tk2msftngp13.phx.gbl>... 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" <an********@vodafone.es> wrote in message
news:e2**************************@posting.google.c om...
> 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.
I would expect so - can't hurt to try, anyway.
--
Brendan Reynolds (MVP)
"Angel Mazo" <an********@vodafone.es> wrote in message
news:e2**************************@posting.google.c om... 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:<OV**************@TK2MSFTNGP12.phx.gbl>... 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" <an********@vodafone.es> wrote in message
news:e2**************************@posting.google.c om... 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:<OT**************@tk2msftngp13.phx.gbl>... > 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" <an********@vodafone.es> wrote in message
> news:e2**************************@posting.google.c om...
> > 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,
I just tried it and it worked.
Thank you so much.
Angel.
"Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message news:<O1*************@tk2msftngp13.phx.gbl>... I would expect so - can't hurt to try, anyway.
--
Brendan Reynolds (MVP) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: redneck_kiwi |
last post by:
Hi all:
I have a really weird problem. I am developing a customer catalog
system for my company and as such have delved into sessions for
authentication and access levels. So far, I have managed...
|
by: Les Paul |
last post by:
I'm trying to design an HTML page that can edit itself. In essence, it's
just like a Wiki page, but my own very simple version. It's a page full
of plain old HTML content, and then at the bottom,...
|
by: Benjamin Z. Gregorian |
last post by:
Hi there
I have a problem with a database I wrote. On my access 2002 it is running
without probs but on the comp of my collegue A2003 there is this weird
behaviour.
The form is a continuous...
|
by: Tom Dauria |
last post by:
I inherited a weird application. Part of it is in VB6 and part in
Access 2000. All of the reports and some of the forms are in Access
2000. The database is opened by the VB application.
...
|
by: Holger (David) Wagner |
last post by:
Hi all,
we're currently developing an application in the .NET environment that
needs to access a DLL implemented in Fortran. There is one procedure
with about 17 parameters, most of them arrays....
|
by: Jonathan Yong |
last post by:
I observe a very weird behavior when dynamically create web control
and bind events to it.
Create a C# ASP.NET application,
Put a PlaceHolder and Textbox onto the Web form,
and try with the 4...
|
by: Shaul Feldman |
last post by:
Hello,
I have a couple of things:
1)
a page contains a button that has some JS code attached to it
programmatically.
Also the page loads a web user control with LoadControl method. In UC I...
|
by: comp.lang.php |
last post by:
// NEW 11/27/2006: FINALLY, IF YOU ADDED OR DELETED OR DID ANY KIND OF
FORM ACTION SUCCESSFULLY, DON'T RE-DISPLAY THE NEW EXPENSE ITEMS VIA
$_POST
if ($_POST && (!is_array($leaseObj->errorArray)...
|
by: prn |
last post by:
Hi folks,
I've come across a couple of the oddest behaviors that I have ever seen and wondered if anyone else has had anything similar, and if so, whether you have any suggestions for me. I warn...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
