(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

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

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

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

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

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