没有64位Jet（MS Access）OLEDB驱动程序。 [英] there is no 64-bit Jet (MS Access) OLEDB driver.
问题描述
由于没有64位Jet（MS Access）OLEDB驱动程序，这个delimma的推荐解决方案是什么？
我们的应用程序使用SQL Server作为数据库引擎，但我们有一个大约5兆的静态数据存储在Access数据库中。我们选择了
因为它易于阅读，并且可以受密码保护。
由于Microsoft没有64位OLD可以访问，应用程序将
设置为以100％32位模式运行以使其运行。这打破了使用64位操作系统的目的。
我有什么选择？
谢谢。
Darin
***通过Developersdex发送 http://www.developersdex.com ***
Since there is no 64-bit Jet (MS Access) OLEDB driver, what is the
recommended solution for this delimma.
Our application uses SQL Server as the daatabase engine, but we have
about 5 meg of static data stored in an Access database. We chose that
because it is easy to read, and can be password protected.
Since Microsoft doesn''t have a 64-bit OLD to Access, the application has
to be set to run in 100% 32-bit mode to get it to run. This defeats the
purpose of having a 64-bit OS.
What are my options here?
Thanks.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
推荐答案
由于您已经在使用SQL Server，为什么不将静态数据移动到它？
并使用Access链接到SQL静态数据？
Mike。
达林 < darin_nospam @nospameverwrote in message
news：OT ************** @ TK2MSFTNGP02.phx.gbl ...
Since you are already using SQL Server, why not move your static data to it
and use Access to link to the SQL static data?
Mike.
"Darin" <darin_nospam@nospameverwrote in message
news:OT**************@TK2MSFTNGP02.phx.gbl...
由于没有64位Jet（MS Access）OLEDB驱动程序，这个delimma的
推荐解决方案是什么。
我们的应用程序使用SQL Server作为数据库引擎，但我们有一个大约5兆的静态数据存储在Access数据库中。我们选择了
因为它易于阅读，并且可以受密码保护。
由于Microsoft没有64位OLD可以访问，应用程序将
设置为以100％32位模式运行以使其运行。这打破了使用64位操作系统的目的。
我有什么选择？
谢谢。
Darin
***通过Developersdex发送 http://www.developersdex.com ***
Since there is no 64-bit Jet (MS Access) OLEDB driver, what is the
recommended solution for this delimma.
Our application uses SQL Server as the daatabase engine, but we have
about 5 meg of static data stored in an Access database. We chose that
because it is easy to read, and can be password protected.
Since Microsoft doesn''t have a 64-bit OLD to Access, the application has
to be set to run in 100% 32-bit mode to get it to run. This defeats the
purpose of having a 64-bit OS.
What are my options here?
Thanks.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
好的，除非是在SQL数据库中，当我们在他们的系统上安装一个
更新时，需要将新的静态数据写入
SQL db，这就是Access的目的 - 我们可以提供MDB并且它永远不会改变。
我们的MDB有菜单（旧的访问交换机类型逻辑），以及所有的
视图，存储过程，函数等的SQL定义。
Darin
***通过Developersdex发送< a rel =nofollowhref =http://www.developersdex.comtarget =_ blank> http://www.developersdex.com ***
Ok, except that if it is in the SQL database, then when we install an
update on their system something needs to write new static data to the
SQL db, that was the purpose of Access - we can supply the MDB and it
never changes.
Our MDB has the menu (old access switchboard-type logic), and all of the
SQL definations for view, stored procedures, functions, etc.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
拆分您的访问权限进入前端用户界面和后端数据库。
然后将后端移到SQL Server。
迈克。
" Darin" < darin_nospam @nospameverwrote in message
news：uc ************* @ TK2MSFTNGP05.phx.gbl ...
Split your access into a front end user interface and a back end database.
Then move the back end to SQL Server.
Mike.
"Darin" <darin_nospam@nospameverwrote in message
news:uc*************@TK2MSFTNGP05.phx.gbl...
好的，除非它在SQL数据库中，那么当我们在他们的系统上安装
更新时，需要将新的静态数据写入
SQL db，这就是Access的目的 - 我们可以提供MDB，而且它是
永远不会改变。
我们的MDB有菜单（旧访问）交换机类型逻辑），以及用于视图，存储过程，函数等的所有
SQL定义。
Darin
***通过开发人员指南 http://www.developersdex.com 发送***
Ok, except that if it is in the SQL database, then when we install an
update on their system something needs to write new static data to the
SQL db, that was the purpose of Access - we can supply the MDB and it
never changes.
Our MDB has the menu (old access switchboard-type logic), and all of the
SQL definations for view, stored procedures, functions, etc.
Darin
*** Sent via Developersdex http://www.developersdex.com ***
这篇关于没有64位Jet（MS Access）OLEDB驱动程序。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
