2003 - 2010年MDE问题 [英] 2003 - 2010 MDE problems
问题描述
嗨Fellas，已经有一段时间了，
2003年写的项目有点问题（显然是访问）....我们最近升级到2010年的工作，现在MDE似乎不起作用（在2010年），但MDB似乎正常工作。
我现在没有时间做任何繁重的工作，所以我希望它会正常工作，如果我把它转换成新的文件格式我会遇到任何困难？
我收到的消息（在2010年运行MDE时）是这样的：
Hi Fellas, its been a while,
Got a little problem with a project written in 2003 (access obviously).... we recently upgraded to 2010 at work, and now the MDE appears to not work (in 2010) however the MDB works fine so it seems.
I dont have the time right now to do any heavy work on this so i was hoping it would "just work", if i converted it to the new file formats would i encounter any difficulties?
the message i get (when running the MDE in 2010) is this:
推荐答案
该查询不应该在任何版本中运行。我假设SQL来自查询的WHERE子句。您不能在WHERE子句中使用聚合函数，将其移动到HAVING子句。
That query shouldn''t run in any version. I assume that SQL is from the WHERE clause of a query. You can not use aggregate functions in the WHERE clause, move it to a HAVING clause.
这是在执行代码期间收到的特定错误，它在2003年完全正常，所以我不期望查询本身有什么问题，正如我所说，完整版本在2010年工作，而不是MDE文件。
Thats the specific error received during execution of the code, it works perfectly fine in 2003 so i dont expect there is anything wrong with the query itself and as i say, the full version works in 2010, just not the MDE file.
Dan2kx：
它在2003年完美无缺，所以我不指望查询本身有什么问题
Dan2kx:
it works perfectly fine in 2003 so i dont expect there is anything wrong with the query itself
这不是可靠的逻辑。它可能指向这一点，但在一个版本而不是另一个版本中忽略问题是完全可能的。当然，期望版本之间的变化。我不是说这就是问题，只是你不能依赖这样的逻辑来假设它不可能。
你是说MDB文件在2010年工作正常当您遇到上述问题时，使用MDE尝试时完全一样吗？
That is not reliable logic. It may point towards that, but it''s perfectly possible for problems to be overlooked in one version but not another. Changes between versions are to be expected of course. I''m not saying that is the problem, just that you cannot rely on such logic to assume it cannot be.
Are you saying that the MDB file works fine in 2010 when doing exactly the same thing as you did when trying it with the MDE when you got the above problem?
这篇关于2003 - 2010年MDE问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
