How to copy Epi-Info Data Entry Tables to another Computer

Replies to This Discussion

Permalink Reply by Buddy on February 2, 2010 at 11:59am

I wanted to add that i get the error "Unable to find codetable school - please locate the correct table"

▶ Reply to This

Permalink Reply by Epi Info Helpdesk on February 2, 2010 at 1:11pm

Greetings,

If I understand correctly, the View and the data table are in separate MDB files? If so, the DATA reference for the View may be pointing to the old folder. For example, if on the original computer you had everything stored in C:\Epi_Info and on the new computer, it's in C:\My Documents, then the View is not going to find the data - it's still looking in C:\Epi_Info. Try making sure the full path of the databases are identical. That is, if you had everything stored in C:\Epi_Info on the first computer, put it in C:\Epi_Info on the second computer.

If this doesn't work (or isn't possible), would you be able to upload the databases so we could take a look at them? If you do, make sure to scrub any identifying information first, such as names, phone numbers and addresses.

▶ Reply to This

Permalink Reply by Buddy on February 2, 2010 at 4:17pm

Hi,

I created this file on one computer, then I wanted to put this data entry program on a network folder because I read that users can simultaneously enter data on one data set (alternatively I'm happy to set it up on 3 individual computers to avoid any sort of network problems). There is some practice data included.

Thanks for your help. Buddy

Attachments:

• H1N1 Consent Form.MDB, 330 KB
• SCHOOL.mdb, 352 KB

▶ Reply to This

Permalink Reply by Epi Info Helpdesk on February 3, 2010 at 8:35am

I would recommend keeping all of the data tables, code tables, and views inside of one MDB file. The reason this is occurring is because the paths stored inside of the MDB are static and do not change when the file is moved. Therefore the links between the 'school' table in SCHOOL.mdb and the code reference in H1N1 Consent Form.MDB have been severed. You can fix them manually using Microsoft Access or Epi Info's VisData, but if the files are moved again the process will have to be repeated. Storing everything in one MDB will avoid this problem.

Multi-user data entry over a network can be accomplished using a single MDB file. The database needs to be placed onto a network drive or network resource. Afterwards, when users go to the Enter Data module, they will expand the 'My Network Places' instead of 'My Documents' or 'Local Disk' and then navigate to the network folder that the file was placed inside of.

▶ Reply to This

Permalink Reply by Buddy on February 3, 2010 at 9:24am

I really appreciate your help - but I don't know how to store the files in one .mdb. When I created the data entry form - I had a seperate file with the list of schools - so when I got to the field where I wanted to use the shool data - I chose 'use existing database'. How do I get the files in one .mdb?

Thanks,
Buddy

▶ Reply to This

Permalink Reply by Epi Info Helpdesk on February 3, 2010 at 12:50pm

I would first delete the 'School' link in the H1N1 mdb file. Then copy the 'School' table from the school mdb file and paste it into the H1N1 mdb file. After this is done, I believe it should work without needing further modification. You will need to use MS Access or Epi Info's VisData module to carry out these operations; they cannot be done in MakeView.

Be sure to backup both of your databases as any mistakes made while using VisData or MS Access cannot be undone.

▶ Reply to This