By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

OMFG - can anyone help me understand how this happened?

P: n/a
Hi all,

Just had the wierdest thing happen overnight to one of my databases.

I have a frontend/backend set up with the front end under development
on my machine.

I was copying a load of old files of the network while I had my front
end performing some tasks overnight and I have managed to copy an old
version of the front end over the version i had open. I didn't know I
had an old version in the directory (possible that someone else saved
it to the network).

I arrive this morning to a permissions error - i don't have permissions
to do anything and the VBA has broken.

How can windows copy a database over an open database on my machine?
What the hell happened to allow it to that?

The copy was set going manually - not through the database - and it has
destroyed a lot of edits (two days worth as my backup failed the day
before)

Any good ideas?

When i got to the machine this morning, the database was still open (or
appeared so) and i could go to any module etc... but once i closed it
and reopened to see if there was a problem i could fix, then it has
completely lost everything as if i just replaced the mdb file while i
had it open.

Rats... any good ideas appreciated, but an idea of how i was able to do
this would be more useful.

Cheers,

Rob.

Jan 17 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi, Rob.
How can windows copy a database over an open database on my machine?
What the hell happened to allow it to that?
Without a file lock to prevent it, it's a piece o' cake. If you ever want
to do it with VBA code, Microsoft Access MVP Tom Wickerath's article,
"Automatically Update the Front End of a Split Database," will show you how
to use the Windows API to accomplish it. Please see the following Web page
for a link to his article:

http://www.Access.QBuilt.com/html/articles.html
The copy was set going manually - not through the database - and it has
destroyed a lot of edits (two days worth as my backup failed the day
before)

Any good ideas?
The cheapest way is to restore from the most recent good backup. If you
catch the file overwrite immediately, it's sometimes possible to recover
some of the original file's fragments with a data recovery tool, but it's
nearly impossible to restore these record fragments into a meaningful
structure without extreme amounts of time and patience. If this recovered
structure is even one byte off, Jet won't be able to open the database file,
so this is not the recommended way to go.
When i got to the machine this morning, the database was still open (or
appeared so) and i could go to any module etc... but once i closed it
and reopened
It only existed in RAM at that point, not on disk, but as you clicked on
objects or scrolled the scrollbar, more data was read from the file,
resulting in mismatches of information and overall confusion of the commands
given to the computer to carry out. Closing the database file and reopening
it retrieved the necessary file data from the "new" file, which wasn't what
you wanted. You would have had to use an expensive recovery tool to recover
what was left in RAM from the original file which, as you discovered, was
"confused" at the point you closed the file -- and pretty much useless.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"dkintheuk" <rm*******@firenet.uk.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...
Hi all,

Just had the wierdest thing happen overnight to one of my databases.

I have a frontend/backend set up with the front end under development
on my machine.

I was copying a load of old files of the network while I had my front
end performing some tasks overnight and I have managed to copy an old
version of the front end over the version i had open. I didn't know I
had an old version in the directory (possible that someone else saved
it to the network).

I arrive this morning to a permissions error - i don't have permissions
to do anything and the VBA has broken.

How can windows copy a database over an open database on my machine?
What the hell happened to allow it to that?

The copy was set going manually - not through the database - and it has
destroyed a lot of edits (two days worth as my backup failed the day
before)

Any good ideas?

When i got to the machine this morning, the database was still open (or
appeared so) and i could go to any module etc... but once i closed it
and reopened to see if there was a problem i could fix, then it has
completely lost everything as if i just replaced the mdb file while i
had it open.

Rats... any good ideas appreciated, but an idea of how i was able to do
this would be more useful.

Cheers,

Rob.

Jan 17 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.