English 中文(简体)
相关的表格有时是锁定的MS Access VBA。
原标题:Linked tables are sometimes locked MS Access VBA

I have two MS Access files (.mdb) one is called "A" and the second one is called "B". A contains the database tables and B is read only and contains reports. B also contains Tables and are linked to the tables of A. When I run a report from B, the linked tables are locked and give me nothing. Is there any solution for that? Thanks,

问题回答

除重述意见外,如果你设立了B.mdb,只读作让用户不改变报告,那么你可以通过将MDE从B.mdb中删除来实现同样的目的。 它有效地汇编现有的多边开发银行,并转录编辑表格、报告等。 数据可以改变,我认为宏观产品可以进口/出口,但可以进口/出口。

你们可以这样做:工具——和;数据库——和;生产MDE





相关问题
Handling no results for docmd.applyfilter

I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...

Outlook 2007 CommandBarControl.Execute won t work

I recently switched to Outlook 2007 and noticed that my VBA-macros won t work. I use the following code to open a new appointment-item (and fill it automatically). It worked perfect in Outlook 2003, ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

MS Access: list macro from VBA

I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...

热门标签