I am facing some problem with running MS SQL Queries through MS Access 2003.
Actually the process is like this.
Step 1. Insert to a table using Access vba coding.
Step 2. Table has a trigger which execute the stored procedure based on the data inserted.
Step 3. Stored procedure is working fine when i am executing the stored procedure in SQL Server.
but when i am running the same process through ms access i am getting "Run-time error 3155 ODBC SQL Server Driver Timeout expired (#0)"