Solved

Changing MS Access Table Read Only Status

Posted on 2011-03-15
4
358 Views
Last Modified: 2013-11-27
I import a table into my MS Access database from another MS Access database using  the "DoCmd.TransferDatabase" and the table arrives as read-only.  I need a way to programatically change the read-only status either on the way in, or after it arrives.
0
Comment
Question by:tomlewis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 75
ID: 35141426
Inherently, a Table by itself is not Read Only.  

Do you mean if you open the table directly, you cannot edit data ?

mx
0
 

Author Comment

by:tomlewis
ID: 35141561
Jeeeze !!!,  I meant "hidden" - not "read only"!!  Should I start all over with a new question or just continue on with this comment explaining the problem?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 35141651
Continue ....

mx
0
 

Author Closing Comment

by:tomlewis
ID: 35143359
I mistated my needs and have recreated the question.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Database maintenance 36 101
SQL Get Store Procedure Column Name As Row 5 39
Launch Outlook minimized 6 23
SQL Query Across Multiple Tables - Help 5 17
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question