Results 1 to 2 of 2
  1. #1 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020

    Table Design frozen

    I have a tblMembers table. Sometimes if I try and change the name of a field by adding a couple of characters eg,(IDSponserFK to IDSponserFK99, Access locks the name and will not accept the 99 digits, Same for Field TYpe; I can select a different type but it will not accept it. Likewise if I try and change the field property from Integer to Long Integer. Anyone know what's going on????Thanks...

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    is the table linked? if so, you cannot change names from the front end.
    is the table in use? nobody can be in it. close all forms linked to that table too.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. text box shows time frozen intermitantly
    By trevor40 in forum Forms
    Replies: 11
    Last Post: 03-09-2015, 05:37 PM
  2. Split Form frozen after requery
    By casinc815 in forum Forms
    Replies: 4
    Last Post: 04-23-2014, 11:14 AM
  3. Replies: 13
    Last Post: 10-24-2013, 06:11 PM
  4. New design and frozen by confusion
    By grussell in forum Access
    Replies: 7
    Last Post: 09-03-2013, 12:32 PM
  5. Replies: 3
    Last Post: 07-12-2012, 06:36 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums