/wrkgrp does not work

[Wael]

hi all
I want to open a secured msaccess xp database from vb6 application .I used
the shell command :
iRetrun=Shell( "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE
C\MyDataBase.mdb /user username /PWD password /WrkGrp
C:\SecurityFile.mdw",1)
when msaccess opens i get the message :
"You do not have the necessary permissions to use the C:\MyDataBase.mdb
object. Have your system administrator or the person who created this object
establish the appropriate permissions for you. "

any idea how to solve this problem

thanks in advance

Wael

 

[a a r o n . k e m p f]

USER LEVEL SECURITY has been removed from Access because it is too
buggy for real world usage.
If you need to secure your data, then you need to move to SQL Server.

-Aaron

 

[bcap]

Ignore Kempf, he is an idiot, a liar and a convicted criminal.

 

[BruceM]

Maybe it's a typo, but you didn't close the quote after MSACCESS.EXE. If
that doesn't help, what happens if you use the following as a shortcut
without using the shell command (line returns for clarity only):
"C:\Program Files\Microsoft Office\OFFICE10\MSACCESS.EXE"
C:\MyDataBase.mdb
/user username
/PWD password
/wrkgrp C:\SecurityFile.mdw

If not, about if you try quotes around username and password? I don't think
it should matter if there are no spaces or other non-alphanumeric
characters, but it's worth a quick experiment, I think. I expect the path,
username, etc. are made-up names for clarity in the posting, but I can only
assume they reflect what is actually going on.

BTW, I expect you know to ignore Aaron. I think Office10 means you have
Office 2000, which means of course that there is user-level security. Also,
user-level security has been removed for database files in Access 2007
format, but can still be used for earlier formats.

 

[Tony Toews [MVP]]

USER LEVEL SECURITY has been removed from Access

Rubbish. This is only correct for Access 2007 accdb files. For
Access 2007 MDBs and previous versions of Access this is false.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

Maybe it's a typo, but you didn't close the quote after MSACCESS.EXE.

Good catch. And you'd need to put ""s around the other parameters if
there were any spaces in them as well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

Tony Toews _EATS_ rubbish
it's true for the most popular formats in Access 2000, 2002, 2003 and
2007.

 

[bcap]

With which totally incorrect statement Kempf proves that he is an idiot, a
liar, or both. That he is a convicted criminal is a matter of record.

 

[a a r o n . k e m p f]

a) it's not a matter of record
b) I didn't plead guitly to anything that they charged me with
c) User Security doesn't work for Access 2007; and ADP was the most
popular format in 2000, 2002, and 2003.


1) File
2) New
3) stop and count the options. Project (new data), Project (existing
data), Database.

So TWO OUT OF THREE FILE MENU OPTIONS INVOLVE ADP AND NOT MDB?

So thus.. 'adp is the most popular format in 2000, 2002, and 2003'

-Aaron

 

[bcap]

message

a) it's not a matter of record

It surely is. In the public domain. You lie again.

b) I didn't plead guitly to anything that they charged me with

The implicit admission being that you *did* plead guilty. Ergo, you are a
convicted criminal. Ergo, when you deny this, you lie.

c) User Security doesn't work for Access 2007;

Only if you use the accdb format, it works as ever with mdb. Either you
don't know this, in which case you are an idiot, or you do know it, in which
case you are a liar.

and ADP was the most popular format in 2000, 2002, and 2003.

Hah! Prove it!

1) File
2) New
3) stop and count the options. Project (new data), Project (existing
data), Database.
So TWO OUT OF THREE FILE MENU OPTIONS INVOLVE ADP AND NOT MDB?
So thus.. 'adp is the most popular format in 2000, 2002, and 2003'

Interesting definition of "popular". Indubitable proof that you are an
idiot.

So there you have it straight from the horse's mouth: an idiot, a liar, and
a convicted criminal.

 

[a a r o n . k e m p f]

keywords = 'to anything that they charged me with '

 

[a a r o n . k e m p f]

I'm not going to mince words.

It was removed from Access 2007 because it was too buggy and insecure
for real world usage.
from now on-- if you need to secure your access applications; you need
to use ADP

and yes, I did just prove it was the most popular format.

I'm not an idiot or a liar.

I just won't put up with your constant misinformation.

Jet fucking sucks.
Replication and Security were yanked out of 2007-- anyone with a clue
that needs to do these functions has no other option but to use SQL
Server and ADP.

-Aaron

 

[bcap]

in message
keywords = 'to anything that they charged me with '

The implicit admission being, that you pleaded guilty, ergo (i) you are a
convicted criminal and (ii) when you deny this you lie. It's a matter of
public record, the only person you are fooling is yourself (although
admittedly it's not hard to fool an idiot).

 

[bcap]

message

It was removed from Access 2007 because it was too buggy and insecure
for real world usage.

It's still in Access 2007, only an idiot or a liar would deny this.

and yes, I did just prove it was the most popular format.

In your own little idiot fantasy world.

 

[Klatuu]

Ignore Aaron Kempf.
Security was removed from 2007 not because it is buggy, but because it does
not really provide much security and has given some users a false sense of
being secured.

 

[David W. Fenton]

"a a r o n . k e m p f @ g m a i l . c o m"


Rubbish. This is only correct for Access 2007 accdb files. For
Access 2007 MDBs and previous versions of Access this is false.

I went round and round with Aaron on replication. He claims that
because the new file format doesn't support it that it's the same as
A2K7 not supporting it.

I told him he was an idiot.

 

[a a r o n . k e m p f]

Access 2007 doesn't support replication.
it's really simple math.

Access 2007 doesn't support 'User Level Security'.

Maybe I'm implying the word 'format' but I don't care
Jet and Replication and User Level Security are all dead; and they
have been for a decade

 

[a a r o n . k e m p f]

wow. so 'not providing much real security' is not a bug?

 

[a a r o n . k e m p f]

convicted and plead are two different things.

I was not convicted. I plead. And nothing technically goes on my
record now, or in the future.

So -- play word games as you want-- but NO I was not convicted

 

[bcap]

How is your probation officer, Aaron? Is he/she nice? Was the anger
management course helpful? What about the community service? Was it very
boring? Perhaps a little dirty and smelly too?