Solved

Developer 2000 query

Posted on 2000-02-14
4
197 Views
Last Modified: 2011-10-03
I am deploying an Access 2000 package using developer 2000, some of the users have access 2000 and some don't. The users without Access 2000 on their machines can't edit the design of the database but the ones with 2000 can. How do I stop this?

Thanks in advance.
0
Comment
Question by:reido2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:paasky
ID: 2519092
Hello reido2,

Access RT doesn't have capability to change Access database, normal version of Access doesn't prevent modifying mdb file if the security options are not set.

1. Set the security options that users cannot change objects.
2. Compile your front-end database (user interface) from .mdb to .mde. Forms, Reports and code cannot be altered in MDE files.
3. If you don't want users to open server database, rename server database (where the tables are located) to .dat that it cannot be opened with Access. You can use linked tables.

Regards,
Paasky
0
 

Author Comment

by:reido2
ID: 2523134
I wonder why the runtime install lets users with Access2000 to go into design mode (albeit if security is not set).

Doesn't make sense to me.
0
 
LVL 10

Accepted Solution

by:
paasky earned 50 total points
ID: 2524043
I don't know for sure if the following works same way with Access 2000 RT and Access 97 RT installation but I assume they don't different very much.

Here's how the Access 97 RT installation works: if the user already have full version (= not runtime) of Access installed in his/her computer, the RT installation doesn't add (or replace) RT version into the machine. So, they both cannot be at same time at the same computer. When the user clicks (opens) the MDB or MDE file its opened with the version of Access that is first installed.

I've heard rumors that there are very minor differences between these two versions (license key, some dll has a different name).

As I recommendent earlier, you could compile your databases to MDE's, you could also set database window hidden at startup and disable Access special keys (for eg. F11) and built-in toolbars and other starting options you decide. You can define these settings choosing Tools - Startup... from Windows menu.

That's what I generally do and I don't have to worry if the user has full version or runtime version.

Hope this helps,
Paasky
0
 

Author Comment

by:reido2
ID: 2526280
Your right, I was thinking that if I disabled the menus etc then I wouldn't be able to package the database but all I have to do is do both at the same time.

Thanks for the tips.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access Weekly query 11 42
MS ACCESS 2010 Clear Form Button 4 62
Slow running query - help 16 34
MS Access Why is my list box VBA code seem to be one number off? 2 25
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question