• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

MS Access 2002 user permissions for users outside of domain/workgroup, problems opening file after Win XP SP2 update

I am currently running Access 2002 on Windows XP pro computers within a domain for our membership database. We have some users who work remotely from home and are not part of our domain/workgroup. After Windows XP SP2 update our users outside of the domain are able to open this database file as "read only" but are not able to run queries or change data within the copy of this file that we regularly email to them. The users have tired opening the file exclusively but this does not seem to work either. I'm feeling kind of stuck here. Our remote users are not technically proficient so I need a solution whereby I make the change so that the user is able to open the file as usual. We have temporaraly uninstalled the SP2 update but I'm not really comfortable leaving their machines without this update. Can anyone help?
0
jim41797
Asked:
jim41797
  • 4
  • 4
1 Solution
 
shanesuebsahakarnCommented:
It won't be anything to do with Access per se. Your users will need to have full read/write access into the database's folder and the update may be preventing this. I'm not really familiar with SP2, but you might try turning off the firewall for the VPN connection (if that is what you are using).
0
 
jim41797Author Commented:
shanesuebsahakarn, thanks for your input. Sounds like you are on the right track but I'm still not quite sure what to do next.
A few items you mentioned in your reply such as VPN, which we don't use and turning off the firewall, I've already done.
Does it sound like I'll have to set up this user as part of the domain?
0
 
shanesuebsahakarnCommented:
How do your users connect into your LAN?
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
jim41797Author Commented:
Users, who are part of the domain, connect to the LAN through eithernet cable or secured wireless. The "remote" staff who reside outside of the domain (outside of the state actually) communicate through email (POP account) through our ISP. They are not part of our domain, they do not have access to the LAN,  nor do they connect through VPN. The MS Access 2002 file is sent via email only. Does this info help?
0
 
shanesuebsahakarnCommented:
Oh, I see - the file is emailed to them? Is it zipped?
0
 
jim41797Author Commented:
I have sent it zipped and unzipped. It won't open at all if it is unzipped.

Very strange. We got it to work, but ONLY if they open the zip folder and drag the database file into another folder or onto the desktop.  It does not work if we try to open the database in an unzipped format, or if we extract the database from the zip file. I don't know how or why this works.

Thanks for taking the time to help.
I think we can close this discussion.
0
 
shanesuebsahakarnCommented:
To be fair, I did mention zipping.....
0
 
jim41797Author Commented:
Yes, you did mention zipping. However, I had already tried this. I would say though that I ommitted that piece of information and I shouldn't have assumed that this was understood. I will award you the 250 points.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now