Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 March 14th, 2006, 06:00 PM
Authorized User
 
Join Date: Apr 2004
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default How do I stop others importing tables from my DB

How can I stop other people from importing tables and queries from my Access database? I stopped them from importing other stuff such as my forms, reports, etc... by making an mde file but how do I stop them from importing my tables with out using the standard Microsoft Password system?

 
Old March 14th, 2006, 07:04 PM
Authorized User
 
Join Date: Mar 2006
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Manage user rights to tables

 
Old March 14th, 2006, 10:35 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

The easiest way, if you don't want to get involved with user-level security or password protection, is to hide your objects. Right click a table or query, select properties, check the "Hidden" attribute. To show hidden objects in your db, select Tools --> Options and check the "Hidden Objects" checkbox in the "Show" section. Hidden objects won't appear in the Import or Linking dialogs, though they can still accessed via code. For example, one could still use ADOX or DAO to retrieve a catalog of table schema information that would list your hidden tables as well. But hiding objects provides some modicum of security. To really lock down your data objects though, you'd need to follow peko's suggestion and implement user-level security.

Bob

 
Old March 15th, 2006, 10:29 AM
Authorized User
 
Join Date: Apr 2004
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Bob and Peko,
I tried hiding my tables and selecting the tools/options and unchecking the hidden objects checkbox and when I tried importing tables that were hidden from a new database I couldn't see those tables. So then I tried going back to the tools/options and rechecking the hidden objects checkbox from the new database and tried to import the tables again and I was able to see them. So the point is while my computer might have the hidden objects unchecked someone else's computer might have hidden objects checked and they will be able to see hidden objects from anyone else database. So I guess I will have to try the user-level security system built into Access. I have been so reluctant to use it because anyone can go buy a password cracker from the internet and break into my database.

 
Old March 15th, 2006, 12:30 PM
Authorized User
 
Join Date: Mar 2006
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Then use exotic password and administrator name (e.g. UserName: chupachabras,Pwd: enD57ad66SDdew5A).
It kick off lot of password crackers (because those working







Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing multiple text files to sql server db tammyk SQL Server DTS 1 April 25th, 2008 12:07 AM
problem with importing excel to db -ssis collie SQL Server 2005 2 December 1st, 2007 07:07 PM
Getting list of tables using DB name shazia1 VS.NET 2002/2003 2 July 6th, 2005 12:17 PM
Importing Multiple files in Multiple tables Versi Suomi Access 6 June 1st, 2005 08:47 AM





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