Batch script workgroup file problems

[Kempes]

Hi all,

I'm attempting to create a batch file which I have successfully managed with databases that does not contain user security.

What the script does is compacts the db and saves a copy to a named location.

I can get it to open the db with my work group file but how do I pass it the username and password so it can log in automatically?

so far I have this.

"c:\Program Files\Microsoft Office\Office\msaccess.exe" "mydbpath" /wrkgrp "mywrkgrppath" /compact
copy /y path1 path2

Any help would be greatly appreciated.

kempes

 

[Kempes]

Got it now!

 

[Kempes]

OK I'm back again.

When using /repair in my batch file, it halts the remainder of the script until you select OK for the message telling you the repair was successful.

Is there a way to tell it to ignore this message and continue, or get it to select OK automatically so it can continue with the rest of the script?

 

[Kempes]

By the way, if anyone else wants to do this, here is how.

"c:\Program Files\Microsoft Office\Office\msaccess.exe" "mydbpath" /wrkgrp "mywrkgrppath" /user = "user" /pwd = "password" /compact
copy /y path1 path2

You can also change this to ignore the compact if the ldb file exists.

still stuck on this /repair thing though if anyone has any ideas?