错误7874无法找到对象tableName [英] Error 7874 Can't find the object tableName

问题描述

我有一个链接到SQL Server数据库的MSAccess数据项目前端。

我一直得到错误号码7874：数据库找不到对象tblname

当我看到桌子就在那里。

我打电话给删除表中所有记录然后使用新记录重新创建它的过程。

因此表永远不会被删除和重新创建。

一旦程序运行，然后我将表传输到本地目录。


当我运行它时它会起作用。但是，当我尝试让用户执行此操作时，他们会收到错误 - 这没有任何意义，因为表仍然存在，并且过程调用已经起作用，因为表中包含所选信息，它只是不会转移它吗？


有人可以帮帮忙吗？


谢谢。

解决方案

这应该是一个SQL Server线程而不是Access，但除非我猜错，否则这是一个权限问题。用户可能看不到表，除非它们已设置为访问SQL Server。

作为开发人员，几乎可以肯定已经为您的帐户完成了。

检查了我能想到的权限，对于用户而言，一切看起来都很好。

我认为你不能在访问数据项目中使用t transfertext方法。似乎没有办法为导出格式创建规范/模板，我可以告诉它使用tab作为分隔符。

trytput to method，但是这并没有给出文本文件中需要的结果。


如何将表格放入由制表符分隔的文本文件中的任何其他想法？

它会不会让你知道我仍然认为这是权限问题吗？

如果你愿意，我可以把它移到SQL Server论坛。如果无论如何都拒绝访问SQL Server表，我根本无法看到其他想法。遗憾。

I have an an MSAccess data project front end linked to an SQL Server Database.
I keep getting Error number 7874: database cannot find the object tblname
when I look however the table is there.
I am calling a procedure which deletes all records in the table and then repopultates it with new records.
so the table is never deleted and recreated.
Once the procedure has run, then I transfertext the table to a local directory.

this works when I run it. However when I try and get the user to do it, they get the error - which doesn''t make any sense, because the table is still there, and the procedure call has worked because the table has the selected information in there, it just won''t transfer it???

Can anyone help out on this please?

thanks.

解决方案

This should probably be a SQL Server thread rather than Access, but unless I miss my guess, this is a permissions issue. A table may well not be visible to the user unless they have been set up to access SQL Server.
As a developer, it''s almost certainly been done for your account.

Hi,
have checked permissions everywhere I can think of, for the user, and all looks fine.
I don''t think you can use t transfertext method in access data project. there doesn''t seem to be a way of creating a specification/template for export format, where I can tell it to use tab as a delimiter.
triedtput to method, but that does not give the required result in the text file.

any other ideas of how to get a table out into a text file delimited by tabs?

Would it surprise you to know I still think it''s a permissions issue?
I can move this over to the SQL Server forum if you like. I can''t see other ideas as helping at all if the access to the SQL Server table is denied anyway. Sorry.

这篇关于错误7874无法找到对象tableName的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！