Access 2007 DB Design Changes Getting Lost

[JP]

I've been experiencing a situation in which I make design changes to tables
and then save them, but when I open the table again, the changes are not
there.

For example, I have a table in which I eliminated about 15 fields. In table
design view, I highlighted each field individually and clicked "delete row".
After I was finished, I then hit the save button (the little diskette symbol
on the top). After the cursor came back to the pointer, I then closed the
table and opened it in datasheet view. The fields were still there. When I
went into design view, the fields that I had deleted were back. It takes a
number of tries to get the change to take.

I'm having the same problem in changing the control source for forms.

Anybody know what's going on??? And how do I get around the problem????

 

[Danny J. Lesandrini]

Are they linked tables, and do you get a warning when opening in design
view that changes won't be saved?

Besides that, I've never seen Access fail to save changes to tables.

 

[JP]

No it's not data changes -- it's changes to the db design. No linked tables
involved. It simply won't delete fields that I delete.

--

-------------
Chaos, panic, & disorder - my work here is done.

Are they linked tables, and do you get a warning when opening in design
view that changes won't be saved?

Besides that, I've never seen Access fail to save changes to tables.

 

[Jerry]

I'm having the same problem, I go into design view, make my changes and edit
the form and go back to the form and nothing has changed except for text
changes, that's it. This is truly frustrating.

 

[Danny J. Lesandrini]

Is the MDB file locked? That could happen if the folder it's sitting in is read only
or if the user (you) don't have rights. That's the first thing to check.

Honestly, I've never know forms or tables to refuse to save changes. It's not a
bug in Access ... it's something in your configuration and permissions.