Urgent - how to disable user from making new queries

[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 !!

 

[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.

 

[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