I want to add a button that will make a copy of the
current database and sent it to a flash drive that is
defaulted to the E:\ drive. Is there some code out there
that can do this? Or can you send me in a good direction?

-Steve

Steven M. Britton wrote:

>I want to add a button that will make a copy of the
>current database and sent it to a flash drive that is
>defaulted to the E:\ drive. Is there some code out there
>that can do this? Or can you send me in a good direction?


You should never copy on open file, you can not be sure the
file is in a stable state. This is especially true with
database files where all kinds of things are going on behind
the scenes.

Find another way to deal with whatever problem you hoped
this would solve.

--
Marsh
MVP [MS Access]

"=?Utf-8?B?R3JleVNreQ==?=" <(E-Mail Removed)> wrote
in news:A7533582-DBA5-492F-B6AE-(E-Mail Removed):

> From: "=?Utf-8?B?R3JleVNreQ==?=" <(E-Mail Removed)>
>
> C'mon Marsh, let's leave the analysis to *them* and the solutions to
> *us.*
>

Who is "us"..?


Tim F

"Us" would be "subject matter experts," such as Marsh -- and myself. Tim, it would be a mistake to challenge me on ability in MS Access.

I have copied databases using the method I described above successfully. During the copy, since it is run essentially modally, you can ensure there are no concurrent updates to the MS Access system tables. As this is an API call to to a Windows function, it could well be argued that the database is in a state of "quiet" during this copy.

I rarely find second-guessing requirements to be appropriate in this forum, considering we have not been involved in the JAD sessions that produced them.

There are a few reasons I have been a successful contractor during these miserable lean times of the last few years. And listening to the client, and delivering on their needs, would be very high on that list.

David Atkins, MCP

"Tim Ferguson" wrote:

> "=?Utf-8?B?R3JleVNreQ==?=" <(E-Mail Removed)> wrote
> in news:A7533582-DBA5-492F-B6AE-(E-Mail Removed):
>
> > From: "=?Utf-8?B?R3JleVNreQ==?=" <(E-Mail Removed)>
> >
> > C'mon Marsh, let's leave the analysis to *them* and the solutions to
> > *us.*
> >
>
> Who is "us"..?
>
>
> Tim F
>
>

"=?Utf-8?B?R3JleVNreQ==?=" <(E-Mail Removed)> wrote in
news:6317DA76-176E-4818-A594-(E-Mail Removed):

>
> "Us" would be "subject matter experts," such as Marsh -- and myself.
> Tim, it would be a mistake to challenge me on ability in MS Access.
>
>

Wouldn't dream of it: I was simply responding to a hostile attack on a
regular MVP and helper, coming from an anonymous address. Nice to see you
have a name this time.

All the best


Tim F

My not listing my name would be fair enough for your prod; in fact, it was an omission on my part.

I have posted numerous times, most often a number of months ago, with the same handle. I *almost* always list my name, unless it's an obvious answer or one-liner.

I've seen your posts many times, and respect your ability.

David

"Tim Ferguson" wrote:

> "=?Utf-8?B?R3JleVNreQ==?=" <(E-Mail Removed)> wrote in
> news:6317DA76-176E-4818-A594-(E-Mail Removed):
>
> >
> > "Us" would be "subject matter experts," such as Marsh -- and myself.
> > Tim, it would be a mistake to challenge me on ability in MS Access.
> >
> >
>
> Wouldn't dream of it: I was simply responding to a hostile attack on a
> regular MVP and helper, coming from an anonymous address. Nice to see you
> have a name this time.
>
> All the best
>
>
> Tim F
>
>

"=?Utf-8?B?R3JleVNreQ==?=" <(E-Mail Removed)> wrote in
news:64D7E96F-99D2-420B-989E-(E-Mail Removed):

>
> My not listing my name would be fair enough for your prod; in fact, it
> was an omission on my part.
>
> I have posted numerous times, most often a number of months ago, with
> the same handle. I *almost* always list my name, unless it's an
> obvious answer or one-liner.
>
> I've seen your posts many times, and respect your ability.

We have all seen flames addressed to our regular MVPs, and as someone who
regularly learns from them, I felt a bit defensive. Yes, Marsh can fight
his own battles if he needs to too! If I had recognised your name I
certainly would have kept quiet.

Best wishes


Tim F