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    
post May 21 2020, 02:39 PM

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