Re: Copying a back end database
- From: "Ken Snell [MVP]" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Jun 2005 11:46:59 -0400
Copying a database while others are working in it is one way to get a bad
copy...if you happen to copy while a record is being changed or updated or
added.
In VBA, you can use the FileCopy command to make a copy of a file and put it
in a new location.
--
Ken Snell
<MS ACCESS MVP>
"PeterG" <quality@xxxxxxxxxxxxxxxx> wrote in message
news:d8dlcf$46b1@xxxxxxxxxxxxxxxxxxxxxxxxx
>I have a networked access application running several copies of the front
>end database on network computers all linked into a back end database on
>the server. The trouble is my PC is a notebook and I need to take a copy of
>the back end with me when I travel. I have written some code that causes my
>front end to select the back end database on the server when I am connected
>to the network and to select the back end database on my notebook whenever
>I am travelling but what I cant get Access to do is to copy the back end
>from the network to my laptop automatically. I have tried using the compact
>database command and specifying my laptop as the destination but this only
>works when no-one else on the network is connected to the back end...which
>is basically never.
>
> Copy and Paste in Windows Explorer works regardless of how many people are
> using the database but I dont know how to call those commands from within
> VB.
>
> Please help, how can I do this?
>
> Peter Gregory
>
.
- Prev by Date: RE: Technique for Updating Part Master
- Next by Date: RE: template for basic product distribution contract
- Previous by thread: template for basic product distribution contract
- Next by thread: dim ADODB.connection
- Index(es):
Relevant Pages
|
