By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Lock the DB but not the Queries?

P: n/a
RLN
Re: Access 2003

I know an .MDE will lock the users out of the code, but it still gives
users access to the DB container where they can still go into table and
change data.

Is it possible to lock an Access database, where changes cannot be made
to the tables, but queries can still be adjusted?

Thanx.......


*** Sent via Developersdex http://www.developersdex.com ***
Jul 25 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Trying to use a File based RDBMS (Access) with the same expectations you
have from a server based RDBMS (sql Server) can be problematic. There
is a little bit of overlap between Access and Sql server as they both
use sql for manipulating data (although Jet sql (Access Sql) is
significantly more limited than Transact sql (sql server sql)) and you
can have a backend and front end and theoretically - Access can support
multiple users simultaneouly like a server. The problem is that you
don't have the same level of performance/reliability/security control
with Access that you do with Sql Server when using Access in this
manner.

Access has some builtin security but very easy to crack - well Access is
a File based RDBMS - great for single user operations. When you will be
dealing with multiple users for production operations - it is time to
migrate to a server based system.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Jul 25 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.