VB & Database, Urgent! Please help...password protected database

Urgent! Please help...password protected database

Author	Message
Davi #1 / 7	Urgent! Please help...password protected database How do I use the shell command to run msaccess.exe to open a database that has a password set? Thanks! David
Wed, 29 Jun 2005 08:25:22 GMT

Chris Barbe #2 / 7	Urgent! Please help...password protected database Do you mean open the Application and it's associated GUI or just access it using ADO to execute queries etc. against the data. Chris Barber. How do I use the shell command to run msaccess.exe to open a database that has a password set? Thanks! David
Wed, 29 Jun 2005 08:43:54 GMT

Davi #3 / 7	Urgent! Please help...password protected database I use the following to open access to print reports from VB 6.0. It works fine except when I set a database password. Not sure what the command line would be to open the database with a password set. x = Shell(App.Path & "\msaccess.exe " & Chr$(34) & strDBName & Chr$(34) & "/Runtime /Wrkgrp " & Chr$(34) & App.Path & "\system.mdw" & Chr$(34), vbNormalFocus) -David Quote: > Do you mean open the Application and it's associated GUI or just access it using ADO to execute queries etc. against the Quote: > data. > Chris Barber. Quote: > How do I use the shell command to run msaccess.exe to open a database that > has a password set? > Thanks! > David
Wed, 29 Jun 2005 08:53:14 GMT

Sreenivas Chaparal #4 / 7	Urgent! Please help...password protected database Automate the password typing using SENDKEYS You can also use WSH control's appactivate, run and sendkeys from within VB. If you like use 100% command line use a VBScript with wshshell. vasu Sreenivas (Vasu) Chaparala MCAD, MCSD, MCSE, MCP+I, SCJP Quote: >-----Original Message----- >I use the following to open access to print reports from VB 6.0. It works >fine except when I set a database password. Not sure what the command line >would be to open the database with a password set. > x = Shell(App.Path & "\msaccess.exe " & Chr$(34) & strDBName & >Chr$(34) & "/Runtime /Wrkgrp " & Chr$(34) & App.Path & "\system.mdw" & >Chr$(34), vbNormalFocus) >-David message >> Do you mean open the Application and it's associated GUI or just access it Quote: >using ADO to execute queries etc. against the >> data. >> Chris Barber. >> How do I use the shell command to run msaccess.exe to open a database that - Hide quoted text - - Show quoted text - Quote: >> has a password set? >> Thanks! >> David >.
Wed, 29 Jun 2005 09:17:48 GMT

Sreenivas Chaparal #5 / 7	Urgent! Please help...password protected database Automate the password typing using SENDKEYS You can also use WSH control's appactivate, run and sendkeys from within VB. If you like use 100% command line use a vbscript with wshshell. vasu Sreenivas (Vasu) Chaparala MCAD, MCSD, MCSE, MCP+I, SCJP Quote: >-----Original Message----- >I use the following to open access to print reports from VB 6.0. It works >fine except when I set a database password. Not sure what the command line >would be to open the database with a password set. > x = Shell(App.Path & "\msaccess.exe " & Chr$(34) & strDBName & >Chr$(34) & "/Runtime /Wrkgrp " & Chr$(34) & App.Path & "\system.mdw" & >Chr$(34), vbNormalFocus) >-David message >> Do you mean open the Application and it's associated GUI or just access it Quote: >using ADO to execute queries etc. against the >> data. >> Chris Barber. >> How do I use the shell command to run msaccess.exe to open a database that - Hide quoted text - - Show quoted text - Quote: >> has a password set? >> Thanks! >> David >.
Wed, 29 Jun 2005 09:18:44 GMT

Davi #6 / 7	Urgent! Please help...password protected database Can you give more details on this? Quote: > Automate the password typing using SENDKEYS > You can also use WSH control's appactivate, run and > sendkeys from within VB. > If you like use 100% command line use a vbscript with > wshshell. > vasu > Sreenivas (Vasu) Chaparala > MCAD, MCSD, MCSE, MCP+I, SCJP > >-----Original Message----- > >I use the following to open access to print reports from > VB 6.0. It works > >fine except when I set a database password. Not sure what > the command line > >would be to open the database with a password set. > > x = Shell(App.Path & "\msaccess.exe " & Chr$(34) > & strDBName & > >Chr$(34) & "/Runtime /Wrkgrp " & Chr$(34) & App.Path > & "\system.mdw" & > >Chr$(34), vbNormalFocus) > >-David > message > >> Do you mean open the Application and it's associated > GUI or just access it > >using ADO to execute queries etc. against the > >> data. > >> Chris Barber. > >> How do I use the shell command to run msaccess.exe to > open a database that > >> has a password set? > >> Thanks! > >> David > >.
Wed, 29 Jun 2005 09:42:25 GMT

Dan Artus #7 / 7	Urgent! Please help...password protected database HI, See this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2... l/acrefStartUpCommandLineOptionsS.asp -- HTH Dan Artuso, MVP "a problem well stated is a problem half solved" Quote: > I use the following to open access to print reports from VB 6.0. It works > fine except when I set a database password. Not sure what the command line > would be to open the database with a password set. > x = Shell(App.Path & "\msaccess.exe " & Chr$(34) & strDBName & > Chr$(34) & "/Runtime /Wrkgrp " & Chr$(34) & App.Path & "\system.mdw" & > Chr$(34), vbNormalFocus) > -David > > Do you mean open the Application and it's associated GUI or just access it > using ADO to execute queries etc. against the > > data. > > Chris Barber. > > How do I use the shell command to run msaccess.exe to open a database that > > has a password set? > > Thanks! > > David
Wed, 29 Jun 2005 22:07:31 GMT

Page 1 of 1

[ 7 post ]