Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Modules daovba ado > Compacting pass...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 1486 of 1609
Post > Topic >>

Compacting password protected Access Backend databases from Fronte

by =?Utf-8?B?QW5kZXJz?= <anders18134@[EMAIL PROTECTED] > Jun 2, 2008 at 06:09 AM

I have been using the following code to compact and repair a backend that
is 
not password protected:

Dim stAppName As String
stAppName = "MSACCESS.EXE " & """" & Katalognamn() & "Test_be" & """" & 
"/nostartup /compact"
Call Shell(stAppName, vbNormalNoFocus)

and it works exactly as I want to. But now I have a password protected 
backend database (I am not using any profiles or so at all so it is just a

password nothing else)

I have tried the "/pwd xxxx" option but it seems like it wants me to also 
enter a user name and a password for that user - and I am not using user 
names for protection at all! How to solve this???

I am using Access 2003

Many thanks in advance!

Anders
 




 3 Posts in Topic:
Compacting password protected Access Backend databases from Fron
=?Utf-8?B?QW5kZXJz?= <  2008-06-02 06:09:01 
Re: Compacting password protected Access Backend databases from
"Douglas J. Steele&q  2008-06-02 12:05:11 
RE: Compacting password protected Access Backend databases from
=?Utf-8?B?RGFubnkgU2VhZ2V  2008-07-08 07:27:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 12:46:42 CST 2008.