Search results

Thanks for the reply Chris. If you saw my database you would be more than 'slightly worried' about non-normalised data. Absolutely horrified most likely. I am going to go back to the Bible and read up on data normalisation. I confess I am a database dilletante. In this particular table I have...

G'day, I am using Access 2007. The following code works to create a new column in the table called 'Matrix': DoCmd.RunSQL "ALTER TABLE Matrix ADD COLUMN [" & newjob & "] INTEGER;" However, the new column is not visible in the Table 'Matrix', even if I close and reopen the database. Yet I know...

Mr. Fenton, I am honoured sir. Thank you for your reply. I managed to get it working by eliminating the loop through all the 'non-system' tables, instead making specific reference to those unrelated tables which I wanted fully replicated in the partials. I spent a lot of time thinking about the...

During the process of creating a partial replica using the Partial Replica Wizard, a dialog box is displayed which lists tables that my filter does not directly apply to. As stated in the dialog box, "tables that aren't bold aren't related to the filtered table with referential integrity...