Re: How to impose security on access database
From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 02/17/05
- Next message: adribog: "Security & Permissions"
- Previous message: '69 Camaro: "Re: login script"
- In reply to: Shobha: "How to impose security on access database"
- Next in thread: Shobha: "Re: How to impose security on access database"
- Reply: Shobha: "Re: How to impose security on access database"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Feb 2005 20:35:54 -0800
Hi.
> I went and imposed
> security using User Group permissions and User Level Secuirty Wizard. Did
> I
> do correctly?
Possibly. Can authorized users open the database? Are unauthorized users
prevented from opening the database, copying and importing database objects,
and linking to the tables? If the answer is yes to both questions, then you
are off to a good start. If you want a better understanding of Access
security, then study the Security FAQ on the following Web page:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
> "This file is located outsite your intranet or an untrusted site.
> Microsoft
> Access will no open the file due to potential security problems.To open
> the
> file,copy it to your machine or an accessible network location."
This is an Office XP security error message, not an Access user-level
security error message.
> Does this mean that I cannot access a file which was shared on a different
> network?
It means that you won't be able to open the database file in Access 2002 on
any network until you fix the security issue.
> How can I solve this problem?
Do you have any linked tables in this database? Do you have any tables that
the database is connecting to in VBA code or in a form property or query
property? Do any of the paths or file names for these remote tables contain
a period in the name, such as an IP address? If so, use the universal
naming convention (UNC) for the path instead, or change the path or file
name to remove any periods (except the period before the file name
extension, which is acceptable).
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Shobha" <Shobha@discussions.microsoft.com> wrote in message
news:2DE1D29E-472B-41D2-8809-7A061E836D9B@microsoft.com...
> We are supposed to make our Access database read only. I went and imposed
> security using User Group permissions and User Level Secuirty Wizard. Did
> I
> do correctly? This I did it in one network. When I come back home and pull
> out the same file it says the following error:
>
> "This file is located outsite your intranet or an untrusted site.
> Microsoft
> Access will no open the file due to potential security problems.To open
> the
> file,copy it to your machine or an accessible network location."
>
> Does this mean that I cannot access a file which was shared on a different
> network? How can I solve this problem?Any help regarding this is
> appreciated.
>
> Thanks
> Shobha
>
>
>
- Next message: adribog: "Security & Permissions"
- Previous message: '69 Camaro: "Re: login script"
- In reply to: Shobha: "How to impose security on access database"
- Next in thread: Shobha: "Re: How to impose security on access database"
- Reply: Shobha: "Re: How to impose security on access database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
