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

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.

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

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" <CRCI@NorthState.net> wrote in message
news:0er3b152n2eu5vjmuog7dptb2bprlulalb@4ax.com...[color=blue]
>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.[/color]

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

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
[color=blue]
>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.[/color]

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

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?

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

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" <CRCI@NorthState.net> wrote in message
news:mmt3b15ust4k7c2olc2cblgbneub46e4t6@4ax.com...[color=blue]
> 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?[/color]

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

Look at the first entry under "profiles, user"

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



"MLH" <CRCI@NorthState.net> wrote in message
news:cdu3b1hv2s8t9nmdefv7bnpnu4nrn1q5v7@4ax.com...[color=blue]
> 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?[/color]

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

You mean look at it throught regedit utility?
[color=blue]
>Look at the first entry under "profiles, user"[/color]

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

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.

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

"MLH" <CRCI@NorthState.net> wrote in message
news:mu94b1dplvkc4uvs24br28jtod78rp287l@4ax.com...[color=blue]
> 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.[/color]

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.

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

[color=blue]
>
>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.[/color]
Will have a go at it.
[color=blue]
>
>Or you can just not be ashamed of your choice of development tool.[/color]
Point well taken.

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

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.

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

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" <CRCI@NorthState.net> wrote in message
news:rq94b1ltlt7flj8qamvrmchtm6m004c1vl@4ax.com...[color=blue]
> You mean look at it throught regedit utility?
>[color=green]
>>Look at the first entry under "profiles, user"[/color]
>[/color]

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

"MLH" <CRCI@NorthState.net> wrote in message
news:g4c4b1hqhp634chgl7oorpqbd7q74075tv@4ax.com...[color=blue]
> 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.[/color]

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

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

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"
<rickbrandt2@hotmail.com> wrote:
[color=blue]
>"MLH" <CRCI@NorthState.net> wrote in message
>news:g4c4b1hqhp634chgl7oorpqbd7q74075tv@4ax.com.. .[color=green]
>> 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.[/color]
>
>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".[/color]

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

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

[color=blue]
>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.[/color]

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

MLH wrote:[color=blue]
> 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.[/color]

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

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

That's probably as good a reason as any.
Thanks!