Update table through ODBC Oracle Server Connection

[Btn]

I've been trying to update a table within the financial system we use by running a number of different queries and vice-versa for a while. I can open the destination table in access 2010 and edit it "on-the-fly" so permissions and connection issues shouldnt be the problem.

I've also managed to get queries to trigger the login username and password, just for it to return an error. For now, I've just ended up deleting the rows from the destination table and cut and pasting from the output table, it works well enough and because we are only talking 300 records it doesnt take long.

However I would really like to automate it.

Basically I have a table in Access which needs to be replicated in the system's database. The source table is TBL-ASL and the destination table (through the ODBC) is ASL_1.

Can anyone offer any advice?

All help appreciated.

Thanks


P.s. pretty much total access beginner, more used to using crystal/excel/vba and bits of SQL, so apologies if I dont make sense.

 

[llkhoutx]

Why not an update query?

 

[Insane_ai]

Check the relationships on the oracle database to ensure you have all foreign keys accounted for. I have found that I have to add the master record for certain inserts before I can add the child data.

Example: ONe table lists the profile numbers. Another holds the profile data. Without the master list of profiles, the profiel data cannot be inserted.