From: Gina Whipp on
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" <MarkASam(a)EmEssEn.Com> wrote in message
news:%23H3MSo1XKHA.5368(a)TK2MSFTNGP02.phx.gbl...
> 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" <NotInterested(a)InViruses.com> wrote in message
> news:eOJr2e1XKHA.4360(a)TK2MSFTNGP04.phx.gbl...
>> 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" <MarkASam(a)EmEssEn.Com> wrote in message
>> news:OcqmiN1XKHA.1280(a)TK2MSFTNGP04.phx.gbl...
>>> 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" <NotInterested(a)InViruses.com> wrote in message
>>> news:ulmh$G1XKHA.1236(a)TK2MSFTNGP05.phx.gbl...
>>>> 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" <MarkASam(a)EmEssEn.Com> wrote in message
>>>> news:%23NrFmSvXKHA.1232(a)TK2MSFTNGP05.phx.gbl...
>>>>> 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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>