If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
(Object invalid or no longer set)
My client's database is suddenly issuing this message and users need to
close and open the db. The Access database is on one server and the backend (SQL Server) on another. I run across this on a personal db with link tables to a remote SQL Server, but can't think why it is happening on my client's system all of a sudden. The Frontend has been acting quirky recently so I and the system sluggish, so I suggested they reboot all of their servers as well as their switches and routers, but I can't get an answer whether it has all been done. I'd just like some insight on this and possible remedies. Thank you and God Bless, Mark A. Sam |
#2
|
|||
|
|||
(Object invalid or no longer set)
Mark,
First and foremost, do you have a back-up? Say yes (if not go make one). Now, the first thing I would try is Compact & Repair. If no improvement, import everything into a new front end and see if that improves the performance. If still no improvement, please define *quirky*... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... My client's database is suddenly issuing this message and users need to close and open the db. The Access database is on one server and the backend (SQL Server) on another. I run across this on a personal db with link tables to a remote SQL Server, but can't think why it is happening on my client's system all of a sudden. The Frontend has been acting quirky recently so I and the system sluggish, so I suggested they reboot all of their servers as well as their switches and routers, but I can't get an answer whether it has all been done. I'd just like some insight on this and possible remedies. Thank you and God Bless, Mark A. Sam |
#3
|
|||
|
|||
(Object invalid or no longer set)
Gina,
You are misunderstanding the problem It isn't the Access DB. It has something to do with SQL Server. Someone a connection is dropping. Yes I have tons of backups. God Bless, Mark "Gina Whipp" wrote in message ... Mark, First and foremost, do you have a back-up? Say yes (if not go make one). Now, the first thing I would try is Compact & Repair. If no improvement, import everything into a new front end and see if that improves the performance. If still no improvement, please define *quirky*... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... My client's database is suddenly issuing this message and users need to close and open the db. The Access database is on one server and the backend (SQL Server) on another. I run across this on a personal db with link tables to a remote SQL Server, but can't think why it is happening on my client's system all of a sudden. The Frontend has been acting quirky recently so I and the system sluggish, so I suggested they reboot all of their servers as well as their switches and routers, but I can't get an answer whether it has all been done. I'd just like some insight on this and possible remedies. Thank you and God Bless, Mark A. Sam |
#4
|
|||
|
|||
(Object invalid or no longer set)
Mark,
You are correct, I did misunderstand. As for remedies, perhaps posting the SQL Server newsgroup would yield better answers? Posting your question to Access table design is apt to get more suggestions for the Access side then the SQL Server side. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... Gina, You are misunderstanding the problem It isn't the Access DB. It has something to do with SQL Server. Someone a connection is dropping. Yes I have tons of backups. God Bless, Mark "Gina Whipp" wrote in message ... Mark, First and foremost, do you have a back-up? Say yes (if not go make one). Now, the first thing I would try is Compact & Repair. If no improvement, import everything into a new front end and see if that improves the performance. If still no improvement, please define *quirky*... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... My client's database is suddenly issuing this message and users need to close and open the db. The Access database is on one server and the backend (SQL Server) on another. I run across this on a personal db with link tables to a remote SQL Server, but can't think why it is happening on my client's system all of a sudden. The Frontend has been acting quirky recently so I and the system sluggish, so I suggested they reboot all of their servers as well as their switches and routers, but I can't get an answer whether it has all been done. I'd just like some insight on this and possible remedies. Thank you and God Bless, Mark A. Sam |
#5
|
|||
|
|||
(Object invalid or no longer set)
Gina,
Are you kidding. The Access guys have the answers. It's tough (not impossible) to get one from any of the other groups. God Bless, Mark "Gina Whipp" wrote in message ... Mark, You are correct, I did misunderstand. As for remedies, perhaps posting the SQL Server newsgroup would yield better answers? Posting your question to Access table design is apt to get more suggestions for the Access side then the SQL Server side. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... Gina, You are misunderstanding the problem It isn't the Access DB. It has something to do with SQL Server. Someone a connection is dropping. Yes I have tons of backups. God Bless, Mark "Gina Whipp" wrote in message ... Mark, First and foremost, do you have a back-up? Say yes (if not go make one). Now, the first thing I would try is Compact & Repair. If no improvement, import everything into a new front end and see if that improves the performance. If still no improvement, please define *quirky*... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... My client's database is suddenly issuing this message and users need to close and open the db. The Access database is on one server and the backend (SQL Server) on another. I run across this on a personal db with link tables to a remote SQL Server, but can't think why it is happening on my client's system all of a sudden. The Frontend has been acting quirky recently so I and the system sluggish, so I suggested they reboot all of their servers as well as their switches and routers, but I can't get an answer whether it has all been done. I'd just like some insight on this and possible remedies. Thank you and God Bless, Mark A. Sam |
#6
|
|||
|
|||
(Object invalid or no longer set)
Mark,
You know you might be right! 8o -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... Gina, Are you kidding. The Access guys have the answers. It's tough (not impossible) to get one from any of the other groups. God Bless, Mark "Gina Whipp" wrote in message ... Mark, You are correct, I did misunderstand. As for remedies, perhaps posting the SQL Server newsgroup would yield better answers? Posting your question to Access table design is apt to get more suggestions for the Access side then the SQL Server side. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... Gina, You are misunderstanding the problem It isn't the Access DB. It has something to do with SQL Server. Someone a connection is dropping. Yes I have tons of backups. God Bless, Mark "Gina Whipp" wrote in message ... Mark, First and foremost, do you have a back-up? Say yes (if not go make one). Now, the first thing I would try is Compact & Repair. If no improvement, import everything into a new front end and see if that improves the performance. If still no improvement, please define *quirky*... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Mark A. Sam" wrote in message ... My client's database is suddenly issuing this message and users need to close and open the db. The Access database is on one server and the backend (SQL Server) on another. I run across this on a personal db with link tables to a remote SQL Server, but can't think why it is happening on my client's system all of a sudden. The Frontend has been acting quirky recently so I and the system sluggish, so I suggested they reboot all of their servers as well as their switches and routers, but I can't get an answer whether it has all been done. I'd just like some insight on this and possible remedies. Thank you and God Bless, Mark A. Sam |
Thread Tools | |
Display Modes | |
|
|