Unable to make DB changes connecting via ODBC

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I am connecting to an external data source using
Access2000 and linking to the externa datab base tables.
I can view the tables but when I try to make a change to
the data in the table it does not save or "commit" the
change. I connected to a similar data source on a
different machine than the one above using Access2003
installed on a different workstation than the Access2000
machine. Is there a setting in Access I need to make in
order for my changes to be committed to the external data
source?
 
Hi, Phil.
There are quite a few things that this could be. It may or may not be
related to MS Access.

(1) What flavour is your external database?
(2) What driver are you using to connect to your external DB from
Access 2000?
(3) Does the id you are using to log in to the external DB have the
permissions needed to add/delete/update records?
(4) Does the table have a primary key set up on the database side? If
so, Access should inherit that when you set up your link. If not, you
have to assign one manually or you will not be able to perform any
updates to that linked table through Access.

Depending on your answers, the solution could be as simple as changing
the permissions on the tables in your database, relinking the table or
using a different ODBC driver or driver setting. It could also be
something like a compatibility issue with the Jet Engine in Access and
your ODBC driver, which is something I encountered recently. That one
required an upgrade to 2003.

Cheers!
TGG
*************************************************************

I am connecting to an external data source using Access2000 and
linking to the externa datab base tables. I can view the tables but
when I try to make a change to the data in the table it does not save
or "commit" the change. I connected to a similar data source on a
different machine than the one above using Access2003 installed on a
different workstation than the Access2000 machine. Is there a setting
in Access I need to make in order for my changes to be committed to
the external data source?
 
Back
Top