(Object invalid or no longer set)

[Mark A. Sam]

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 Whipp]

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]

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]

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]

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]

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