By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,067 Members | 1,818 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,067 IT Pros & Developers. It's quick & easy.

Runtime Access 97 app - what's the syntax for setting up a shortcut on the desktop?

P: n/a
MLH
I have created an A97 runtime distribution for the first time in my
life this morning. I had precious little time to do it and was unable
to create the distributable installation fileset with the option of it
creating a shortcut for me.

I'm sure it will. But for now, what exactly can I enter into the
shortcut properties to describe the 'location' information that
will have the runtime A97 open the subject mde file using the
desired system database?

In the Access 2.0 days, ADT used a format like this...
C:\EZC_EZC\MSARN200.EXE C:\EZC_EZC\ezclean.mdb /ini g:\ezc.ini

The ini file contain stuff like this...
SystemDB=C:\EZC_EZC\system.mda
UtilityDB=C:\EZC_EZC\utility.mda
AllowCustomControls=1
AllowOLE1LinkFormat=0

[Run-Time Options]
TitleBar=Easy-Clean
StartupScreen=c:\ezc_ezc\mikenteo.bmp
Icon=c:\ezc_ezc\EZC.ico

[Clipboard Formats]
Microsoft Excel (*.xls)=soa200.dll,1,xls
Rich Text Format (*.rtf)=soa200.dll,2,rtf
MS-DOS Text (*.txt)=soa200.dll,3,txt

.....

and so on.
Nov 13 '05 #1
Share this Question
Share on Google+
16 Replies


P: n/a
You have to create a Profile.

In the Access 97 Help file, look up "command-line options". From the 5
topics you get, select the 4th ("Start Microsoft Access with command-line
options". There, select the bottom option ("Specify command-line options for
a shortcut"). Choose the "To display the list of command-line options,
click" button. /profile will be the 6th option down.

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

"MLH" <CR**@NorthState.net> wrote in message
news:0e********************************@4ax.com...
I have created an A97 runtime distribution for the first time in my
life this morning. I had precious little time to do it and was unable
to create the distributable installation fileset with the option of it
creating a shortcut for me.

I'm sure it will. But for now, what exactly can I enter into the
shortcut properties to describe the 'location' information that
will have the runtime A97 open the subject mde file using the
desired system database?

In the Access 2.0 days, ADT used a format like this...
C:\EZC_EZC\MSARN200.EXE C:\EZC_EZC\ezclean.mdb /ini g:\ezc.ini

The ini file contain stuff like this...
SystemDB=C:\EZC_EZC\system.mda
UtilityDB=C:\EZC_EZC\utility.mda
AllowCustomControls=1
AllowOLE1LinkFormat=0

[Run-Time Options]
TitleBar=Easy-Clean
StartupScreen=c:\ezc_ezc\mikenteo.bmp
Icon=c:\ezc_ezc\EZC.ico

[Clipboard Formats]
Microsoft Excel (*.xls)=soa200.dll,1,xls
Rich Text Format (*.rtf)=soa200.dll,2,rtf
MS-DOS Text (*.txt)=soa200.dll,3,txt

....

and so on.

Nov 13 '05 #2

P: n/a
MLH
Thanks, Doug, for the quick reply. I know you were just waiting there
for me to trip up. That's been happening to me a lot - past 50. I'll
look at the help, but along the same line of questioning...

Access 2.0 primary executable was named MSACCESS.EXE as is Access
97's. But, Access 2.0 named the runtime version's primary executable
MSARN200.EXE. That was handy - 2 different names, I mean. Did the
same logic carry forward with the advent of Access 97?

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxx
You have to create a Profile.

In the Access 97 Help file, look up "command-line options". From the 5
topics you get, select the 4th ("Start Microsoft Access with command-line
options". There, select the bottom option ("Specify command-line options for
a shortcut"). Choose the "To display the list of command-line options,
click" button. /profile will be the 6th option down.


Nov 13 '05 #3

P: n/a
MLH
Found it! But, man, without your precise guidance - I think
I never would have. Thanks a lot!

/profile user profile Starts Microsoft Access using the options in
the specified user profile instead of the standard Windows Registry
settings created when you installed Microsoft Access. This replaces
the /ini option used in previous versions of Microsoft Access to
specify an initialization file. The Microsoft Office 97, Developer
Edition, contains tools and information on creating user profiles. For
more information, click ...

I'm afraid I know NOTHING of creating user profiles. When I click
Start, All Programs, Microsoft ODE Tools, I get several choices to
pick from - all of which I'm afraid to launch because I know NOTHING
about it. The only thing I'm confident about is the Setup Wizard,
because I used it SO MUCH in the Access 2.0 / ADT days. What am
I supposed to launch to enable me to create user profiles?
Nov 13 '05 #4

P: n/a
Access 2.0 was the only version to have the runtime as a different
executable than the regular program. All others use the same executable
msaccess.exe (severely limited through the inclusion of literally hundreds
of registry entries)

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

"MLH" <CR**@NorthState.net> wrote in message
news:mm********************************@4ax.com...
Thanks, Doug, for the quick reply. I know you were just waiting there
for me to trip up. That's been happening to me a lot - past 50. I'll
look at the help, but along the same line of questioning...

Access 2.0 primary executable was named MSACCESS.EXE as is Access
97's. But, Access 2.0 named the runtime version's primary executable
MSARN200.EXE. That was handy - 2 different names, I mean. Did the
same logic carry forward with the advent of Access 97?

Nov 13 '05 #5

P: n/a
Look at the first entry under "profiles, user"

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

"MLH" <CR**@NorthState.net> wrote in message
news:cd********************************@4ax.com...
Found it! But, man, without your precise guidance - I think
I never would have. Thanks a lot!

/profile user profile Starts Microsoft Access using the options in
the specified user profile instead of the standard Windows Registry
settings created when you installed Microsoft Access. This replaces
the /ini option used in previous versions of Microsoft Access to
specify an initialization file. The Microsoft Office 97, Developer
Edition, contains tools and information on creating user profiles. For
more information, click ...

I'm afraid I know NOTHING of creating user profiles. When I click
Start, All Programs, Microsoft ODE Tools, I get several choices to
pick from - all of which I'm afraid to launch because I know NOTHING
about it. The only thing I'm confident about is the Setup Wizard,
because I used it SO MUCH in the Access 2.0 / ADT days. What am
I supposed to launch to enable me to create user profiles?

Nov 13 '05 #6

P: n/a
MLH
You mean look at it throught regedit utility?
Look at the first entry under "profiles, user"


Nov 13 '05 #7

P: n/a
MLH
Interesting.

Say, Doug, I noticed that if I install a runtime access APP on
a machine that does not have ms access 97 installed on it,
the way the app launches on there looks different to me
than it does launching on a machine which had access 97
on it when the runtime APP was installed. Is that intentional?

I sort of like the runtime app to look like a stand-alone custom
built app. Gives off autonomous overtones. If you start it up
and the MS Access 97 splash screen displays, well, the cats
out-a-the bag so to speak.
Nov 13 '05 #8

P: n/a
"MLH" <CR**@NorthState.net> wrote in message
news:mu********************************@4ax.com...
Interesting.

Say, Doug, I noticed that if I install a runtime access APP on
a machine that does not have ms access 97 installed on it,
the way the app launches on there looks different to me
than it does launching on a machine which had access 97
on it when the runtime APP was installed. Is that intentional?

I sort of like the runtime app to look like a stand-alone custom
built app. Gives off autonomous overtones. If you start it up
and the MS Access 97 splash screen displays, well, the cats
out-a-the bag so to speak.


You can put a bitmap file with the same name as your mdb file (except
extension) in the same folder and that will display instead of the normal
splash screen.

Or you can just not be ashamed of your choice of development tool.
Nov 13 '05 #9

P: n/a
MLH

You can put a bitmap file with the same name as your mdb file (except
extension) in the same folder and that will display instead of the normal
splash screen. Will have a go at it.

Or you can just not be ashamed of your choice of development tool.

Point well taken.
Nov 13 '05 #10

P: n/a
MLH
That did the trick. Thanks Rick.
Ashamed is not a fair description,
really, not from my own perspective.
(I know you were speaking hypothetically)
Its really for customer satisfaction more
than anything else. They like to see
themselves in print. I always try to
splash their logo in their face
whenever possible. They
respond well to it. And
when they are pay-
ing, making
them feel
good is
nice.
Nov 13 '05 #11

P: n/a
Initially, yes. Once you know what needs to be added to the registry, you
can always export those keys into a .reg file that you can use for your
users.

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

"MLH" <CR**@NorthState.net> wrote in message
news:rq********************************@4ax.com...
You mean look at it throught regedit utility?
Look at the first entry under "profiles, user"

Nov 13 '05 #12

P: n/a
"MLH" <CR**@NorthState.net> wrote in message
news:g4********************************@4ax.com...
That did the trick. Thanks Rick.
Ashamed is not a fair description,
really, not from my own perspective.
(I know you were speaking hypothetically)
Its really for customer satisfaction more
than anything else. They like to see
themselves in print. I always try to
splash their logo in their face
whenever possible. They
respond well to it. And
when they are pay-
ing, making
them feel
good is
nice.


I would then use a "splash form" instead. In my experience the pre-Access
splash is now displayed so briefly on modern machines that it doesn't serve that
purpose very well.

I didn't intend to sound harsh before. It's just that posts are pretty common
in here asking to "make it look like I'm using a *real* program instead of
Access".

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #13

P: n/a
MLH
Not at all. In a decade on this forum (not as much
as many of you, mind you) I must say that a wealth
of good things have rolled my way. I found what I
was looking for.

xxxxxxxxxxxxxxxxxxxxxxxxxxx

On Fri, 17 Jun 2005 10:53:08 GMT, "Rick Brandt"
<ri*********@hotmail.com> wrote:
"MLH" <CR**@NorthState.net> wrote in message
news:g4********************************@4ax.com.. .
That did the trick. Thanks Rick.
Ashamed is not a fair description,
really, not from my own perspective.
(I know you were speaking hypothetically)
Its really for customer satisfaction more
than anything else. They like to see
themselves in print. I always try to
splash their logo in their face
whenever possible. They
respond well to it. And
when they are pay-
ing, making
them feel
good is
nice.


I would then use a "splash form" instead. In my experience the pre-Access
splash is now displayed so briefly on modern machines that it doesn't serve that
purpose very well.

I didn't intend to sound harsh before. It's just that posts are pretty common
in here asking to "make it look like I'm using a *real* program instead of
Access".


Nov 13 '05 #14

P: n/a
MLH
I know this thread is a couple of weeks old now, but I'm revisiting to
ask why /runtime is not included in the help section you so kindly
detailed for me. More recently, someone asked me if I was using it.
No, I was not. I thought I could read more about it in this help
section. I don't think so.

xxxxxxxxxxxxxxxx

You have to create a Profile.

In the Access 97 Help file, look up "command-line options". From the 5
topics you get, select the 4th ("Start Microsoft Access with command-line
options". There, select the bottom option ("Specify command-line options for
a shortcut"). Choose the "To display the list of command-line options,
click" button. /profile will be the 6th option down.


Nov 13 '05 #15

P: n/a
MLH wrote:
I know this thread is a couple of weeks old now, but I'm revisiting to
ask why /runtime is not included in the help section you so kindly
detailed for me. More recently, someone asked me if I was using it.
No, I was not. I thought I could read more about it in this help
section. I don't think so.


In Access 97 one could only use /Runtime if a runtime app or the ODE tools had
been installed on the system. If you tried to use it with just Office Pro
installed you would get an error. I assume that is why it was not mentioned in
the standard help topic.

The newer versions do not have this restriction.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #16

P: n/a
MLH
That's probably as good a reason as any.
Thanks!
Nov 13 '05 #17

This discussion thread is closed

Replies have been disabled for this discussion.