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: .MDB file will not overrite or copy

14 Aug 2009   #1

Windows 7 x64 Home Premium
.MDB file will not overrite or copy

I'm programming in Vb2008 and using an Access 2003 backend for the data.

So I have my access database in My Projects\... ect and I build it to the usual x86\debug folder. However, when I copy the files to a folder I have made in C:\Program Files\ProgramName which had older versions of the files the .MDB file will not update.

I've checked both database files at this point and they're fine all records are up-to-date, except the one where I've copied it to in C:\Program Files\ProgramName is still the old file. I've even SHIFT+deleted the .MDB file from the directory and copied the new one over and it still shows the old data and tables when I open it!!

Any ideas, I'm stumped and totally confused.

My System SpecsSystem Spec
14 Aug 2009   #2


Linked tables in the mdb?
My System SpecsSystem Spec
14 Aug 2009   #3

Windows 7 x64 Home Premium

Hi thanks for the reply, I'm not using any linked tables or ODBC links. All tables are in the access file.

First impression if I was reading this would be, ah it must be the user doing something silly lol, but seriously I'm simply trying to copy one file over to another location and it's saying it's copied ok, but it really hasn't.

Oh and I'm the only user and have full admin rights.
My System SpecsSystem Spec

14 Aug 2009   #4


Something in your front end is pointing to the desired backend file. If you're not using linked tables, then it's probably an ODBC data source. You need to change that (or whatever component in your code points to the back end and manages the connection) to point to the new file.
My System SpecsSystem Spec
14 Aug 2009   #5


Can you copy other files successfully? If yes, it sounds like a coding issue in your VB.

Test: Open the "old" mdb from Access - not from your front-end. Link the "new" mdb tables. Compare by query or whatever means. Are the tables identical?

My version of Windows does not "it's saying it's copied ok". If you are copying by code, examine your code carefully for the target.
My System SpecsSystem Spec
14 Aug 2009   #6

Windows 7 Ultimate x64

The problem is not about a coding issue, or linked tables or any fault of your own.

I'm guessing you're coding and running your app on Windows 7, right? If this is true (why would it not be, if you're on SevenForums?), then it's because you're putting your Access database file into a subfolder of "Program Files", which on Vista and Windows 7 is classified as a protected folder, with restricted access to usually Administrator and Trusted Installers. This is by design to help prevent unauthorised programs (malare and such) from making changes they shouldn't.

If your MDB file is in some user folder, such as Documents, or some other user-created folder, then you wouldn't have a problem.

It'll take a bit of getting used to, but you'll have to recode your applications to run from "Program Files", but to locate any and all data files into a user folder.
My System SpecsSystem Spec
14 Aug 2009   #7

Windows 7 x64 Home Premium

Thanks for the input people, I think some of you have misinterpreted what I wrote though. I'm not using any code to copy the .MDB file, I'm simply trying to right click copy and right click paste into the destination directory so it is nothing to do with any code. Sorry I should have stated that more clearly in the first place.

Thanks Dzomlija I'll see what happens if I try a different folder. I would have thought that if there was any problems in copying a file or files then Windows would at least tell you it can't do it and why not.

Also the old file is deleted, yet it is still bringing up the old file as though it is the new one, why is that? That must be something not working correctly in Windows surely?

Here's what I'm doing:

Open explorer, browse to project folder containing the .MDB file
Right click and copy it
Browse to the Program Files\ProgramName folder and paste
It says preparing to copy and asks copy and replace or copy and keep existing
I choose copy and replace
It says You'll need to provide Admin permission to copy to this folder
I choose Continue as I have access being the Admin user

The file properties are the same as the source, yet when I open the file it is not the one I just copied, it is the old mdb file. This file remains the same no matter if I delete it and copy the newer one over, it still opens as if it is still the old file. How is that even possible when the file has been deleted and therefore no longer on my system?!
My System SpecsSystem Spec
15 Aug 2009   #8

Windows 7 x64 Home Premium

Please can someone HELP!

It's driving me mad and I'm getting very concerned that this new Windows file allocation management system is still buggy!!
My System SpecsSystem Spec
15 Aug 2009   #9

Windows Seven Ultimate

i'm not getting help either - no-ones helping wid my dvd problem!
My System SpecsSystem Spec
16 Aug 2009   #10

Windows 7 x64 Home Premium

I don't know much about your problem, but I've given my 2 pence worth and hope it helps.

Can someone please HELP me!
My System SpecsSystem Spec

 .MDB file will not overrite or copy

Thread Tools

Similar help and support threads
Thread Forum
Batch File .bat to copy file from File Sharing & FTP Hosting
Hi all, Any idea how to write Batch File .bat to copy file from File Sharing & FTP Hosting to local directory. Current the File Sharing & FTP Hosting is SMARTFILE. I don't want to use WINSCP as the connector. Thanks
General Discussion
Need a file copy recommendation with partial file resume
I'm currently using Richcopy to move about 4TB worth of data from our colo facility (1000 miles away) to our office. And that data also gets routed overseas first before coming back (don't ask). Needless to say, connectivity while not bad, could be better. The small files are zooming right...
Copy file address after doing a file search in windows explorer
Hi All I have a rather large file system with lots of folders & subfolders. When I want to save previously on Xp operating system I'd search in explorer open the folder I want then copy the address (e.g c:\customer records\client name\job address). In windows 7, when I copy the folder address i...
General Discussion
how do I copy a BIG single file (using richcopy?) big file copy
I'm trying to copy a VHD (22g, dynamic I think...) I tried richcopy. It says copy started, but then stops.... I saw someone mention xcopy /j, to achieve the unbuffered I/O perf. you get with richcopy... it's running, but no indication as to how long it takes (EDIT: just finished, > 10...
General Discussion
How to copy a file from 1 pc to another pc in network using batch file
Help me make a batch file that copies a file from one computer to another computer in a network... PC1 = Source PC2 = Destination I want to copy a file from PC1's Drive E: to PC2's Drive E:
General Discussion

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 09:30.
Twitter Facebook Google+