Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Taskkill and Access

25 Nov 2010   #1
Espio

Win7 Pro x64
 
 
Taskkill and Access

Are there any Access database dudes that know if using taskkill.exe to close access (to close a database at night so it can compact) is a bad thing to do?

I need to have my database closed at night and I always forget, taskkill.exe works, but my colleague, who designed the database, says that force quitting access breaks the database.

I want to know if he is right./.


My System SpecsSystem Spec
.
25 Nov 2010   #2
richc46

Microsoft Community Contributor Award Recipient

Windows 10, Home Clean Install
 
 

Not having used taskill I am not familiar with its effects. Have you tried right clicking on the task bar, bringup task manager and killing process from there?
My System SpecsSystem Spec
25 Nov 2010   #3
Espio

Win7 Pro x64
 
 

Taskkill.exe is the same as ending the Access process from the Taskmanager, I'm not asking how to use it, Im asking how it affects the database. But thanks for your quick reply :)
My System SpecsSystem Spec
.

25 Nov 2010   #4
Ztruker

Windows 10 Pro X64
 
 

Why use taskkill? Can't you communicate with Access from Command Line or a batch file? I use MySql and when I want to make changes I do a net stop mysql to gracefully shut it down, then net start mysql when done.

If not, what about using msaccess.exe /compact to compact the database if that's all that needs doing. That way you don't have to kill Acccess.

Some info here: How to use command-line switches in Microsoft Access
My System SpecsSystem Spec
25 Nov 2010   #5
Espio

Win7 Pro x64
 
 

Im just one of the 5 clients accessing the single database stored on the server, I had a look into that KB article, seems more to do with opening the Database. Let me rephrase what I want:
I need my database, which is run in access, to close at 5:30pm. If you use taskkill on access to close it, does it ruin the database?
My System SpecsSystem Spec
26 Nov 2010   #6
Ztruker

Windows 10 Pro X64
 
 

If the database is in the middle of an update you definitely risk corrupting it. What you need to come up with is a way to tell the server to shutdown the database, do what you need to do then have the server start it again.

I'm not an Access user so can't help with this but there has to be a way.

Hopefully one of the other folks here can help.

Edit: You should be able to setup a scheduled task on the server to have it do the compact at what ever time you want.
My System SpecsSystem Spec
Reply

 Taskkill and Access




Thread Tools




Similar help and support threads
Thread Forum
How to kill a process that even taskkill cannot terminate?
Right in this moment I am with a recalcitrant process (foobar2000.exe *32) allocated in the memory. The application already was terminated but I cannot eliminate the process. First I tried the Task Manager Window and nothing. Then I tried the taskkill prompt command, it said that the process was...
General Discussion
Asus Laptop keeps getting random limited access. No internet Access
When I am on my computer at random times my asus laptop would drop my internet. I am using a wireless connection and my connection is not bad. Just wondering if there is a quick fix to this. I am not the most knowledgeable computer guy but I could follow directions if you guys need addition info of...
Network & Sharing
Dial Up ICS Error:Access Type No Internet Access With Yellow Triangle
Hi, i am a newbie when it comes to Windows networking particularly Internet Connection Sharing (ICS). A week ago i turned my Win 7 HP Laptop into wireless router which is on EVDO 3G dial up using the windows (ICS) to connect my second Win 7 Dell laptop which was successful. Unfortunately, i...
Network & Sharing
Taskkill
I have tried several time to kill the process for a particular program with an elevated command prompt of C:\\Windows\System32>taskkill /pid 704 /f. Each time it claims to have been successful, but the process remains regardless. Am I doing something wrong, or is taskkill?
Performance & Maintenance


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 16:12.
Twitter Facebook Google+