Access on the Network location

  • Thread starter Thread starter Roberta
  • Start date Start date
R

Roberta

Hello,

I created an Access XP database with no restrictions.
There are 20 users accessing this database on a shared
drive and there are no complains so far.
An agency outside our company needs to have access to this
database. I was told that data security management gave
them user name and password.
They see the drive and the database, but when they try to
open the database, a message pops up "Microsoft access can
not open this file.This file is located outside the your
intranet or on an untrusted site. Microsoft Access could
not open the file due to the potential security problems.
To open this file, copy it to your machine or an
accessible network location."
When they copy and paste the file to their desktop it
works, but where is the problem in order for them to open
and make the changes directly to our database on our
shared drive? IT group and data security management are
addressing this problem to me, and I don't have any
solution.

I didn't get any answer from the sequrity group.
If anyone knows how to solve this problem or at list where
I should address to, please help.


With appreciations.
Roberta
 
The username and password given has nothing to do with getting access to
your database. I would imagine they are just logging onto the domain
remotely. Your problem isn't an Access database issue, it is a Network
issue. The outside agencies machines are not considered trusted as they are
not part of your network domain. I'm not a network person, but somewhere
their machines need to be passed as trusted computers. Whether this is done
via IP addresses or some other means, that is up to your network or system
admin to solve.

Example: I had users from all over the country that needed to get to their
files that were on our webserver. I had to create a Global Group on our PDC
and then add a local group to the web server adding the global group from
the PDC. I also had to make sure that the webserver (member server) had 'Log
on Locally' allowed. This scenario may shed some light on what your Network
people have to do.
 
In addition, you need to make sure that the outside agency user's have
read/write/modify/execute permission on the database.
 
Thanks a milion for your respond!!!
-----Original Message-----
In addition, you need to make sure that the outside agency user's have
read/write/modify/execute permission on the database.




.
Click to expand...
 
Back
Top