By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

insert fails on linked SQL table (timeout)

P: n/a
I have an Access XP app that has linked table to SQL 2005 express.
When trying to save a new record, users are getting an error mesage
"insert on linked tbale failed. Timout expired")

I suspect that it has something to do with other users have the table
locked. I tried to look at the locks with SQL Studio express. I can
not find info on what tables are locked.
Feb 4 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Feb 4, 10:53*am, Bill <bmacbr...@excite.comwrote:
I have an Access XP app that has linked table to SQL 2005 express.
When trying to save a new record, users are getting an error mesage
"insert on linked tbale failed. *Timout expired")

I suspect that it has something to do with other users have the table
locked. *I tried to look at the locks with SQL Studio express. *I can
not find info on what tables are locked.
And what error do you get if you try an insert from within sql studio
express ?
Feb 4 '08 #2

P: n/a
On Feb 4, 12:05*pm, Roger <lesperan...@natpro.comwrote:
On Feb 4, 10:53*am, Bill <bmacbr...@excite.comwrote:
I have an Access XP app that has linked table to SQL 2005 express.
When trying to save a new record, users are getting an error mesage
"insert on linked tbale failed. *Timout expired")
I suspect that it has something to do with other users have the table
locked. *I tried to look at the locks with SQL Studio express. *I can
not find info on what tables are locked.

And what error do you get if you try an insert from within sql studio
express ?
It works some of the time from the app. I have not tried to insert a
record from Studio.
Feb 4 '08 #3

P: n/a
On Feb 4, 11:46*am, Bill <bmacbr...@excite.comwrote:
On Feb 4, 12:05*pm, Roger <lesperan...@natpro.comwrote:
On Feb 4, 10:53*am, Bill <bmacbr...@excite.comwrote:
I have an Access XP app that has linked table to SQL 2005 express.
When trying to save a new record, users are getting an error mesage
"insert on linked tbale failed. *Timout expired")
I suspect that it has something to do with other users have the table
locked. *I tried to look at the locks with SQL Studio express. *I can
not find info on what tables are locked.
And what error do you get if you try an insert from within sql studio
express ?

It works some of the time from the app. *I have not tried to insert a
record from Studio.
I'm thinking that trying it from studio will give a more informative
message as to why the timeout
Feb 4 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.