Software driving linking in a secured FE-BE database does not work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a user account Admin which is not part of any group. It has the
Open/Run permission in BE and FE and all permission on New Tables/Queries in
FE. I run a program (as recommended in SECFAQ.doc) which:
1. Delete the link from TableDefs
2. Create the new table definition which corresponds to the deleted link.
3. Add this table definition to TableDefs.

As a result, all links are removed and the new ones not created. At the same
time, if I place this account in the Admins group (which has no permissions
to any object in FE and BE) the program works fine.

What can be the reason? Would greatly appreciate any input.
 
1. It is unlikely that your Admin user is not a member of any groups.
Try this to see:

dim g as group
for each g in dbengine(0).users("Admin").groups
msgbox g.name
next

2. It is also unlikely that your Admins group has no permissions to
anything! The Admins group of the workgroup file which was used to
create a database, has irrevocable permissions to all the objects in
that database, whether the user interface says so or not.

HTH,
TC
 
Thanks TC for reply. Let me re-define my question: what permissions should a
user account have on BE and FE in order to run a linking procedure utilizing
the TableDefs connect property? My understanding was that it should have
Open/Run permission on BE and no permissions on tables in FE besides having
all permissions on New Tables/Queries. But it does not work. The only way it
works is when I place that account in the Admins group. As a result this user
become a powerful user and makes all permission settings for that account
worthless
 
Len, for the next few days I am on a REALLY CRAPPY public pc where it
is impossible to research any answers that I can not give off the top
of my head. And I can't remember, off the top of my head, the
permissions required to create or refresh a table link. It might be in
the Access Security FAQ, often referenced in this newsgriyup. Or,
google this or other Axccess groups for "refreshlink(s)" - that might
find it for you.

HTH,
TC
 
I am following this document but no success. In particular, I am applying
recommendations in the section 14.3 “No Permissions necessary - Using the
..Connect property to relink tablesâ€. One statement in this section is not
quite clear to me and I would be interested to receive you opinion on it. The
statement says

"A user should be able to run the following code, as long as the user has
full permissions in the destination database and Open/Run permissions on the
source database-no permissions at all are necessary on the source tables."

What does the expression "full permissions in the destination database
means"? That the user should have Open/Run, Open Exclusive and Administer
permissions on the Database object or something else?

Thank you.
 
Back
Top