If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 DB Design Changes Getting Lost
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???? ------------- Chaos, panic, & disorder - my work here is done. |
#2
|
|||
|
|||
Access 2007 DB Design Changes Getting Lost
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. -- Danny J. Lesandrini www.amazecreations.com "JP" wrote in ... 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???? ------------- Chaos, panic, & disorder - my work here is done. |
#3
|
|||
|
|||
Access 2007 DB Design Changes Getting Lost
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. "Danny J. Lesandrini" wrote in message ... 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. -- Danny J. Lesandrini www.amazecreations.com "JP" wrote in ... 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???? ------------- Chaos, panic, & disorder - my work here is done. |
#4
|
|||
|
|||
Same here
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. |
#5
|
|||
|
|||
Same here
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. -- Danny J. Lesandrini www.amazecreations.com "Jerry" wrote ... 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. |
Thread Tools | |
Display Modes | |
|
|