I use this line
DoCmd.SelectObj ect acTable, "tblAdmin", True
when I want to display database window. Often-
times, working on a remote mde via a TCP/IP
connection, its convenient to have a look at
at the database window, open tables, make
changes.
Can someone tell me why some runtime installations
will open the database window and others won't?
I do all my installs are pretty much the same way.
I haven't a clue that would account for the
behavioural differences.
7  1404 
MLH wrote:
I use this line
DoCmd.SelectObj ect acTable, "tblAdmin", True
when I want to display database window. Often-
times, working on a remote mde via a TCP/IP
connection, its convenient to have a look at
at the database window, open tables, make
changes.
Can someone tell me why some runtime installations
will open the database window and others won't?
I do all my installs are pretty much the same way.
I haven't a clue that would account for the
behavioural differences.
The ones that work are not runtime installations. Displaying the db window
is not supported in the runtime. You can build a form of your own that
gives similar information though and that would display.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
MLH wrote:
Can someone tell me why some runtime installations
will open the database window and others won't?
The Access runtime version doesn't allow the database window to show, so if
you're seeing it, this means the computer has another version of Access
installed, and your app is running in *that* version, not the runtime version
you expected. If this comes as a surprise to you, then that's bad because it
means one of two things:
1) The user installed another version of Access *after* your runtime was
installed, which can lead to compatibility problems, especially if an older
version of Access was installed after the newer version, or
2) Your runtime installation didn't check for other versions of Access
before installing, which can also lead to compatibility problems.
Compatibility problems lead to higher tech support custs, which means it
either comes out of your pocket or the customer's.
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200611/1
10:4
That's probably what I'll do.
I've done a runtime distribution rollout at 2 sites
that allow the DB window to display. They do
have Access 97 installed on that same system.
I checked the properties of the desktop icon
launching the application and it reads:
"c:\program files\AppDir\Ap pName.mde"
The installation process DID create the following
directory: c:\program files\AppDir\Of fice and
MSACCESS.EXE is listed in there. But its also
located at c:\program files\microsoft office\ and
I can't say for certain which is being used.
When I did my runtime install, I might have later
opened their copy of A97, attached to my runtime
supplied system database and opened the primary
MDE included in the RT distribution to do some
routine maintenance.
Just out-a-curiousity, are there special concerns
I should be aware of when performing a run-time
installation of an A97 created app onto a machine
that currently has Access 97 installed? I don't think
customers would appreciate it very much if I some-
how replaced their
C:\Program Files\Microsoft Office\Office\m sAccess.exe
file.
<snip>
This installation is a number of years old now. Dunno for sure which
is the case, but I suspact A97 was added later. Will keep fingers
crossed. So far, so good. Apparently the MDE has NO problem running
in the quasi-runtime bastardized environment. App functions normally
with the exception of that database window thing. That was handy
and may turn out to be again. So I'm not gonna worry about that. Only
admin-level users can launch the button and open the DB window.
Anything else I should be on the lookout for?
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxx
>The Access runtime version doesn't allow the database window to show, so if
you're seeing it, this means the computer has another version of Access
installed, and your app is running in *that* version, not the runtime version
you expected. If this comes as a surprise to you, then that's bad because it
means one of two things:
1) The user installed another version of Access *after* your runtime was
installed, which can lead to compatibility problems, especially if an older
version of Access was installed after the newer version, or
2) Your runtime installation didn't check for other versions of Access
before installing, which can also lead to compatibility problems.
Compatibilit y problems lead to higher tech support custs, which means it
either comes out of your pocket or the customer's.
MLH wrote:
Apparently the MDE has NO problem running
in the quasi-runtime bastardized environment.
If it's an MDE file and they're opening it with their retail version, it
means they're opening it with Access 97, not a later version which can cause
compatibility issues. But I can't think of a logical reason to have *both*
the retail and the runtime version of Access 97 installed on the same
computer.
Anything else I should be on the lookout for?
I've never installed both the runtime and the retail edition of the same
version of Access on a computer, so I don't know. Most of the compatibility
issues expected with runtime vs retail come from different Office versions,
like Office 97 vs Office 2000. At the least your customers have wasted disk
space, but beyond that I can't think of what else might cause you a headache.
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200611/1
"MLH" <CR**@NorthStat e.netwrote in message
news:bk******** *************** *********@4ax.c om...
10:4
That's probably what I'll do.
I've done a runtime distribution rollout at 2 sites
that allow the DB window to display. They do
have Access 97 installed on that same system.
I checked the properties of the desktop icon
launching the application and it reads:
"c:\program files\AppDir\Ap pName.mde"
The installation process DID create the following
directory: c:\program files\AppDir\Of fice and
MSACCESS.EXE is listed in there. But its also
located at c:\program files\microsoft office\ and
I can't say for certain which is being used.
When I did my runtime install, I might have later
opened their copy of A97, attached to my runtime
supplied system database and opened the primary
MDE included in the RT distribution to do some
routine maintenance.
Just out-a-curiousity, are there special concerns
I should be aware of when performing a run-time
installation of an A97 created app onto a machine
that currently has Access 97 installed? I don't think
customers would appreciate it very much if I some-
how replaced their
C:\Program Files\Microsoft Office\Office\m sAccess.exe
file.
Unless you are using a custom installer this shouldn't happen. The runtime
installer for Access 97 will not install the runtime on a PC that already has
Access 97 on it. The inverse is also true. If the retail version is installed
after the runtime then it should "see" the runtime install and use the same
folder.
If you used a custom installer and/or Sagekey scripts then perhaps none of the
above applies.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Thx Rick. That's useful info. I still use A97. I like it and its the
only one I know how to use. Been so long since I looked at
that guy's machine. Can't recall much about it.
By "will not install the runtime on a PC", you mean will not installl
a redundant copy of the msAccess.exe file on a PC, right? The same exe
is used for both runtime and retail versions of A97. The runtime APP
itself WILL install, of course. (just to eliminate any confusion on
the valid point you made).
>
Unless you are using a custom installer this shouldn't happen. The runtime
installer for Access 97 will not install the runtime on a PC that already has
Access 97 on it. The inverse is also true. If the retail version is installed
after the runtime then it should "see" the runtime install and use the same
folder.
If you used a custom installer and/or Sagekey scripts then perhaps none of the
above applies.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: DL |
last post by:
Hello,
I am teaching a java course. When some of my students tried
to run a very simple java program that displays a JFrame, it
appeared that even though the program was compiled OK
on all machines in the lab (running windows 2000), a couple of
the machines did not display the Frame at all.
There wasn't any error message printed in the console window
where we started the program. They just didn't display the frame.
|
by: dixie |
last post by:
If I have a form open and the database window is open, is there a command I
can use from an on click event that will close the database window for me,
but still leave the application open?
dixie
|
by: Ken Post |
last post by:
Using Access 2003. Latest patches, on a dozen or so Win XP sp2
machines.
Each machine has its own front copy of the same front end. SQL Server
2000 backend.
Many of the forms have fields on them with controlsource like this:
= & " " &
This works fine on all of the machines except for 2 of them. On these
|
by: Michael B. |
last post by:
I was just thinking about this, specifically wondering if there's any
features that the C specification currently lacks, and which may be
included in some future standardization.
Of course, I speak only of features in the spirit of C; something like
object-orientation, though a nice feature, does not belong in C.
Something like being able to #define a #define would be very handy,
though, e.g:
#define DECLARE_FOO(bar) #define...
|
by: lli |
last post by:
Hi Guys,
I have designed a web application. In its one window I put a form. User
can click submit button of this form to run a pathon script to get data
from database. Then User get a new window which display the result. Now
I want to put the form and display data on the same window. How I can
do this?
If I use frameset, I need to put form in a html file and put data in a
table in scond html file. How I can do this?
| | |
by: Ted |
last post by:
I managed to get it installed OK, along side MS Visual Studio 2005
(with which I received it). During the install, I made sure I
installed everything.
I have developed a number of applications using MySQL v 5 and
PostgreSQL, but I have not worked with MS SQL. Playing with it after
installing it, and running through several tutorials, I generally like
what I see, but there are a few issues (so far - I am sure others will
crop up as...
|
by: mike |
last post by:
I help manage a large web site, one that has over
600 html pages... It's a reference site for ham radio
folks and as an example, one page indexes over
1.8 gb of on-line PDF documents.
The site is structured as an upside-down tree, and
(if I remember correctly) never more than 4 levels.
The site basically grew (like the creeping black blob) ...
all the pages were created in Notepad over the last
|
by: Artie |
last post by:
Hi,
Our team have a web project which includes some C# ActiveX DLLs.
On some developers' PCs, the code which calls methods in the ActiveX
dll is succesful - no exceptions. On other PCs, the ActiveX control
doesn't even seem to get loaded. (On the failing machines, if we try
and debug down to where the ActiveX DLL method is invoked, both Visual
Studio
and IE hang.)
|
by: wreed06 |
last post by:
Hello,
I have 2 problems. In my webpage, I have a dropdown list with a button that takes the user to a popup window specific to the option. I am using Firefox 2.0.0.13. I have successfully validated my HTML and CSS code.
1. When I clear cache and refresh my webpage, it takes 3 tries before the popup window displays - I click on the button once, a white window the size of my webpage displays. I close it and click on the button again (for...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
