Showing posts with label placed. Show all posts
Showing posts with label placed. Show all posts

Friday, March 30, 2012

Log off Users in shared drive - Access2000

I have an Access2000 app placed on a shred drive. The problem i am having is that users leave it opened and take long breaks. Sometimes they leave it overnight. I would like to make corrections to the form but can't. How can I save and close all users. I would like to send a message telling all users to save any changes and give them 1 minute before shutting down.

ThanksHow do you plan to force them out?

I guess you could look at the timer interval event in Access...|||We have this problem on a small Access DB attached to Sybase. As far as we know, there's nothing you can do. The best I've managed to date is to open the lock file, take the computer names in the lock file and NETMSG them, but it doesn't guarantee they'll close the DB.

Friday, March 23, 2012

Log file size continuously grows

Log file size continuously grows, even I placed Simple Recovery mode. Any one
tells me, how can I prevent this problem?
http://support.microsoft.com/?kbid=873235
HTH, Jens Suessmeyer.
"Farhan" <Farhan@.discussions.microsoft.com> schrieb im Newsbeitrag
news:14587936-A487-4A9C-BE5E-7A2A963612CD@.microsoft.com...
> Log file size continuously grows, even I placed Simple Recovery mode. Any
> one
> tells me, how can I prevent this problem?
|||My guess would be you have an open transaction. What does DBCC OPENTRAN say
for that db?
http://www.nigelrivett.net/Transacti...leGrows_1.html Log File issues
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations
Andrew J. Kelly SQL MVP
"Farhan" <Farhan@.discussions.microsoft.com> wrote in message
news:14587936-A487-4A9C-BE5E-7A2A963612CD@.microsoft.com...
> Log file size continuously grows, even I placed Simple Recovery mode. Any
> one
> tells me, how can I prevent this problem?