Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 16th, 2005, 12:56 PM
Registered User
 
Join Date: Jul 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Backend security

I have split a A2003 database .fe & .be have run the security wizard to secure the front end but now need to secure the backend - anyone have any ideas how to do so - fe on local machines - be on server
 
Old August 16th, 2005, 01:57 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

One of the pitfalls of using Access back end. I don't think you can secure it. I will watch for posts since I have been unable to do this. I am upsizing right now in part due to this issue.

mmcdonal
 
Old August 16th, 2005, 04:06 PM
Registered User
 
Join Date: Jul 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by mmcdonal
 One of the pitfalls of using Access back end. I don't think you can secure it. I will watch for posts since I have been unable to do this. I am upsizing right now in part due to this issue.

mmcdonal
I read somewhere but forget where that if opening the backend you can modify the backends usergroups to match those used by the front end. i tried using a single user password to secure the backend that matched mine in the front end but that only prevented me from accessing the backend tables ! will keep looking
 
Old August 22nd, 2005, 02:42 AM
Friend of Wrox
 
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Another option is to use a databse password on the backend database and not use a work group.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Code Access Security & Role Based Security robzyc C# 6 April 11th, 2008 02:31 AM
Path to database backend Clive Astley Beginning VB 6 3 January 12th, 2007 01:29 AM
Backend Issues Aaron Edwards Access 3 August 26th, 2005 10:50 PM
Linking to backend Clive Astley Access VBA 6 April 1st, 2004 01:35 PM
Backend as a constant Steven Access 1 June 29th, 2003 11:49 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.