February 4, 2005 at 7:12 am
Hi All,
I have MS Access 2000 application connected through odbc to a sqlserver database. The sql server runs on windows 2000 server. They run on 2 different computers and etablish connection with windows authentication in LAN.
When I try to open and update the database, then I receive a following message [Microsoft][ODBC SQL Server Driver] timeout expired (#0).
If I delete my account and add the username again, then I can update the database. It Works a while
So I close the application and wait some hours. I open again and try to update, then I get the error again. It seems that the rights for updating the database do not remain. I can open and read the data. But not update
Can anyones figure out what are wrong with my sql server or OS
Regards
- Loi -
February 7, 2005 at 8:00 am
This was removed by the editor as SPAM
February 8, 2005 at 1:19 pm
February 9, 2005 at 11:05 am
I ran into this type of scenario before.
Are you using the same access database (shared on a server) and being used by multiple people?
It's what I was doing and I ended up having to copy the database down to each seperate machine and create a DSN for that machine (which stored the PW to the database in it as well so my users were never prompted).
I'm sure there is a cleaner way of doing this, but hopefully my solution will point you to a better one.
February 16, 2005 at 4:16 pm
Don't know if this is relevant but I had major problems with a SQL database connected to access after the SQL server database grew to be very substantial in size.
What the problem was is access had difficult negotiating itself against such a large database without some kind of help in terms of indexes.
When I put in a couple of key ones it was not a problem. That database now has a table with over 22 million rows!
Chris
February 17, 2005 at 3:36 am
February 17, 2005 at 4:09 am
We are running our Application on Access with Backend in SQL Server since past 4 years now(there are some reasons/ features we need from access and we still use it). Initially we faced same problem and after dignose we implement all what thgamble1 posted earlier.
I would suggest you to follow thgamble1. Also check if your Access database Migrated in SQL Server and if there are any table containing columns with spaces in their name like [Full name] or so, you should change them on backend (SQL Server 2000) and fix it on Access code, forms and queries and in reports. I hope my this advice will work well
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply