Hi All,
I'm designing a database to capture data. I'm going to split my database to front end and back end then put copies of both on CDs to distribute them to my agents (I had to think of using CDs because not all location can access internet). When the CDs are returned I need to collate all gathered data in one Master Database. I tried to use append query to copy data from one database to the master but it didn't work because I have multiple values fields in one of my tables. How can I achieve this ? It's a lot of work if I do it manually copy and paste records.
Any ideas??
I'm designing a database to capture data. I'm going to split my database to front end and back end then put copies of both on CDs to distribute them to my agents (I had to think of using CDs because not all location can access internet). When the CDs are returned I need to collate all gathered data in one Master Database. I tried to use append query to copy data from one database to the master but it didn't work because I have multiple values fields in one of my tables. How can I achieve this ? It's a lot of work if I do it manually copy and paste records.
Any ideas??