Added field to SQL back end - form won't update (1 Viewer)

LisaAtWork

Registered User.
Local time
Today, 09:26
Joined
Oct 1, 2012
Messages
10
Testing on a split database, SQL back end, Access 2007 front. I haven't priviledges on SQL so I had that group add a new field to a table. They did it, and I refreshed the tables - so I can "see" the new field in Access land.

When I try and add the new field to the form in Design Mode, the form prompts for whether or not I want to save the changes (I do!) but if I select Yes nothing happens...at all. The form won't close, task manager doesn't show anything not responding, it just hangs. Only way to the get out is to cancel the update in order to get the form to close.

Ideas?

Lisa
 

boblarson

Smeghead
Local time
Today, 09:26
Joined
Jan 12, 2001
Messages
32,059
What is the form's underlying record source? If it is a SELECT STATEMENT that would need to be updated first.
 

LisaAtWork

Registered User.
Local time
Today, 09:26
Joined
Oct 1, 2012
Messages
10
Holy cow! I forgot to even check that. My thanks.

LIsa
 

Users who are viewing this thread

Top Bottom