Solved

Changing MS Access Table Read Only Status

Posted on 2011-03-15
4
355 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
  • 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 - Access MVP) 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now