MS Access 2010中的Date()函数
问题描述:
嘿程序员,
有没有人听说过Date()函数不再工作(或者在MS Access 2010中的工作方式不同?我有一个MS Access 2007 DB工作了但是,我们有很多机器在同一个前端运行,而MS Access 2010机器会产生一个错误,在使用该功能的代码行中找不到该功能。
>
任何想法?
这是产生错误的查询行:
Hey coders,
Has anyone heard anything about the Date() function no longer working (or working differently in MS Access 2010? I have an MS Access 2007 DB that has worked perfectly, however, we have a bunch of machines running on the same front end, and the machine with MS Access 2010 generates an error that the function cannot be found in the line of code that uses that function.
Any ideas?
This is the line of the query that generates the error:
展开 | 选择 | Wrap | 行号
答
我在Access 2010中使用日期功能很多,没有发现任何问题。
应用程序是否可信?
I use the date function in Access 2010 alot, without noticing any problems.
Is the application "Trusted"?
我们的网络纳粹可能已经为新系统改变了这一点。我会看一看,看看能找到什么。谢谢!
Our Network Nazis may have changed that for the new systems. I''ll give a look and see what I can find. Thanks!
TwinnyFo:
我是否正确阅读了???
你有一个前端,多个用户是从同一个文件打开?
你有v2007和v2010打开同一个文件吗?
哎哟。我想你可能有一个文件锁定问题
你发布的内容我怀疑只是实际代码的一部分:请发布错误。 num,err.desciption
你的V2010正在折腾你的方式。
-z
TwinnyFo:
Did I read that correctly???
You have a single front-end that multple users are opening from the same file?
You have v2007 and v2010 opening that same file?
Ouch. I think you may have a file-locking issue
What you''ve posted I suspect is only a part of the actual code: Please post theerr.num , err.desciption
that your V2010 is tossing your way.
-z