I created a database that has user-level security, and 3 levels of users. Me, w/ all access. Read Only. Add/Edit Data users.
I've created a separate database w/o security, for another function, but need to link to one of the tables from the first database, and the security is giving me headaches.
I get this message, and don't know how to get beyond it when establishing security for the database.
(((You do not have the necessary permissions to use the “Database Name/Location” object. Have your system administrator or the person who created this object establish the appropriate permissions for you.)))
I already have ALL permissions for the one w/ security, and it shows my logon id (from the first database) as the creator of the 2nd database, but it still won't let me link the tables.
I've created a separate database w/o security, for another function, but need to link to one of the tables from the first database, and the security is giving me headaches.
I get this message, and don't know how to get beyond it when establishing security for the database.
(((You do not have the necessary permissions to use the “Database Name/Location” object. Have your system administrator or the person who created this object establish the appropriate permissions for you.)))
I already have ALL permissions for the one w/ security, and it shows my logon id (from the first database) as the creator of the 2nd database, but it still won't let me link the tables.
