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 September 21st, 2004, 09:01 AM
Authorized User
 
Join Date: Sep 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Security = System.mdw ??

Dear Expert,

I have used the workgroup administrator to create security file by assigning name, organization and workgroup id. The security works well when each time I opened my DB and a logon box prompt for input.

The problem is my Access DB allows anyone to copy to another desktop which is no connection to my system.mdw. Then my Access DB will be allowed to open without prompt for user id. As such, it seems all security control has disappeared.

Can you help me to protect my Access DB even it is copied to anywhere it must not be opened without my ids?

Thanks and Best Regards,
martin :D:D:D



 
Old September 21st, 2004, 10:36 AM
joefawcett's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

It shouldn't work like that. As far as I know there is a reference to the security file embedded in the database. If you move the database and the mdw is not in the same (relative location) then you won't be able to use it.

--

Joe
 
Old September 22nd, 2004, 08:57 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Martin

You need to ensure that you've removed all rights from the Admin user.

All copies of system.mdw have the same Admin user set up by default - so if Admin in your database has the right to open the database then the Admin user in all copies of Access can also open it.


Brian Skelton
Braxis Computer Services Ltd.
 
Old September 23rd, 2004, 08:22 AM
Authorized User
 
Join Date: Sep 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Brian/Joe,

Thanks very much. Let me try your solutions and see if I can fix the problem.

Best Regards,
Martin :D:D:D

 
Old November 13th, 2004, 11:37 AM
Authorized User
 
Join Date: Sep 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dear all,

I have compacted and repaired the database and converted it to 2002 format. But I still unable to convert it to MDE and meet same error message. Would you help me a help?

Thanks and Best Regards,
martinaccess :D:D:D


 
Old November 13th, 2004, 11:45 AM
Authorized User
 
Join Date: Sep 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dear all,

My apology please ignore the message I posted in above. Actually it related to another topic I posted regarding unable to converted to MDE. Very confused to MDE and MDW so I made the mistake.

Thanks,
martinaccess







Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting System.Security.SecurityException Sunnys ASP.NET 2.0 Professional 0 March 14th, 2007 04:13 AM
System.Security.SecurityException: Security error coolcatjk Pro VB.NET 2002/2003 4 March 2nd, 2006 06:00 PM
System.Security problem jdang67 General .NET 1 November 14th, 2005 01:24 PM
System.Security.SecurityException davepruce ADO.NET 1 May 10th, 2005 11:20 AM
system.mdw problem stoneman Access 7 September 14th, 2004 09:46 AM





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