Access and SQL ODBC problem
- From: Xavier <Xavier@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 25 Jul 2005 08:46:08 -0700
We have a web based application with SQL 2000 as a data backbone
I have 1 user who uses Access 2002 using ODBC to run custom reports
and to fix some minor data entry errors caused by other users.
I have runned into a strange connectivity problem and that is.
Sometimes I open the access database and it will only let me read
the tables in SQL it will not let me update any information or add
a new record (example adding a new customer) I remove the table
and relink it and the problem goes away, it will work fine for days even
weeks then suddenly have the same issue again, I remove and relink
and the problem goes away.
What can cause this, or is this normal behavior.
Thanks
Xavier
.
- Prev by Date: SQLColumns hangs on DB link synonym in Oracle 9.2
- Next by Date: RE: Utiltity to seee both JDBC and ODBC
- Previous by thread: SQLColumns hangs on DB link synonym in Oracle 9.2
- Next by thread: RE: [ANN] SQL Scratch Pad released! ODBC example
- Index(es):
Relevant Pages
|
