We are working to install both Advantage Data Architect and Osteoware on a single server which we access via remote desktop. We have not had any trouble installing Osteoware, but when I installed ADA, only one user (me) was able to edit the Osteoware CaseListProtInvt table. I cannot figure out how to give someone else the proper rights to be able to edit the table. So we tried another tack - to deinstall everything and have another user install both programs, to see if it would recognize her as the system administrator for both. Now she cannot install ADA - we keep getting a rights error (error #1925) when she tries. She is a system administrator on the server.
Has anyone had this sort of issue installing ADA before? Is there a trick to giving rights/permissions for another user to edit the tables? Thank you for any suggestions!