jim41797
asked on
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?
shanesuebsahakarn
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).
ASKER
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?
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?
How do your users connect into your LAN?
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
To be fair, I did mention zipping.....
ASKER
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.