Software

Ask something
Discussion Locked

sharing access database in workgroup

0 helpful
3 replies

by mithrandir

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My customer has an access database on a win95 wrkstn in a workgroup. I can bring up the database with a win2k wrkstn in the same workgroup but, (this is courthouse using ms access to manage case dockets)when I try to access the docket on a certain date with the win2k wrkstn, the info is not there even when I copy the database directly to the win2k client. What would be the best way to share the database between the wrkstns? I am afraid to upgrade the win95 machine in case the database cannotbe read at all.

3 replies

by otl

You do not mention if you are getting a file sharing message, so I'll assume you are not.

Does the Win2K station have Access 2000 or Access 97 on it. Have seen strange indications opening a 97 database with 2000.

If both stations have the same version of access on them then the tables are restricted for the group that station is in. With the database open go to TOOLS - > SECURITY - > USER AND GROUPS PERMISSION verify that read data is checked for each file you want the station to be able to view to include forms.

GOOD LUCK.

by mithrandir

Great answer, no file sharing message, same version of access on both --- excited about the proposed solution --- can't wait to try. Thanks Thanks

This discussion is closed to new replies.