How to impose security on access database

[Shobha]

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

 

['69 Camaro]

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]

Thanks for your reply.

What we have is a database for a beginner. All they will do is run the
wizard and write a query or table or form.My Concern was if i put the
database in one shared directory all authorised user can view it. But if they
try to download the same from that directory to their drive it won't work.
Thats why wanted to know how can I solve this issue. I have created all my
tables or forms or reports using the wizard. We dont have an application
which would connect to this database. Instead we have placed a database in
one shared directory and given the link to access it. Thats it. The students
gotto view the database directly. The course is beginner's course for MS
Office.

Shobha

 

['69 Camaro]

Hi.

But if they
try to download the same from that directory to their drive it won't work.

See if information in the following MS KB article helps:

http://support.microsoft.com/?id=303650

Make sure that the network shared directory is located within the same
domain as the workstations trying to access the database file. Also, make
sure that the shortcut that opens the secure database on the network uses
the following syntax, without IP addresses or periods in the path (except
the period before the file name extension):

"<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB" /wrkgrp

The course is beginner's course for MS
Office.

Relational databases is an advanced computer topic. Access has a pretty
steep learning curve, too. I wouldn't recommend it for computer novices.

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]

Thanks.

Yes my database is on a shared directory which lies on the same domain as
the workstations trying to access. So no problem.

Thanks a lot for your reply

Shobha

 

['69 Camaro]

You're welcome.

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.)