我自2000年以来每个新版本Access的仪式问题 [英] My ritual question for each new version of Access since 2000

查看:44
本文介绍了我自2000年以来每个新版本Access的仪式问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

你好


因为这个原因,我下载了Office 2007:


再次看来,无法保存任何修改

在VBA库中完成,来自Access中的主项目。


保存按钮仍然是灰色的。


似乎也无法在另一个Access实例中打开库

并修改它。


这使得无法维护纯VBA Access数据库

库只能在主项目的上下文中进行测试。


实际上这使得无法进行一些元编程。

访问权限。这是 - 而且一直是我唯一的工作方式。


所以我的问题是,六年或七年以来的仪式:是否有一个

的可能性解释一个实例中只有一个人

的Access即将修改此文件的Access?还是一些非常简单的东西,比如

那个?


马蒂厄,寂寞,绝望。

解决方案

你有一个主项目(MDB)和一个图书馆项目(MDB),你正在从主要文件中对图书馆进行

的引用,你想要做一个改变

库,从主要开放。是吗?


我不知道怎么办。


任何人?

>

似乎无法在另一个Access实例中打开库并修改它。




您是否尝试过使用源代码控制?

access 2003有一个源代码控件添加,当您使用它时,您可以

签入,/检查代码,查询,表格等。事实上,真正好的

是你实际上可以查看查询....并检查它们! (我

想不到任何允许这样做的想法)。


我没有尝试过上述内容,但对于最严重的开发,人们确实使用了

源代码控制。也许这将是你的案例的解决方案....

-

Albert D. Kallal(访问MVP)

埃德蒙顿,艾伯塔省加拿大
pl ************* ****@msn.com
http:// www.members.shaw.ca/AlbertKallal


>也许这将是您的解决方案......

在考虑这个问题时,它不会解决您的问题。我的下一个最好

建议是总是设置对mde的引用,这样,你就可以打开/浏览/修改mde libary所基于的mdb上。那应该是
工作。如果你*对* libary代码做了更改,那你就必须等待,直到你退出hold的appcaton。 mde。


我觉得你可以很好地设置一个mdb文件的引用

anway(一个弹性的mde强制编译代码) )。



-
Albert D. Kallal(访问MVP)
加拿大艾伯塔省埃德蒙顿
PL ***************** @ MSN。 com
http://www.members.shaw.ca / AlbertKallal



Hello

I downloaded Office 2007 for this reason :

It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.

The save button remains desperatly grayed.

It also seems impossible to open the library in another Access instance
and modify it.

This makes impossible to maintain a pure VBA Access database when this
library can only be tested in the context of the main project.

In fact this makes impossible to make some meta-programmation whith
access. This is -and has always be- my only way to work.

So my question is, ritual since six or seven years : is there a
possibility to explain Access that only one person in a single instance
of Access is about to modify this file ? or something very simple like
that ?

Mathieu, lonesome, desperate.

解决方案

You have a main project (MDB) and a library project (MDB), and you''re making
reference to the library from the main, and you want to make a change in the
library, while opening from the main. Is that it?

I don''t know of any way to do that.

Anyone?


>

It also seems impossible to open the library in another Access instance
and modify it.



Have you tried using source code control?
access 2003 has a source code control add in, and when you use it, you can
check in,/ check out code, queries, forms etc. In fact, what is really nice
is that you can actually check out queries....and check them back in!! (I
can''t think of any ide that allows this).

I not tried the above, but for most serious development, people do use
source code control. Perhaps it would be a solution in your case....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal


>Perhaps it would be a solution in your case....

In thinking about this, likey it would NOT solve your problem. My next best
suggestion would be to ALWAYS set a reference to a mde, and that way, you
can open/browse/modify the mdb that the mde libary is based on. That should
work. If you *do* make changes to the libary code, the you would have to
wait untill you exit the appcaton that is "holding" the mde.

I am rather surprixed that you can catuly set a refernece to a mdb file
anway (a mde at elast forces the code to be compiled).



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal



这篇关于我自2000年以来每个新版本Access的仪式问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆