是否可以将后端数据库的位置存储在表中？ [英] Is it possible to store the location of the backend database in a table?

问题描述

我的想法是拥有它，以便我有一个保存文件位置的表。然后，我将检查数据库，以查看首次打开数据库时该值是否为空。如果它是空白的，那么会出现一个小形式，允许输入位置，然后数据库可以像平常一样打开。这可能吗？


我需要这个的原因是我计划（希望）需要在多家公司安装，而不仅仅是同一家公司的多个用户。因此，我不知道后端将在每种情况下存储在哪里，我想要一个简单的方法告诉前端它在哪里。

My idea is to have it so that I would have a table that has the file location saved in it. I would then have the database check to see if that value is blank when the database is first opened. If it is blank, then a little form would appear that allows the location to be entered and then the database can open like normal. Is this possible?

The reason I need this is that I plan on (hopefully) needing to install this at multiple companies, not just multiple users of the same company. Therefore, I won''t know where the backend will be stored in each case and I want an easy way of telling the front end where that is.

推荐答案

短回答，是的，可以存储路径。我建议尽可能使用UNC路径。

Short answer, yes it is possible to store the path. I would recomend using the UNC path withever possible.

好的。所以我知道如何获得放入数据库的价值。然后我如何告诉Access链接表的位置是X？

Okay. So I know how to get the value put into the database. How do I then tell Access that the location of the linked tables is X?

啊，这将通过链接管理器。

我有一个非常简单一个......让我找到它。


您还可以看到应用程序启动位置，修订版等等。

Ah, that would be via the link manager.
I have a pretty simple one... let me find it.

You can also get super fancy that looks at application launch location, revisions, and so forth.

这篇关于是否可以将后端数据库的位置存储在表中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！