This is an update to my dilmena... The program was created using MSO2007 (MS Ofice) and down versioned to MSO2003... had some issues so I installed MSA2003 and rebuildt the program... Both the client and I are using MSA 2003, XP Pro SP3...
Both MBDs are running isolated -- not tied to anything outside the machine they are running on as well as have only one user, that of the user... A skeleton MDB (programming only ) was sent the client - one was run and populated on a machine setup on the network, the other not... we both ran the same CSV files to refresh the database in the MDB files, he had different results than me... I had all the information, he did not... Basically the data movement is as follows... Export from 3rd party application as CSV files to user's machine > CSV files linked to MDB tables > core tables in MDB file cleared of records using VBA and SQL (delete queries) > same tables repopulated using using VBA and SQL (append queries) > allocation process to determine percentages for each dept employee has worked in (this sets up a series of tables until the final allocation is built, this table used in the output processing > output from the MDB file in excel format We did find the problem occurs in the allocation process in his copy of the MDB file but not in mine -- as I mentioned, his copy is directly from mine... could compressing this file be the problem? We can not us Windows Office Live for delivery as MDB is a blocked format... Multiple runs of the same database, starting with null population, results in the same discrepencies -- namely the first 3 accounting units are not showing up in his output ( but are in mine ). This pattern is consisitent no matter how many times we perform this test... Client is sending their database copy as well as the CSV files back to me to see if I get the same results on my machine -- will not know the results for another 48 hours... Another issue I am lookding at -- I typically install MSO completely, nothing left to be prompted for later installing. I have had clients install the minimum... Do not know what level they installed and neither does the user... Would it be worth while deinstall and perform a total reinstall? Are there any known issues for doing such a deinstall/reinstall?
