Hi, Well, there are few custom settings like date format which can make this happen. The date format is taken based on what is set in the control panel and also I would suggest you to look into the specification part while linking the CSV files. That can also impact the program to behave in a different way. I would also recommend you to capture a log, simple one. The number of rows getting affected after each action queries. This comes really handy in reconciling the database. Best regards...
--- On Wed, 3/11/09, Garrett O'Brien <[email protected]> wrote: From: Garrett O'Brien <[email protected]> Subject: [ms_access] Re: Same programs, different results... UPDATE To: [email protected] Date: Wednesday, March 11, 2009, 10:30 AM 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 ? [Non-text portions of this message have been removed]
