How to invoke access application through command promt

[Guest]

I Created an access application,linked oracle tables.
I want to Invoke application automatically through command promt(Dos Promt)
using oracle user name and password.
Any Help is Greatly Appreciable.

 

[JohnFol]

Check out "Startup command-line options " in the help screens. There is a
switch for username / password that applies to the MDB but you can
programatically get them, or use the /cmd switch

/cmd Specifies that what follows on the command line is the value that
will be returned by the Command function. This option must be the last
option on the command line. You can use a semicolon ( as an alternative to
/cmd.
Use this option to specify a command-line argument that can be used in
Visual Basic (Microsoft Visual Basic: A high-level, visual-programming
version of Basic. Visual Basic was developed by Microsoft for building
Windows-based applications.) code.

 

[Guest]

Thanks for the Response
I am little confused on the syntax of the command to be used from command
promt
For example mydatabse name is aa.mdb I have set the databse password as 123
it is located in "d" directory

from command prompt I am using below sysntax
d:>"aa.mdb" /password "123"

it open the application but still it asks for the password.I am missing
something here.
Thanks for your time

 

[Joan Wild]

For example mydatabse name is aa.mdb I have set the databse password
as 123 it is located in "d" directory

from command prompt I am using below sysntax
d:>"aa.mdb" /password "123"

There is no switch for the database password. The /pwd switch is for use
with Access User Level Security.

 

[Guest]

Thanks for the response
I will try to explain my problem little more detail way
I developed access application.I linked oracle tables using odbc connection.
I have not created any access username and password.
when I double click on *.mdb,oracle odbc driver connect box show up.I enter
the username and password.application open no problem.

Now I want the application to be opend from command prompt by providing
oracle username and password.
I don't know the exact syntax to be used from the command promt.do I need to
provide odbc dsn also in the command promt.

Any help is appreciable
Thanks

 

[Joan Wild]

Thanks for the response
I will try to explain my problem little more detail way
I developed access application.I linked oracle tables using odbc
connection. I have not created any access username and password.
when I double click on *.mdb,oracle odbc driver connect box show up.I
enter the username and password.application open no problem.

Now I want the application to be opend from command prompt by
providing oracle username and password.

You cannot do this via startup switches. I am not familiar with oracle, but
when you link to the oracle tables, there should be an option to save the
usrename/password in the link, and there you don't need to provide it at
startup.

 

[Guest]

I know the option of saving the password when we link the tables but later on
multiple users are going to use the application with different usernames and
passwords then it is going to be a problem.

I just to make the application run form command promt by providing initially
with single user name

 

[Joan Wild]

I know the option of saving the password when we link the tables but
later on multiple users are going to use the application with
different usernames and passwords then it is going to be a problem.

I just to make the application run form command promt by providing
initially with single user name

To my knowledge it can't be done. I suggest you try your question in
externaldata or odbcclientsvr newsgroup.

 

[Guest]

Thanks for your suggestion

To my knowledge it can't be done. I suggest you try your question in
externaldata or odbcclientsvr newsgroup.