打开连接到Excel的数据时，访问表单显示为空白 [英] Access forms appear blank when data connected to excel is open

问题描述

嗨 - 我有一个从访问数据库导入的电子表格，换句话说，它连接到外部数据库。数据库是分开的，当我尝试在此电子表格打开时打开前端时，我在表单中看不到任何内容。当我关闭excel电子表格然后打开前端时，这一切看起来都很好。我不确定我做错了什么。


数据库（后端）和电子表格都位于网络共享驱动器上。


你们有什么建议可以解决这里发生的事情。


谢谢，

Stan


PS：我也想在excel论坛上发布这个问题。

Hi - I have a spreadsheet that I imported from an access database, so in other words, it is connected to an external database. The database is split and when I try to open the front end while this spreadsheet is open, I do not see any content in my forms. It all looks good when I close the excel spreadsheet and then open the front end. I am not sure what I am doing wrong.

Both the database (back end) and the spreadsheet are located on network shared drive.

Do you guys have any suggestions as what is possibly happening here.

Thanks,
Stan

PS: I am going to post this question on an excel forum too.

推荐答案

你是否在表格中打开表格会做什么更新？您无法同时在两个不同的程序中打开工作表进行更新。


如果您想打开工作表仅查看，请尝试更改表单的数据查询ReadOnly，这可能解决这个问题。


或者您可能想要添加一些错误检查，以便可以识别问题并显示一个消息框，告诉对不起，表格现在很忙


如果这还不够，请在程序中发布一些问题代码。


Jim

Are you opening the sheet in a form that will do any updates? You can''t open a sheet for update in two different programs at the same time.

If you want to open the sheet to view only, try changing the form''s data query to ReadOnly, that might solve this.

Or you might want to add some error checking so that the problem can be recognized and a message box is displayed telling "Sorry, the sheet is busy now"

If this is insufficient, please post some code from the program with the problem.

Jim

你好吉姆 - 我没有在表格中打开表格。这就是我在做的事情。

我在桌面上打开的唯一应用程序是excel电子表格。因此，在空白页上，我通过转到数据选项卡和外部数据组导入访问表（位于网络上的BE）。我选择了我想要的表格，现在工作表填充了访问表。当这张表仍然打开时，我打开桌面上的表格（前端）。我能够看到有按钮的表单，但是我没有在组合框和文本框等表格上看到任何内容。


我想打开工作表来创建数据透视表和图表。我不确定如何将数据查询更改为仅按照您的建议阅读。


我注意到的另一件事是，当我点击最终打开但没有内容的表单需要很长时间打开并在底部状态栏上显示错误消息此记录集不可更新


我要求其他用户将数据从访问中导入到工作表中他是能够查看所有表格。在我的情况下，当我打开表单时，我分发前端的其他用户面临同样的问题，即没有在具有组合框，文本框等的表单中看到任何内容......


我不确定我是否已经提供了足够的信息来解决这个问题。再次感谢。

Hi Jim - I am not opening the sheet in a form. This is what I am doing.
The only application that I have open on my desktop to begin with is an excel spreadsheet. So on a blank sheet, I import an access table (BE located on the network) by going to Data tab and external data group. I select the table that I want and the sheet is now populated with access table. While this sheet is still open, I am opening the form (front end)located on my desktop. I am able to see the forms which has buttons, however I do not see any contents on forms which has combo boxes and text boxes and such.

I want to open the sheet to create pivot tables and charts. I am not sure how to change the data query to read only as you suggested.

Another thing I noticed, when I click on a form which ultimately opens with no content takes a long time to open and it displays an error message on the bottom status bar "this record set is not updateable"

I asked another user to import data into a sheet from access be and he is able to view all the forms. In my case when I have the sheet open, other users whom I have distributed the front end are facing the same problem of not seeing any content in forms which has combo boxes, text boxes etc...

I am not sure if I have given you enough information to trouble shoot this further. Thanks again.

如果Excel打开文件，则该文件被锁定。固体。您无法从Access同时访问。它只是不会发生。

If Excel has the file open then that file is locked. Solid. You won''t have simultaneous access from Access. It just aint gonna happen.

这篇关于打开连接到Excel的数据时，访问表单显示为空白的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！