Is there a way to restrict direct write access to the DB in Microsoft Access 2007?

Posted by JW on Super User See other posts from Super User or by JW
Published on 2009-10-26T22:06:44Z Indexed on 2010/05/03 18:28 UTC
Read the original article Hit count: 405

Filed under:

microsoft-access

|

microsoft-access-2007

|

database

|

permissions

|

sql-server

I'd like to set up an Access (2007) project that contains queries on a DB (actually in MS SQL Server 2005), but I do not want to allow any direct writing to the DB. (Basically, just read-only.)

Is this possible?

Thanks in advance!

© Super User or respective owner

Related posts about microsoft-access

T-SQL Equivalents for Microsoft Access VBA Functions

as seen on Internet.com - Search for 'Internet.com'
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL. >>> More
Microsoft Access: Customize Forms and Reports

as seen on Internet.com - Search for 'Internet.com'
Our Microsoft application guru Helen Bradley explains how to make Access database forms and reports more functional and attractive. >>> More
Microsoft Access 2007 Certification

as seen on Internet.com - Search for 'Internet.com'
Certification doesn't make one an IT super hero but it's something every developer should consider. Some might argue that there aren't any certifications for Microsoft Access application developers and they would be correct, however, the Microsoft Access 2007 Application Specialist (MCAS) exam might… >>> More
Bulk-Batch Email From Microsoft Access

as seen on Internet.com - Search for 'Internet.com'
If your users collect email addresses in a database, odds are before long, someone's going to get it into their head to send out an email "blast" or batch. There are several approaches, but what you really need is an engine to send individualized emails, one at a time... >>> More
SharePoint and Microsoft Access - Getting Motivated

as seen on Internet.com - Search for 'Internet.com'
Its time that Access specialists discover just how much Access has in common with Microsoft SharePoint. Read on to learn more. >>> More

Related posts about microsoft-access-2007

Microsoft Access 2007 Certification

as seen on Internet.com - Search for 'Internet.com'
Certification doesn't make one an IT super hero but it's something every developer should consider. Some might argue that there aren't any certifications for Microsoft Access application developers and they would be correct, however, the Microsoft Access 2007 Application Specialist (MCAS) exam might… >>> More
Is there a way to restrict direct write access to the DB in Microsoft Access 2007?

as seen on Super User - Search for 'Super User'
I'd like to set up an Access (2007) project that contains queries on a DB (actually in MS SQL Server 2005), but I do not want to allow any direct writing to the DB. (Basically, just read-only.) Is this possible? Thanks in advance! >>> More
Microsoft Access 2007 books

as seen on Super User - Search for 'Super User'
I would like to ask your suggestions, if you know any good books for Microsoft Access 2007, including the migration from old versions to new versions. >>> More
Microsoft Access 2007: Export to multiple xml files

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table in my access database and I want to export each record to a single xml file. How can I achieve this?The only option I found was exporting the whole table to a single xml file. >>> More
Help with Ms Access 2007 Combo boxes

as seen on Super User - Search for 'Super User'
What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form with a query. Here's a example of my scenario: cmbCarMake Behavior: User starts typing, and list… >>> More