无效的论点 [英] Invalid Argument

问题描述

嗨


我有一个数据库，我一直有问题。有时它们是无效的参数问题，有时还有其他问题（例如记录太大）。有些表非常大，只能链接，有些是导入的。 ODBC是一种普遍的odbc引擎接口。


过去，通过压缩和修复数据库，一些问题已经消失。尽管如此，由于它的长期问题（我继承了它），很难继续使用这个东西。它确实做得不多;一些查询通过宏运行以产生两个最终表。这是每个月完成的。在这一点上，这是两场演出。我把它复制到我的本地电脑上工作并在完成后把它放回到sfa上。


最近，我用它来增加一个表，这是链接。我和那个表有类似的问题，就像我对另一个大的链接表一样，所以我创建了一个查询，使其变小，就像我对另一个表一样。我成功地制作了一张小桌子。然后我运行了一个查询，将来自此表和其他几个表的数据合并到一个表中。


我将这一个最终表复制到一个空白数据库中并进行了一些操作。当我尝试复制表时，我现在再次收到Invalid Argument消息。此外，当我尝试删除一个表，这是一个更大的表的提取，我收到一条消息''ms jet数据库引擎无法找到对象'〜tmpclp160061。确保对象存在，并且你正确地拼写它的名字和路径名称（'好像我的名字错了......）。


每个人的'发布在这里，我打开了一个空白数据库，并尝试导入表创建问题。然后我得到一条消息，我有太多的索引。我不知道如何删除这些索引。如果我查看此表中每个字段的属性，它们都不会设置为索引。


我已设法创建一个包含表和查询的新数据库我需要。有没有人对我应该对原始数据库做什么有任何想法。几乎看起来原始数据库中的某些东西引起了问题，即使我从该数据库中获取此表。任何建议都会非常欣赏。我准备好跳（开玩笑......）


谢谢

K

Hi

I have a database, with which I have always had problems. Sometimes they were Invalid Argument problems, and sometimes there were others (such as that the record was too large). Some of the tables are very large and only linked in, some are imported. The ODBC is a pervasive odbc engine interface.

In the past, some of the problems have gone away by compacting and repairing the database. Still, it''s difficult to keep working with this thing because of the chronic problems with it (I inherited it). It doesn''t do much really; some queries are run via a macro to produce two final tables. This is done every month. At this point, it''s about two gigs. I copy it to my local pc to work with it and put it back on an sfa when I''m done.

Recently, I used it to add one more table, which was linked. I had similar problems with that table as I had with another large, linked table, so I created a query to make it smaller just as I do with the other table. I was successful in producing a smaller table. I then ran a query that combined data from this and several other tables, into one table.

I copied this one final table into a blank database and did some manipulations. I''m now getting the Invalid Argument message again when I try to copy the table. Also, when I try to delete a table that is an extract of this bigger table, I get a message of ''the ms jet database engine could not find the object ''~tmpclp160061. Make sure the object exists and that you spell its name and the path name correctly'' (as if I could get that name wrong....).

Per someone''s post here, I opened a blank database and tried to import the table creating the problems. I then got a message that I have too many indexes. I''m not sure how to delete these indexes. If I look at the properties of each field in this table, none of them are set to ''Index''.

I have managed to create a new database containing the tables and queries I need. Does anyone have any ideas for what I should do with the original database. It almost seems like that something in the original database is causing the problem even tho I have gotten this table out of that database. Any suggestions would be greatly appreciately. I''m about ready to jump (kidding......)

Thanks
K

推荐答案

在设计视图中打开表，然后转到View - Indexes。这些是表索引。您需要删除其中的一些。

Open table in design view and then go to View - Indexes. These are the table indexes. You will need to delete some of these.

在设计视图中打开表格，然后转到视图 - 索引。这些是表索引。您需要删除其中一些。

Open table in design view and then go to View - Indexes. These are the table indexes. You will need to delete some of these.

谢谢。我会试试看。


愚蠢的问题：这些索引是如何设置的？

Thanks. I''ll try it.

Stupid question: how did these indexes get set?

谢谢。我会试试看。


愚蠢的问题：这些索引是如何设置的？

Thanks. I''ll try it.

Stupid question: how did these indexes get set?

访问有帮助在创建主键或外键或排序顺序等时为您设置

Access "helpfully" sets them for you when you create primary or foreign keys or a sort order, etc.

这篇关于无效的论点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！