共享驱动器上MS Access的最佳替代方案 [英] Best alternative to MS Access on a shared drive
问题描述
大家好;
我在一家公司工作，该公司目前正在共享驱动器上使用MS Access
来自全国各地的人们访问。因为所有人都希望查看由我们（佛罗里达州）单独维护的单个数据库，每个地区
不能在他们的本地服务器上拥有自己的个人数据库（否则
我们必须更新几个数据库而不是一个中央数据库。
我们尝试拆分数据库，但它仍然太慢。考虑到基于网络的应用程序，我们现在是
。什么是
我们的最佳选择？他们正在寻找的是我们可以在公司访问的应用程序
内联网。任何建议表示赞赏。
在此先感谢。 :)
-
留言通过 http://www.accessmonster.com
Hi All;
I work for a company which is currently utlizing MS Access on a shared drive
where people from all over the country access. Because all are wishing to
view a single database maintained solely by us (in Florida), each region
cannot have their own individual database on their local servers (otherwise
we would have to update several databases as opposed to one central database).
We have tried splitting the database, but it is still too slow. We are now
considering a web-based application. What would be the best alternative for
us? What they are looking for is an application we can access on the company
intranet. Any suggestions appreciated.
Thanks In Advance. :)
--
Message posted via http://www.accessmonster.com
推荐答案
您可以编写完整的ASP.NET（或任何其他语言）你的数据库系统是前端的，但是如果你想要快速'n''脏，你可以试试
数据访问页面。
我在学区工作。当我遇到像你这样的情况时，我将b / b
放在服务器上，并在每个用户的PC上放置一个批处理文件的快捷方式。批处理文件将前端复制到用户的
计算机。用户可以对后端的数据进行更改，如果需要更改，则需要更改的是
服务器上的前端。
You could write an entire ASP.NET (or any other language) front-end for
your database system, but if you want a quick ''n'' dirty, you can try
Data Access Pages.
I work with school districts. When I run into a situation like yours, I
put the backend on the server and place a shortcut to a batch file on
each user''s PC. The batch file copies a front-end down to the user''s
computer. The user can make changes to data on the backend, and if
there''s an update all that has to be changed is the front-end on the
server.
Per Pamela来自AccessMonster.com:
Per Pamela via AccessMonster.com:
我在一家公司工作，该公司目前在共享驱动器上使用MS Access <来自全国各地的人们都可以访问。因为所有人都希望查看由我们（在佛罗里达州）单独维护的单个数据库，所以每个地区都不能在他们的本地服务器上拥有自己的个人数据库（否则我们将不得不更新几个数据库）数据库而不是一个中央数据库。
我们尝试拆分数据库，但它仍然太慢。我们现在正在考虑基于网络的应用程序。什么是
我们的最佳选择？他们正在寻找的是我们可以在公司内部网上访问的应用程序。任何建议表示赞赏。
I work for a company which is currently utlizing MS Access on a shared drive
where people from all over the country access. Because all are wishing to
view a single database maintained solely by us (in Florida), each region
cannot have their own individual database on their local servers (otherwise
we would have to update several databases as opposed to one central database).
We have tried splitting the database, but it is still too slow. We are now
considering a web-based application. What would be the best alternative for
us? What they are looking for is an application we can access on the company
intranet. Any suggestions appreciated.
区分后端和前端。后端是那些人们正在追求的那些表。
听起来像是将表移动到SQL Server的经典案例。
-
PeteCresswell
Distinguish between back and front ends. Back end being the tables that those
people are going after.
Sounds to me like a classic case for moving the tables to SQL Server.
--
PeteCresswell
我在这里解释一些可能的解决方案......还有一些涉及保持ms-access
原样
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
-
Albert D. Kallal（接入MVP）
加拿大艾伯塔省埃德蒙顿
pl ***************** @ msn.com
http://www.members.shaw.ca/AlbertKallal
I explain some possible solutions here..and some involve keeping ms-access
as is
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
这篇关于共享驱动器上MS Access的最佳替代方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
