locked
Urgent - How to stop user from buiding new queries in MS Access but allowing use of existing ones RRS feed

  • Question

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

    Monday, November 23, 2009 2:44 AM

Answers

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

    This forum is for Windows Home Server.  You should post your question in the Office newsgroups.
    Monday, November 23, 2009 5:48 AM
    Moderator