Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-04-2019, 04:45 AM   #1
FrostByte
Newly Registered User
 
Join Date: Jan 2015
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
FrostByte is on a distinguished road
VBScript - Open a Access DB with both mdw and database password

Hi,

I'm looking for a VBScript I can run with the windows scheduler that will...

Open a Access DB with an mdw file
AND... which has a database password

So far I have...
"C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE" "C:\Dir\DATABASE.mdb" /wrkgrp "C:\Dir\MDWFILE.mdw" /user "UserName" /pwd "QWERTY"


Which will work but does not take into account the database password.

FrostByte is offline   Reply With Quote
Old 12-04-2019, 07:46 AM   #2
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,907
Thanks: 120
Thanked 3,324 Times in 3,000 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: VBScript - Open a Access DB with both mdw and database password

Have you tried using a string variable in place of the password?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 12-04-2019, 07:58 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,240
Thanks: 63
Thanked 1,678 Times in 1,633 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: VBScript - Open a Access DB with both mdw and database password

Hi. The only way I know how to open a password-protected database is through automation, so I think that leaves out the MDW part, unfortunately.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Access Database from VBScript mikebrewer Modules & VBA 11 07-01-2014 06:56 AM
Question Open MS Access Database locked by Password sunilpandey General 9 03-26-2013 03:47 PM
Using VBScript to open password protected db aziz rasul Modules & VBA 8 10-13-2010 09:26 AM
open mdb file with Access 97 exe using vbscript BJS Modules & VBA 1 09-14-2006 12:58 PM
Open an access db from vbscript Rob.Mills Modules & VBA 3 01-18-2006 08:42 AM




All times are GMT -8. The time now is 03:28 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World