UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Prevent Column Changes In Shared Table?, Access 2007    
 
   
dsabol2000
post May 21 2020, 02:39 PM
Post#1



Posts: 220
Joined: 28-February 05
From: Pennsylvania


I have a table that is used by a few individuals. Initially I had built a form for everyone to use but they had problems with it so I just went ahead and let people use the table. Its a somewhat informal database, but I still don't want people messing with the table layout too much. Recently I took a week off and when I came back I found the columns all moved around, and other issues. I have managed to lock down all of the other stuff but wondered if there is a way to prevent columns from being rearranged in the table.

I found the option "Enable design changes for tables in Datasheet view" and I unchecked that. It doesn't prevent dragging of columns though. Am I out of luck on that one? Considering revisiting the form option...
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    6th July 2020 - 07:13 PM