I lock my own databse

[shiro]

Hi All,
I have create a db in my computer in my company.
When making this db I use account 'user',which mean
I have no rights to have this db exclusively.
I just performed one step security wizard to my db
( I don't really understand with this ),and in the end
I can't open my db anymore,Access just sent me
a message

"You don't have necessary to openfile c:/my document//.
Have your system administrator or the person who estabilish
approriate permission for you"

I don't know what I made wrong,I'm confuse.
Please somebody help me,How do I retrieve my db can
be opened again.please....

 

[Joseph Meehan]

Hi All,
I have create a db in my computer in my company.
When making this db I use account 'user',which mean
I have no rights to have this db exclusively.
I just performed one step security wizard to my db
( I don't really understand with this ),and in the end
I can't open my db anymore,Access just sent me
a message

"You don't have necessary to openfile c:/my document//.
Have your system administrator or the person who estabilish
approriate permission for you"

I don't know what I made wrong,I'm confuse.
Please somebody help me,How do I retrieve my db can
be opened again.please....

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

Access 2007 as it doesn't support user-level security.

 

[dbahooker]

MDB isn't reliable enough for real world usage

if you know ANYTHNIG about databases
move to SQL Server

 

[Joseph Meehan]

MDB isn't reliable enough for real world usage

if you know ANYTHNIG about databases
move to SQL Server

Sorry about Aaron - you get all types in a public forum!! Sometimes he even
uses his own name.