为多个用户发布Access数据库 [英] Publishing Access Database for multiple users
问题描述
该数据库将包含约15个用户。
The database will be for about 15 users.
我已完成以下操作:
编译数据库
将数据库移至共享文件夹
Moved the database to a shared folder
拆分数据库(BE和FE)
Split the database(BE and FE)
从FE创建的ACCDE文件
Created ACCDE file from the FE
创建批处理文件 -
开始/最大"C:\Program Files \ Microsoft Office \ Office14 \ MSACCESS.EXE" "R:\SHARED \ research&reconcilation \TESTING\Reconclation-Unit-Tracking-System-mde.accde"
Start /max "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "R:\SHARED\research and reconcilation\TESTING\Reconcilation-Unit-Tracking-System-mde.accde"
退出
我注意到,如果一个人已经打开了批处理文件,批处理文件就不会打开访问文件。
I noticed that the batch file will not open the access file if one person already has it opened.
我需要做些什么才能解决这个问题?
What do I need to do to fix this issue?
有没有办法让用户不能成功能看到数据库的位置吗?我不希望人们弄乱这个文件。
Is there a way that I can make the user not to be able to see the location of the database? I don’t want people going to mess with the file.
我错过了其他任何程序吗?
Am I missing any other procedure?
谢谢!
推荐答案
我认为缺少的步骤是为每个用户提供他们自己的前端副本。让所有用户打开相同的前端文件并不是真正推荐的做法。
I think the missing step is to give each user their own copy of the front end. Having all users open the same front end file is not really a recommended practice.
只需要我的2美分......
Just my 2 cents...
这篇关于为多个用户发布Access数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!