Using vbscript to run an function in ms access 2007

Asked Jun 29 '18 at 14:37

Active Jun 29 '18 at 14:42

Viewed 47 times

I have a backend database protected with password. I want to run an vbscript to compact and repair the database can you please help me to do that.

Thanks in advance.

edited Jun 29 '18 at 14:42

Erik A

asked Jun 29 '18 at 14:37

Shinilrk

1

SO is not inteded as a "give me ze code" platform – Freggar Jun 29 '18 at 14:46
Do it by yourself before asking – madrac Jun 29 '18 at 14:49
VBScript isn't VBA, are you *sure* you want to do this with VBScript? – Mathieu Guindon Jun 29 '18 at 14:53
1

See this, there's an example using VBScript: https://stackoverflow.com/questions/3503736/access-compact-and-repair-programatically – Kostas K. Jun 29 '18 at 14:56
@KostasK. that's VBA. VBScript doesn't have an `As` keyword :) – Mathieu Guindon Jun 29 '18 at 14:59
@MathieuGuindon - Kostas mentions there's a VBScript example in his question link - that specific example link is https://stackoverflow.com/a/3517111/2419128 – dbmitch Jun 29 '18 at 15:26
1

@dbmitch ah, missed it. So there's fun for everyone then! =) – Mathieu Guindon Jun 29 '18 at 15:29
@madrac thnx for your valuable "comment" – Shinilrk Jun 29 '18 at 16:02

0 Answers0