B
Bill Sturdevant
I have a front end that links to a backend DB. Both
pieces are MS Access 2K.
Upon opening the front end I run an autoExec to make sure
my linked DB is available and if not I ask the user to
point to a proper DB. The logic then reads a table housed
in the front end that contains a list of tables that
should be in the back end, and re-establishes the links.
Everything had been working fine, I was creating a .mde
file and passing it to users who were successfully using
it.
I had to go in to make a change to some unrelated logic
recently, and when I now pass out the .mde and the user
opens it and the expected database is not where it should
be, the logic tries to read a table housed in the front
end to read the table names and locate and relink them, I
get an error 3112 "Record(s) cannot be read; no read
permission on "name of table".
I found the document in the MS Knowledge base that
addresses this problem, but no matter how many variations
of setting the permissions to "Owner's", I still get the
same error. I have tried using an intermediary query with
the owners pernmissions set. I have tried creating a SQL
string with the "WITH OWNERACCESS OPTION" phrase in the
SQL. I have tried reading the database directly.
IT ALL WORKS IN .MDB FORM BUT WHEN I CREATE A .MDE FILE IT
ALL FAILS!
What am I missing? This did not use to happen. The only
things I can think of that I changed is going to Jet
Engine Service Pack 4 and MDAC 2.8.
pieces are MS Access 2K.
Upon opening the front end I run an autoExec to make sure
my linked DB is available and if not I ask the user to
point to a proper DB. The logic then reads a table housed
in the front end that contains a list of tables that
should be in the back end, and re-establishes the links.
Everything had been working fine, I was creating a .mde
file and passing it to users who were successfully using
it.
I had to go in to make a change to some unrelated logic
recently, and when I now pass out the .mde and the user
opens it and the expected database is not where it should
be, the logic tries to read a table housed in the front
end to read the table names and locate and relink them, I
get an error 3112 "Record(s) cannot be read; no read
permission on "name of table".
I found the document in the MS Knowledge base that
addresses this problem, but no matter how many variations
of setting the permissions to "Owner's", I still get the
same error. I have tried using an intermediary query with
the owners pernmissions set. I have tried creating a SQL
string with the "WITH OWNERACCESS OPTION" phrase in the
SQL. I have tried reading the database directly.
IT ALL WORKS IN .MDB FORM BUT WHEN I CREATE A .MDE FILE IT
ALL FAILS!
What am I missing? This did not use to happen. The only
things I can think of that I changed is going to Jet
Engine Service Pack 4 and MDAC 2.8.