Copying an .mdb w/ a script and getting an error

[Bettergains]

Hello:
I realize this may involve our network (or security settings on my pc) but
perhaps jet has something to do with this. I am copying a .mdb file from a
file server on our intranet to my desktop. After the script has run, I open
the file, and immediately get this error:

"The Microsoft jet database engine stopped the process because you and
another user are attempting to change the same data at the same time.

In fact, no one is changing any data. There are no .ldb files open on
either the source or target destination. I am simply trying to open the file
that has been copied over to my target location.

For the .bat file i am using just the "dir" and "copy" commands;
for the .vbs:

Dim FSO (details)
Set FSO (details)
If FSO.FileExists (details)
FSO.CopyFile (details)
End if (details)

These both worked fine; now they don't. Any ideas?

 

[John Vinson]

Hello:
I realize this may involve our network (or security settings on my pc) but
perhaps jet has something to do with this. I am copying a .mdb file from a
file server on our intranet to my desktop. After the script has run, I open
the file, and immediately get this error:

"The Microsoft jet database engine stopped the process because you and
another user are attempting to change the same data at the same time.

Are you copying the database while it is open? If so, you may be at
risk. Normally one would run such a script only upon a closed
database.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Bettergains]

Hi John:
I am only copying it over when the file is closed. In fact I can view the
source folder and watch for when the .ldb goes away. This is the mystery.

 

[John Vinson]

Hi John:
I am only copying it over when the file is closed. In fact I can view the
source folder and watch for when the .ldb goes away. This is the mystery.

Odd. Could you post the relevant portion of the code?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Bettergains]

John:

dir \\chain\CaData\mydatabase.mdb
copy "\\chain\CaData\mydatabase" "C:\Documents and
Settings\mi\Desktop\Items\Ca\mydatabase.mdb"

Now that I think about it, the thing that changed from yesterday to today in
my world, is that I accepted forced office 2003 updates (forces, as in
pushed across our intranet). So, IF that turns out to be the cause, how do I
identify what I can uninstall? Or can I just reinstall?

 

[Bettergains]

hi John:
More information:
I uninstalled Access 2003 and reinstalled. Now am running the vbs script
instead. The .bat was scheduled and I deleted those scheduled tasks. When
running the vbs manually (ie, clicking on vbs file) the mdb copies, and
waiting appx one minute, it works. I tried waiting before when running the
..bat with no luck as before. Hmmmm. could we'll see how long this lasts .