Hi all,
I know that this subject has been beat to death but i need some help here. First when you split the db into FE and BE do you do this after you secure the database? Do the permissions flow over after you split it. Cuz i split my db first and then set the permissions on both files. Now i'm having problems with access rights. A majority of the data retrieval is through VBA and SQL statements, I've set the "WITH OWNERACCESS OPTION" but i get the "No permissions on table ****" error. But I've experimented with queries objects which use the same SQL statement and those work fine. Is there some other settings that need to be set for the "WITH OWNERACCESS OPTION" to work in the VBA environment?
Thanks in advace,
I know that this subject has been beat to death but i need some help here. First when you split the db into FE and BE do you do this after you secure the database? Do the permissions flow over after you split it. Cuz i split my db first and then set the permissions on both files. Now i'm having problems with access rights. A majority of the data retrieval is through VBA and SQL statements, I've set the "WITH OWNERACCESS OPTION" but i get the "No permissions on table ****" error. But I've experimented with queries objects which use the same SQL statement and those work fine. Is there some other settings that need to be set for the "WITH OWNERACCESS OPTION" to work in the VBA environment?
Thanks in advace,