Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to make changes to table structures and forms on a MS Access database using UA Business Software 7.0

The problem is that UA hides everything and everything is locked.. It doesn't even look like Access anymore! Has anyone had this problem before? Has anyone found good documentation about this?

UPDATE: Another try, I double clicked on a particular .mdb file which I want to modify but I get the following error message : "Microsoft Access cannot open this file. This file is located outsite your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessiblenetwork location."

Problem is, the file is already on my local machine. What do I do now?

share|improve this question
    
Why do you need to make these modifications? –  David W. Fenton Jul 24 '11 at 20:30
    
@David W. Fenton : There are multiple reasons, for example: Remove some table fields we don't use so they don't clutter, rename table fields so they represent what they actually do, change the defaults for certain fields to accelerate insertions, add new tables to create many-to-many relashionships, add new fields to certain tables to add information that we need, etc, etc etc. Why do you ask? –  Shawn Jul 24 '11 at 21:03
    
Why do you think you should be able to do this with somebody's proprietary software product? –  David W. Fenton Jul 27 '11 at 0:08
    
@David W. Fenton : Because it was sold (for a hefty price) as a generic accounting application useful to many different enterprises in many different areas of business. Therefore I assumed it offered a minimal amount of flexibility to its users. Again, why do you ask? –  Shawn Jul 27 '11 at 18:54
    
You should read the licensing documents. I doubt you have any legal rights to do what you're attempting to do. If they didn't promise you this flexibility, I have no idea why you'd assume it. –  David W. Fenton Jul 28 '11 at 21:26

1 Answer 1

Does this thread apply : Stupid 'Security' Problem - MS Access in WinXP SP2 ?

To summarize, it supplies two methods :

  1. Right-click the MDB and select Properties followed by Unblock then Apply
  2. In Internet Explorer, menu Tools / Internet Options / Security tab / Local Intranet / Sites, uncheck Automatically detect intranet networks.
share|improve this answer
    
None of the above work I'm afraid. –  Shawn Aug 12 '11 at 18:27
    
Then I can't help you. I will delete my answer if you want me to. –  harrymc Aug 12 '11 at 20:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.