我可以在其他人正在使用它的同时编辑访问后端文件吗? [英] Can I edit access backend file while others are using it?

问题描述

当其他人正在使用Access数据库的后端文件时，我可以编辑多少?我的理解是，你做不到，但是我想先确认一下，然后再从事很多深夜.关于我可以编辑多少"，我的意思是诸如向表中添加字段，删除它们，添加新表等任务.

How much can I edit a backend file of an Access database while others are using it? My understanding has been that you can't, but I wanted to confirm that before I commit to a lot of late nights. And in regards to "how much can I edit it", I mean tasks such as adding fields to tables, deleting them, adding new tables etc.

此外，与使用SQL Server后端相比，这有何不同?

Also, how does this compare to working with an SQL Server backend?

如果不明显，我的数据库将被拆分，并且当前一次只有少量的用户(1-2).我正在使用Access 2007

If it's not apparent, my database is split, and I currently have a low number of users (1-2) on it at a time. I'm using Access 2007

谢谢.

推荐答案

我不会编辑实时后端，但是，您可以在一个空副本上进行大部分或全部更改，而仅将实时附加只需少量的SQL和VBA即可将数据存储到各个表中.

I would not edit a live back-end, however, you can make most, or possibly all, of your changes on an empty copy and just append the live data to the various tables with a little SQL and VBA.

这篇关于我可以在其他人正在使用它的同时编辑访问后端文件吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！