杀死声明 [英] Kill Statement

问题描述

Access2000模式下的AccessXP


我在MyDatabase.mdb的标准模块中有以下代码大纲---


使用CreateDatabase创建MyOtherDatabase.mdb

使用两个make表查询在MyOtherDatabase.mdb中创建两个表

以编程方式将MyOtherDatabase.mdb压缩为MyZipfile.zip

杀死MyOtherDatabase.mdb ''这是实际的代码行


有没有人知道为什么Kill语句也会删除zipfile，

MyZipfile.zip。


谢谢！


史蒂夫

解决方案

这是不可能的。


拉链最有可能失败，因此文件从未在第一个

的地方创建。

-

MichKa [MS]


此帖子按原样提供。与

无保证，并且不授予任何权利。

Steve < SA **** @ penn.com>在留言中写道

news：ci ****************** @ newsread1.news.atl.earth link.net ...

AccessXP

我在
MyDatabase.mdb的标准模块中有以下代码大纲---
使用CreateDatabase创建MyOtherDatabase.mdb 以编程方式将MyOtherDatabase.mdb压缩为MyZipfile.zip
Kill" MyOtherDatabase.mdb" ''这是实际的代码行

有没有人知道为什么Kill语句也会删除
zip文件，MyZipfile.zip。
谢谢！

史蒂夫

Michka，


感谢您的回复！


当我注释掉Kill语句时，MyOtherDatabase.mdb和MyZipfile.zip都是

。如果我运行我的帖子中显示的代码（使用Kill语句）

这些文件都不存在。


Steve


" Michael（michka）Kaplan [MS]" < MI ***** @ online.microsoft.com>在消息中写道

新闻：3f ******** @ news.microsoft.com ...

这是不可能的。
位置创建。

-
MichKa [MS]

这个发布是按原样提供的。没有保证，也没有授予任何权利。

Steve < SA **** @ penn.com>在消息中写道
新闻：ci ****************** @ newsread1.news.atl.earth link.net ...

Access2000中的AccessXP

我在标准模块中有以下代码大纲

MyDatabase.mdb ---

使用CreateDatabase创建MyOtherDatabase.mdb
使用两个make表查询在MyOtherDatabase.mdb中创建两个表
以编程方式将MyOtherDatabase.mdb压缩为MyZipfile.zip
Kill" MyOtherDatabase.mdb" ''这是实际的代码行

有没有人对Kill语句为什么还删除

zipfile，

MyZipfile有任何想法。拉链。

谢谢！

史蒂夫

< blockquote>不知道这是否会产生影响，但尝试给出mdb和zip文件

不同的名称，例如temp.mdb和MyOtherDatabase.mdb。这会改变什么吗？

" Steve" < SA **** @ penn.com>在留言中写道

news：ci ****************** @ newsread1.news.atl.earth link.net ...

AccessXP

我在
MyDatabase.mdb的标准模块中有以下代码大纲---
使用CreateDatabase创建MyOtherDatabase.mdb 以编程方式将MyOtherDatabase.mdb压缩为MyZipfile.zip
Kill" MyOtherDatabase.mdb" ''这是实际的代码行

有没有人知道为什么Kill语句也会删除
zip文件，MyZipfile.zip。
谢谢！

史蒂夫

AccessXP in Access2000 mode

I have the following code outline in a standard module in MyDatabase.mdb ---

Use CreateDatabase to create MyOtherDatabase.mdb
Use two make table queries to create two tables in MyOtherDatabase.mdb
Programatically zip MyOtherDatabase.mdb as MyZipfile.zip
Kill "MyOtherDatabase.mdb" ''this is the actual line of code

Does anyone have any ideas on why the Kill statement also deletes the zipfile,
MyZipfile.zip.

Thanks!

Steve

解决方案

That is not possible.

Most likely the zip failed, thus the file was never created in the first
place.
--
MichKa [MS]

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Steve" <sa****@penn.com> wrote in message
news:ci******************@newsread1.news.atl.earth link.net...

AccessXP in Access2000 mode

I have the following code outline in a standard module in MyDatabase.mdb ---
Use CreateDatabase to create MyOtherDatabase.mdb
Use two make table queries to create two tables in MyOtherDatabase.mdb
Programatically zip MyOtherDatabase.mdb as MyZipfile.zip
Kill "MyOtherDatabase.mdb" ''this is the actual line of code

Does anyone have any ideas on why the Kill statement also deletes the zipfile, MyZipfile.zip.

Thanks!

Steve

Michka,

Thanks for responding!

When I comment out the Kill statement, MyOtherDatabase.mdb and MyZipfile.zip are
both there. If I run the code as shown in my post (with the Kill statement)
neither of these files are there.

Steve

"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in message
news:3f********@news.microsoft.com...

That is not possible.

Most likely the zip failed, thus the file was never created in the first
place.
--
MichKa [MS]

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Steve" <sa****@penn.com> wrote in message
news:ci******************@newsread1.news.atl.earth link.net...

AccessXP in Access2000 mode

I have the following code outline in a standard module in

MyDatabase.mdb ---

Use CreateDatabase to create MyOtherDatabase.mdb
Use two make table queries to create two tables in MyOtherDatabase.mdb
Programatically zip MyOtherDatabase.mdb as MyZipfile.zip
Kill "MyOtherDatabase.mdb" ''this is the actual line of code

Does anyone have any ideas on why the Kill statement also deletes the

zipfile,

MyZipfile.zip.

Thanks!

Steve

NO idea if this will make a difference, but try giving the mdb and zip files
different names, e.g., temp.mdb and MyOtherDatabase.mdb. Does that change
anything?
"Steve" <sa****@penn.com> wrote in message
news:ci******************@newsread1.news.atl.earth link.net...

AccessXP in Access2000 mode

I have the following code outline in a standard module in MyDatabase.mdb ---
Use CreateDatabase to create MyOtherDatabase.mdb
Use two make table queries to create two tables in MyOtherDatabase.mdb
Programatically zip MyOtherDatabase.mdb as MyZipfile.zip
Kill "MyOtherDatabase.mdb" ''this is the actual line of code

Does anyone have any ideas on why the Kill statement also deletes the zipfile, MyZipfile.zip.

Thanks!

Steve

这篇关于杀死声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！