I have searched the forum but I can not compose the correct question.
I have a database containing 11,000 customer records and about 40megs in size. It is split in two FE and BE. Each user has their own front end. There are about 20 users in the main office and 10 off site.
A group of these users are off site during working hours. I would like them to have access to a copy of the database so that they can search for the current customer and update the record. There is no possibility of them having live access to the main database as they are out in the countryside with no internet access.
Currently for data input they fill in a excel spreadsheet and eventually when they get to the local office, email it to the data administrator who uploads it to the database. This is very prone to misspellings.
What I would like is for this team of outworkers to have their own copy of the database on their laptop. They can search it and update it and then perhaps once a week upload all the changes to the main database. During this time any changes to the main database would be transferred to the laptops.
What would be the best way of doing this? It has to be very simple for the out workers who are not very computer literate and I am not an expert in Access.
I have a database containing 11,000 customer records and about 40megs in size. It is split in two FE and BE. Each user has their own front end. There are about 20 users in the main office and 10 off site.
A group of these users are off site during working hours. I would like them to have access to a copy of the database so that they can search for the current customer and update the record. There is no possibility of them having live access to the main database as they are out in the countryside with no internet access.
Currently for data input they fill in a excel spreadsheet and eventually when they get to the local office, email it to the data administrator who uploads it to the database. This is very prone to misspellings.
What I would like is for this team of outworkers to have their own copy of the database on their laptop. They can search it and update it and then perhaps once a week upload all the changes to the main database. During this time any changes to the main database would be transferred to the laptops.
What would be the best way of doing this? It has to be very simple for the out workers who are not very computer literate and I am not an expert in Access.