adp does not give back sql server error messages

A

Andreas Wöckl

Hi group!

I have a strange behaviour of Microsoft Access ADPs with the databases of my
sql-Server: For example if I want to delete a data row from a table that
must not get deleted due to a foreign key that references I do not get any
error message in access. It simply does not delete the data row. I have the
same problems when deleting a row via VBA - if it is not possible due to
database reasons I do not get an error message and therfore can not
implement an error handling!

I am using Windows XP with SQL Server Personal SP 4!

The pair of adp and database works perfectly on the productive server
(Server 2003, Sql Server Standard SP4)

Any ideas..?

best regards

Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2000 ADP and SQL Server 2005 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Data provider could not be initialized 1
ADP how debug switchboard error 0
Recover a corrupt MDF in SQL 2K 0
Access 2007 ADP project will not connect to SQL Server 2008 2
Access 2007 can't connect to SQL Server 1
Can't connect to local SQL Server 2005 from .adp 7

Top