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?
jim41797Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.