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
Custom screensaver file read access right, network access
Hi, I've creates my own custom screensaver (in Visual Studio 12 using WPF), which need access to network for check an weather and email check. I've settings saved in two files. First one is NotifyScreensaver.scr.config, where I've only url to server, from which I take weather informations....
Themes and Styles
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
limited access on wireless, also cannot access programme uninstall
Hi Firstly I am not very computer savy so would ask that any assitance or help given is on simple terms - Thanks :D I have 2 dell laptops running off the same router and have been working fine for the last 6 months. One of the laptops has all of a sudden switched to saying limited access on...
Network & Sharing
laptop will access homegrop but will not allow access to mapped folder
Righteo, i have my (main) desktop hooked up with mapped folders which my two other computers (laptop wireless and wired and desktop wired) can access and do what i intended them to with sharing restrictions, etc. However, my 2nd laptop that after a struggle connecting it to the homegroup will...
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
Download Windows Access Panel For Easy Access To Window
Download Windows Access Panel For Easy Access To Windows Utilities Many Windows users might not like the default settings that come automatically but tend to customise or make changes to the default settings. Users who are familiar with control panel or other system utilities shouldn’t have...
Software


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 13:19.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App