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,495
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.

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 05:19 PM