We use MS Access as our main database tool but use Cardbox on the web. Does anyone know of a way of automating the transfer of data backwards and forwards between the two products? At the moment I use the Server Download to take data from the Web copy, export it to a csv file and update Access, but then I have to delete all records in the server file and update the entire file from Access to get the updated data back on the web. Adding new records, deleting records, editing and updating of record data is done is Access and only 4 or 5 fields are changed in the Cardbox version, so they need to be synchronised on a daily basis. Any help greatly appreciated...
