my client has a MSA2003 database that they now run under MSA2007. Despite the documentation that MSA 2007 is compatible with the existing MSA2003 security, It appears that the System.mdw and workgroup admin functions have been changed significantly in MSA2007.
If an MSA2003 database running under MSA2007 loses the System.mdw file, it appears to create a problem.
Is there a way to join an existing System.mdw file using MSA 2007? I understand that if you migrate to OFF 2007 it should work. However, if the System.mdw gets lost, MSA 2007 creates a new file Security.mdw. I tried to connect to my old System.mdw using the MSA 20007 Workgroup Admin but it didn't seem like that was an option.
I understand you can reset the path and file using the Registry and while this is OK for my, I would not recommend it to my client. Is there a way to do this using MSA2007?
Thanks for your help.
If an MSA2003 database running under MSA2007 loses the System.mdw file, it appears to create a problem.
Is there a way to join an existing System.mdw file using MSA 2007? I understand that if you migrate to OFF 2007 it should work. However, if the System.mdw gets lost, MSA 2007 creates a new file Security.mdw. I tried to connect to my old System.mdw using the MSA 20007 Workgroup Admin but it didn't seem like that was an option.
I understand you can reset the path and file using the Registry and while this is OK for my, I would not recommend it to my client. Is there a way to do this using MSA2007?
Thanks for your help.