Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Thank you again! I can't tell you how much I and my company appreciate what you've done! I love this place!..."

Geography

Where in the world do Tek-Tips members come from?
SirTECH (TechnicalUser)
12 Sep 06 11:14
I have a user-level secure database that I've split.  However, while users must log into the Front-End, the Back-end can be opened without logging in.
I then used the security wizard to protect the B/E using the same workgroup, which seems to work as far as protecting the B/E from being opened without logging in.
However, when a user logs into the front-end now, a link tables message is shown, and the user cannot perform this function. Permissions are identical on both the F/E and B/E, and each can be opened separately.  The only person that can link is an administrator.  And even though the tables were linked by an Administrator, a different user logging into the same F/E is asked to link, and cannot do so.

In short, is there a way I can use a split database in a multiuser environment where both the F/E and B/E are secure?
segment (ISP)
12 Sep 06 20:42
More information is needed for help on this one. What DB are you using. Oracle, MSSQL, Postgres, MySQL? What server is it running on? Solaris, Windows, Linux, AIX, etc., etc.

perl -e 'print $i=pack(c5,(40*2),sqrt(7600),(unpack(c,Q)-3+1+3+3-7),oct(104),10,oct(101));'

SirTECH (TechnicalUser)
12 Sep 06 21:37
The database is MSACCESS 2000.  The B/E is stored on the network server and the F/E is one each local machine.
spizotfl (MIS)
20 Sep 06 13:39
you might want to post this in one of the access forums

"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close