Command line utility

[Basabn]

I am using MS Access in Windows enviornment. I need to update fields (rows) from the command prompt (Dos prompt). Is there any command line utility / application to do the same ?

 

[simongallop]

You can create a macro in Access to update the rows and call it from the command line:

"c:\program files\microsoft office\office\msaccess.exe" c:\yourpath\yourdb.mdb /X MacroName

HTH

 

[Basabn]

Thanks for the quick response.

The problem is as mentioned:
I am running an monitoring application that needs to update certain rows (fields) in an MS access database in certain situations.
But this an application that does not have any plugins for access, however, it can run (shell/DOS) commands on those situations.

Hence, it those situations it should be able to change certain fileds of a row based on primary key.

Can Macro do the same ie can a Macro take paramenters like Primary key value, New value of the affected field etc.

Lke can I call the micro as ?
"c:\program files\microsoft office\office\msaccess.exe" c:\yourpath\yourdb.mdb /X MacroName Primary_key_value, Column_name, New_values ..... or simmilar