Urgent - how to disable user from making new queries

  • Thread starter How to disable user making new query
  • Start date

H

How to disable user making new query

Hi,

We're migrating the end-user reporting from MS Access to SQL Server.
However, we face a problem that our users have built a very large no. of
queries/reports on MS Access. We expect it would take months to migrate to
the new platform.

We anticipate at the changeover time, some queries are still not yet
migrated. So, we need to have a method to stop user from buiding new
queries in MS Access but allowing use of existing ones. Now, they are using
ODBC accont to connect from MS Access to Oracle database. And, each time
they run /build a query, they would need to type in the password. We can't do
it by just changing the password as all the queries could not be used anymore.

Any one can help, many thanks !!
 
Ad

Advertisements

G

golfinray

If your database is split, it would make no difference if they create as many
queries, forms, or reports as they need. They would only be making them on
their copy of the front end. You should not be allowing users to create on
your main copy of the database.
 
Ad

Advertisements

A

Armen Stein

Hi,

We're migrating the end-user reporting from MS Access to SQL Server.
However, we face a problem that our users have built a very large no. of
queries/reports on MS Access. We expect it would take months to migrate to
the new platform.

We anticipate at the changeover time, some queries are still not yet
migrated. So, we need to have a method to stop user from buiding new
queries in MS Access but allowing use of existing ones. Now, they are using
ODBC accont to connect from MS Access to Oracle database. And, each time
they run /build a query, they would need to type in the password. We can't do
it by just changing the password as all the queries could not be used anymore.

Any one can help, many thanks !!

Milton gave you a good answer, but to answer your question more
directly:

There's no easy way to do this. Well, you could implement Access user
level security, assuming you're still using the MDB format. But
that's complicated. And the users could always create another new
database and create their queries there.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top