在创建现有数据库的新版本时维护主题 [英] Maintaining Themes When Creating A New Version of an Existing DB
问题描述
我正在使用Access 2016
我有一个我正在为客户开发的数据库。我创建了3个环境，开发，测试和实时（生产）。
这个数据库中的表格使用办公室主题（回顾）来匹配公司的品牌。
我有一个例程，我跑到将数据库对象从开发复制到测试，然后将测试复制到实时。
这一切都很好，只是当我将对象从一个环境复制到另一个环境时，我在Dvelopment中使用的主题会丢失。主题默认为默认的办公室主题。
有没有办法使用VBA我可以控制在通过VBA创建新数据库时使用的办公主题
继承人我是如何从一个环境复制到另一个环境的。
1.我杀了数据库的旧备份版本
2，我将现有数据库重命名为dbnameBackUp
3.我创建一个空数据库
4.我将当前数据库中的所有对象复制到新数据库中。
这可能没有说清楚，所以如果我能以任何方式澄清，请告诉我。
提前致谢，
m
这是一种非常无效的方法，只是要求发生问题。
你应该做的是有一个连接到本地数据的前端。然后，当您准备发布它时，将其设置为和.accde并将表重新链接到网络位置。然后为用户发布数据库。
这将始终保留主题和外观，无论如何。
让我找到几个链接在这里解决这个问题。
我找到了它们 - 比我想象的容易得多。
使用前端和后端
使用新的前端更新用户 （特别是帖子＃5和＃8）。
非常感谢您的回复！这看起来对我来说效果很好。我已将数据库拆分为前端和后端。
这里有两件事可能值得一提。
1.由于某种原因，我无法从此数据库创建.accde文件。 （我本来打算对这个问题做一些研究。）
2.自从我担任承包商以来，我可能不是维护这个项目的人。我需要将其作为防弹。尽可能。
我曾计划在开发数据库中给我的继任者一个按钮，促进他们对测试环境所做的所有更改，同样从测试环境到生活"环境。
I am using Access 2016
I have a DB I am developing for a client. I have created 3 environments, Development, Test and Live(Production).
The forms in this database use an office theme (retrospect) to match the companies branding.
I have a routine that I run to copy the Database Objects from Development into Test and then Test into Live.
It all works well except that the theme I use in Dvelopment gets lost when I copy the objects from one environment to another. The theme defaults to the default office theme.
Is there a way using VBA that I can control what office theme is used when I create a new Database through VBA
Heres how I copy from one environment to another.
1. I kill the old back up version of the database
2, I rename the existing db as dbnameBackUp
3. I create an empty database
4. I copy all the objects from the current db into the new db.
This may not be stated very clearly so please let me know if I can clarify in any way.
Thanks in advance,
m
That is a highly inefective method that is just asking for problems to occur.
What you should do is have a front end that connects to local data. Then, when you are ready to publish it, make it into and .accde and relink the tables to the network location. Then publish the database for users.
This will always preserve the theme and appearance, no matter what.
Let me find the several links here that address this.
I found them -- a lot easier than I thought.
Working with Front and Back Ends
Updating Users with New Front Ends (particularly posts #5 and #8).
Thanks much for your response! This looks like it will work well for me. I already have the database split into front end and back end.
Here are two things that are perhaps worth mentioning.
1. For some reason I am unable to create an .accde file from this database. (I had planned to do some research on this problem.)
2. I may not be the person who is maintaining this project since I am working as a contractor. I need to make this as "bullet proof" as possible.
I had planned on giving my successor a button in the development db that promoted all the changes they made up to the Test environment and likewise from the test environment to the "Live" environment.
这篇关于在创建现有数据库的新版本时维护主题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
