数据库没有关闭 [英] Database is not closing

问题描述

创建字段后，我的数据库没有关闭。请指教

My Database is not closing after creating field. Please advise

Set mydb = DBEngine.Workspaces(0).OpenDatabase("\172.22.30.41 \Training-Data\Training\Gaus\Vertical Updates\Database21.mdb") 
tb = mydb.TableDefs("Sheet1")
 ;enter code here
Set fd = tb.CreateField(Me.Date1.Text, dbLongBinary, 1000) 
tb.Fields.Append fd 
mydb.Close 
Set mydb = Nothing 
MsgBox " Date Created" 
Exit Sub

推荐答案

首先：路径应以网格地址的双后斜线 \\172.22.30.41 ... 开头。

秒：从网络打开Access mdb文件会产生很大的通信开销，因为它被设计为仅本地格式，因此您必须等到它完成。

First: the path should begin with a double back slash \\172.22.30.41... for network addresses.
Second: opening an Access mdb file from a network will have significant communication overhead since it was design to be a local only format and therefore you will have to wait until it is done.

这篇关于数据库没有关闭的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！