数据库中Applications项目的visual basic已损坏 [英] The visual basic for Applications project in the database is corrupt
问题描述
Access 2003.在Windows Server 2003上运行终端服务器。
我尝试复制文件的每台计算机上都会出错至。
最新Jet SP& Office SP。数据库尚未转换。混合了
模块,表格,链接表格和温度。访问端的表格。
导出到新数据库不起作用(相同的错误)。从
新数据库导入不起作用(相同的错误)。试图在
代码视图中打开任何表单或模块是不可能的(同样的错误)。许可设定为
HKLM / Soft ... / Micros ... / Office / XX [版本]供所有人完全控制。
任何人都可以救命?我对这些数据并不感兴趣 - 但是我们花了两天时间完成了b / b
的代码模块工作 - 并没有记录开发过程中的b
。如果可能的话,我很想回去做这件事。
- 好去腐败工具?
- 任何获取代码的方式(将vb部分从
mdb中分离出来?)
我们最近还没有对数据库进行备份,只能回滚
。是的 - 这是我们自己的错。我们现在每天都要备份而不是两次
每周
。
谢谢,
Nick Stansbury
分析师,Sage Partners
Hi,
Access 2003. Running over terminal server on a Windows Server 2003 box.
The error occurs on every machine that I''ve tried copying the file to.
Latest Jet SP & Office SP. Database hasn''t been converted. A mixture of
modules, forms, linking tables & temp. tables at the access end.
Exporting to a new database doesn''t work (same error). Importing from a
new database doesn''t work (same error). Trying to open any form or module in
code view is impossible (same error). Permission are set at
HKLM/Soft.../Micros.../Office/XX [version] for everyone to full control.
Can anyone help? I''m not fussed about the data - but we spent two full
days and nights work on code modules- and made no record of the development
process. I''d love to get that work back if possible.
- Good "de-corruption" tool?
- Any way of getting to the code (splitting the vb parts out of the
mdb?)
We haven''t backed up the database recently enough to merely roll
back. Yes - it is our own fault. We''ll be backing up daily rather than twice
weekly now.
Thanks,
Nick Stansbury
Analyst, Sage Partners
推荐答案
2004年7月15日上午05:57,尼克Stansbury" < nickDOTstansbury @ sage-
partners.com>在新闻中写道:cd ********** @ phys-news-1.nl.colt.net:
On Jul 15 2004, 05:57 am, "Nick Stansbury" <nickDOTstansbury@sage-
partners.com> wrote in news:cd**********@phys-news-1.nl.colt.net:
- 任何获取代码的方式(拆分) bb部分来自
mdb?)
- Any way of getting to the code (splitting the vb parts out of the
mdb?)
您是否尝试过SaveAsText?如果失败,我认为可能,请尝试
pksolutions.com。
-
删除9回复通过电子邮件
Did you try SaveAsText? If that fails, which I think is likely, try
pksolutions.com.
--
remove a 9 to reply by email
在消息< cd ********** @ phys-news-1.nl.colt.net> ;,,Nick Stansbury
< ni ************** @ sage-partners.com>写道
In message <cd**********@phys-news-1.nl.colt.net>, Nick Stansbury
<ni**************@sage-partners.com> writes
Access 2003.在Windows Server 2003机器上运行终端服务器。
我尝试将文件复制到的每台机器上都会出现错误。
Hi,
Access 2003. Running over terminal server on a Windows Server 2003 box.
The error occurs on every machine that I''ve tried copying the file to.
这可能是一个虚假的错误消息。我记得在几年前移动A2000数据库的时候看到了它。 IIRC它意味着查询中引用的链接表之一无法打开,因为
在文件移动到的机器上没有DSN。这与VBA没什么关系。
-
Bernard Peek
英国伦敦。 DBA,经理,培训师和作者。是否有用。
That could be a bogus error message. I remember seeing it when I was
moving A2000 databases around a few years ago. IIRC it meant that one of
the linked tables referenced in a query couldn''t be opened because there
was no DSN on the machine the file had been moved to. It was nothing at
all to do with VBA.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.
你尝试过SaveAsText吗?如果失败,我认为可能,请尝试
pksolutions.com。
Did you try SaveAsText? If that fails, which I think is likely, try
pksolutions.com.
SaveAsText?不是一个访问家伙我有点迷失 - 我怎么能运行任何vb
例程而无法进入VB编辑器?
SaveAsText? Not being an access guy I''m a bit lost - how can I run any vb
routines without being able to get into the VB editor?
这篇关于数据库中Applications项目的visual basic已损坏的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!