Page 1 of 1
Help with my problem please
Posted: Thu May 06, 2010 8:35 pm
by John F
MDB Merge will not run in Access 2003 for me but will in Access 2007. However, I get an error message on clicking on Create Database List "You entered an expression that has an invalid reference to the property FileSearch" I have saved my 2 databases in various formats with no joy. Any ideas please? Thank you.
John
Posted: Fri May 07, 2010 12:54 pm
by valentina
i have 463 errors on my computer.how to solved this?
Posted: Fri May 07, 2010 8:41 pm
by John F
What have your 463 errors to do with MDB merge?
Posted: Sat May 08, 2010 8:39 am
by DV
John F - try the 0.6 update on the sticky thread
Valentina - is this about Simple MDB Merge or Duplicate Cleaner?
Posted: Sat May 08, 2010 3:02 pm
by John F
Many thanks for the update DV. After a little effort I managed to merge 2 databases.
However, I find that although all the data is in the Table only the original data appears in a Form. If I create a new form then all data shows. How do I show all the new data in the old form without creating a new form?
Many thanks for your help over this.
John
Posted: Sat May 08, 2010 4:10 pm
by John F
DV. I think I have solved it. I need to link my Form to the new merged Table which then shows all the data.
Any further comments appreciated. Thanks again.
John
Posted: Sat May 08, 2010 7:15 pm
by John F
Further findings.
I have Access 2002 and MS Office Pro 2007.
When I load Simple MDB Merge into Office Pro 2007, none of the buttons work but they do in Access 2002 so I used that to merge 2 databases. Other than that problem it seems to be doing what I want. Thanks
John