It's very difficult for us to see your SQL or your table or constraints or fields or data types or relationships or anything else since we are not sitting at your computer.
It is good to hear that your attempting to normalize your data. This is typically a very good investment.
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: wgriffin48@mchsi.com
Date: Wed, 21 Sep 2011 22:21:36 +0000
Subject: [MS_AccessPros] Query Won't append new field
Hi folks, Been a while.
I have run into a problem restructuring a table, adding a new field to help normalize data, substituting a text field with an ID field from a new table (containing the text field and an ID field). I created a blank number field in the table to be modified for the ID field that will replace the text field (to be removed later). I ran an append query and it works fine in "view" mode but when I run it I get an error message telling me it found "0" issues but it won't write any changes to the table? (There are 27422 records in this table). Is there a way to make this work?
Walter Griffin
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Tidak ada komentar:
Posting Komentar