UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How To Force Delete Or Move An Ms Access Adp Database File?, Access 2010    
 
   
sapwebintelligen...
post Feb 3 2017, 11:09 AM
Post#1



Posts: 23
Joined: 13-June 16



Good Morning All,

I am trying to replace my old MS Access adp file that has a SQL Server backend with a newly designed MS Access .accdb database.

My end users use the database on a daily basis and I was required to place my new database in Production since 02/01/2017 which was day before yesterday.

I am unable to delete or move my old *.adp MS Access database file because I keep getting an error (attached screenshot) that states "This action can't be completed because the file is open in another program."

The problem is there are some users (out of 50 users) that either may have the old database file open or are still using this old version.

Is there any way to force delete this file so that my users can only see the new *.accdb MS access database file?

I have tried to use the unlocker tool to delete this file but was unsuccessful.

Any advise is greatly appreciated.

Thanks,

Nick
Attached File(s)
Attached File  error.JPG ( 22.41K )Number of downloads: 2
 
Go to the top of the page
 
Doug Steele
post Feb 3 2017, 03:57 PM
Post#2


UtterAccess VIP
Posts: 21,853
Joined: 8-January 07
From: St. Catharines, ON (Canada)


One somewhat drastic approach may be to reboot the server and try deleting it before anyone else has a chance to log in.

--------------------
Doug Steele, Microsoft Access MVP (2000-2018)
http://www.accessmvp.com/DJSteele/AccessIndex.html
Co-author: Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs, published by Wiley
Co-author: Effective SQL: 61 Specific Ways to Write Better SQL, published by Addison-Wesley Professional
Technical Editor: Access 2010 Bible, Access 2013 Bible, Access 2016 Bible, all published by Wiley
Technical Editor: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition, published by Addison-Wesley Professional
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th August 2018 - 02:46 AM