I have a client with 2 differently named workgroups. We just upgraded all PCs in Workgroup 2 to XP Pro. After the upgrade all of the Windows XP clients can see the shares on the other workgroup (the PC in the other workgroup is also a XP Pro system and this has the key database on it.)
The two workgroups are interconnected via a LinkSys Router that they both share in order to get onto the Internet via the same broadband provider.
We have 2 separate Access databases – one on each workgroup. These need to be separate and secure (security was not an issue in the past since the workgroups could not be seen). Neither database has a password on it right now.
The longer term vision is to have these 2 separate databases doing their own thing but each db would have a connection to a ‘public’ db for some open and shared information.
We’ve looked at single file server & workgroup, 2 file servers (no more peer to peer workgroups), and a NAS appliance between the 2 existing workgroups.
Any configuration suggestions and insights into XP Pro workgroup networking and ‘bigger’ solutions will be appreciated.
Thanks.