Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 07-28-2006, 01:34 AM   #1
Keith Nichols
Registered User
Join Date: Jan 2006
Location: Doha by the Sea & Sunny Perth
Posts: 431
Thanks: 0
Thanked 5 Times in 5 Posts
Keith Nichols is an unknown quantity at this point
Odd front end back end security problem

Hi Folks,

I decided to reset my security as my DB wasn't secure. Following advice from GHudson on a different thread, I combined the front end and back end into one db on my PC. I then went through the routine of runing the securitywizard, creating a blank db and importing all the objects, setting the Admin Password etc.

Once that was all done, I copied the database to the back end location, deleted the appropriate objects from the front and back and linked the tables.

The wif is in the same directory as the front end database and is distributed to all users.

Here's what strikes me as odd. If I click on the back end in explorer, I get the "You do not have permission" messge and cannot open it, but if I try the same thing with the front end, it opens fine with no password.

I have checked that I am joined to the default wif, and the front end admin password is set by logging in as admin so I am at a bit of a loss to understand what I have missed. Any ideas?: confused:


A2003, Win XP, Guilty as charged.
Keith Nichols is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Front End / Back End split - where do you keep your tables? Keith Nichols Theory and practice of database design 9 11-29-2006 12:27 PM
BLOBS - Front end or Back end? statsman General 1 04-18-2006 07:58 AM
compact and repair back end db johnqzsmith Modules & VBA 0 03-20-2006 09:54 PM
Back End Security adamburton General 5 01-31-2006 09:06 AM
Compacting Split Database - Front / Back End (Access 97) Cosmos75 General 5 05-28-2003 10:13 AM

All times are GMT -8. The time now is 10:19 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World