?
Solved

Changing MS Access Table Read Only Status

Posted on 2011-03-15
4
Medium Priority
?
365 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 - Microsoft MVP, Access and Data Platform) earned 2000 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

601 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