running a batch to launch Access to specific record

[SallyGal]

Hi,

I am running a batch file (which is considered a hyperlink in my mapping
program) and it launches Access, which loads, maximizes a form to a specific
record (called in the batch). Each record has the same batch with the
exception of the info that follows the /cmd. Sample:

"C:\Program Files\Microsoft Office\Office12 MSACCESS.EXE"
"c:\gis\links\ValveMaintenance\ValveMaintenance.accdb"
/cmd 97501

It functions fine in Access 2000. We just upgraded to Access2007 and the
program loads, form maximizes, but does not call the record. I get the
"Name?" error in the text box.

Any suggestions???? Also, is there a more efficient way to perform this task?

THANKS!!!

 

[Tom van Stiphout]

On Thu, 12 Feb 2009 06:15:02 -0800, SallyGal

You're missing a backslash just before "msaccess.exe"

-Tom.
Microsoft Access MVP

 

[SallyGal]

Yes, that was just a slip of the wrist when copying but I had it in the
batch. Any other suggestions?
Thanks,
Sal

 

[SallyGal]

Yes, Tom, that was just a slip of the wrist when I copied the code into the
message. The batch does have the backslash. Any other suggestions as to why
it doesn't work? The database is in a trusted location.
Thanks in advance....

 

[Danny Lesandrini]

Sally

I just read a book on Access 2007 and the command line params were
mentioned, so I believe they are still supported. Are you sure the paths
are correct? Does the new link point to the install of Access 2007 on
the machine where you're running this?

Can you stop the code where the command param is being read and
verify if a value is found? I guess that's where I'd start debugging the
process. Put a STOP command right there and restart the app.

 

[SallyGal]

Hi Danny,

yes, in fact I chose a value that I KNOW works, so that is not the problem.
Great suggestion tho. I just thought I might have had to change a setting of
some kind and thought I'd ask all the wizards out there, as I am NOT one of
them.

If you think of anything else, that would be appreciated!
Sal