I.T. Discussion Community!
-Collapse +Expand
Search Access Group:

-Collapse +Expand Access To/From
-Collapse +Expand Access Store

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

Secured database - make changes

Secured database - make changes in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: Secured   database   changes   Secured database   Secured database make  
Beaverton OR USA
Friends, here is the story: my client bought a commercial program from
a guy (sort of a program, it's written in macros), Access97. My client
wants to do enhancements, new reprots, etc. Thing is, the objects are
protected. (Not passworded data, and I have the .mdb, but design-
protected objects) I need to be able to circumvent that if I am to help

Oh, and the vendor has apparently been sent to a dilithium mine
somewhere off-planet. How do I figure out what user or usergroup has
design-change or design-read rights on the objects? Of course, without them I cannot simply import the objects into a blank database.

 Posted 17 years ago (Thread Starter)
Comment Quote
About philmarcus -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #9260, 3 replies
Thread Started 3/17/2003 5:23:00 AM
View Counter=2250
Last Reply Posted 6/11/2008 9:34:50 AM)
Location=Beaverton OR USA 
Joined=20 years ago   MB Posts=16  
Most Recent Post
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

For those lurking, you might try the following software...

Access Recovery Module - http://www.passwordservice.com/access/index.htm

Mike Prestwood
Prestwood IT Solutions

 Posted 12 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #12855 (Level 1.1)  Reply to 9260
Thread Started 6/11/2008 9:34:50 AM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=20 years ago   MB Posts=1410   KB Posts=1805   KB Comments=69   BLOG, Topics=4  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

Boy, there seem to be a lot of "programmers" that have relocated to that dilithium mine.  It doesnt seem like 97 was that long ago but I have been through several memory upgrades since then.  When you attempt to modify the design is a password requested?  If you do not have the password you will probably have to resort to a thrid party password retrieval tool to retrieve the information. 

I do seem to recall that if you rename the access database the vb project name does not remain insync.  I think that this might cause the code to be somewhat protected.   You might want to check the project name under Tools | Options | Advanced tab.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions

 Posted 12 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #12413 (Level 1.2)  Reply to 9260
Reply Posted 1/11/2008 10:47:00 AM
Location=Home office in Fresno, CA. 
Joined=18 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
Wes Peterson
Prestwood IT
Prestwood IT office in Citrus Heights, CA


It sounds like your client is experiencing a severe case of Technology Debt. I wrote a brief article about that, and it may help your client understand the options.

First, let's look at the problems, and then consider some solution approaches:

The first thing I should confess is that I'm not an Access application developer. I've developed many applications that use the database under the covers of Access (Microsoft JET, .mdb format), but always with a more powerful development tool, like Borland Delphi.

The reason? The Access database is great, but as a development environment, I always found Access too restrictive. Sure, the easy stuff is easy. But once requirements - especially in the user interface department - move away from the trivial, you have to jump through hoops in Access and VBA to accomplish what is virtual child's play in Delphi.

What you may be up against is an application "compiled" by the developer version of Access. Without the developer version, source code in an Access application is available to everybody - a circumstance that makes it hard for developers to make money; it's simply too easy to pirate.

Now, there may be a way around that. If there is, I don't know about it. But before you go down that road, consider whether continuing enhancement of the product, in Access, is a smart move in terms of Technology Debt.

How many data entry forms are in the application? Do any look complex? How about reports?

If you can get at the database itself, and see all the table and view definitions, you might be surprised how quickly you could reproduce forms and reports in a newer, better development tool; something like Visual Studio .NET, or Delphi.

Another thing to consider is migrating the database itself to something more contemporary. Access databases are easily "upsized" to Microsoft's free SQL Server 2005 Express, or full-blown SQL Server 2005.

The work itself is probably not all that hard. The hardest part may be in helping your client understand that he is simply making an unavoidable payment on longstanding technology debt - and that your solution will both pay off that debt, and keep its growth down to a minimum. And, if he insists on keeping the application - all of it - in Access - he is choosing to postpone the payment, and continue to accrue interest.

Wes Peterson
Senior Software Engineer
Prestwood IT Solutions

 Posted 12 years ago
Comment Quote
About Wes Peterson -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Wes Peterson

Wes Peterson is a Senior Programmer Analyst with Prestwood IT Solutions where he develops custom Windows software and custom websites using .Net and Delphi. When Wes is not coding for clients, he participates in this online community. Prior to his 10-year love-affair with Delphi, he worked with several other tools and databases. Currently he specializes in VS.Net using C# and VB.Net. To Wes, the .NET revolution is as exciting as the birth of Delphi.

Post ID #12411 (Level 1.3)  Reply to 9260
Reply Posted 1/10/2008 9:13:40 PM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=16 years ago   MB Posts=158   KB Posts=163   KB Comments=34   BLOG, Topics=20  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P184A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #9260 Counter
Since 4/2/2008

Follow PrestwoodBoards on: 

©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech