Appending information to ODBC

[kledegang]

Issue: We are trying to remove duplicate information for one fiscal year in an ODBC then import and append the correct information from an Excel spreadsheet.


The process we have followed is

1. Copy Master Access file and paste new file (to test, so we do not loose original data)
2. Rename new file TEST.accdb
3. Create a delete query for Fiscal Year data
4. Delete information for duplicated Fiscal year
5. Import correct Fiscal Year information to a new table from Excel
6. Append table to master table (ODBC)

Questions:

• After being granted permission to delete information, it worked once and now no longer works. When the permissions are reviewed it appears that everything is still granted but the following message is received:

• Why does Access change all copies of SDA, even if filenames are different and in different folders?

• When we append table, why does it duplicate information?

[rpeare]

Are you running the delete query on the same database you originally ran it (when it 'worked')?
If you open the table in your database (I assume you're running it on the ACCESS side) can you open the table in question or do you get an error?
If you are able to open the table in question and you scroll all the way to the bottom on the far left hand margin of the very last record do you see an asterisk (*). If you don't it means the recordset is not updateable and you won't be able to modify any of the data period.

Did you check your ODBC definitions to see if the error message corresponds to the correct ODBC driver?