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
23 3237
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.
Access "helpfully" sets them for you when you create primary or foreign keys or a sort order, etc.
yes, 'helpfully'. I've gone through and checked each table as you've described, and I don't see any Indexes. It also will not allow me to delete a table-it says the microsoft jet engine has gone on vacation or something-can't find the object. It will not allow me to import data using the odbc connection-it says invalid argument. Won't let me compact and repair-invalid argument.
I usually have to rebuild the whole db. Any ideas would be greatly appreciated.
K
yes, 'helpfully'. I've gone through and checked each table as you've described, and I don't see any Indexes. It also will not allow me to delete a table-it says the microsoft jet engine has gone on vacation or something-can't find the object. It will not allow me to import data using the odbc connection-it says invalid argument. Won't let me compact and repair-invalid argument.
I usually have to rebuild the whole db. Any ideas would be greatly appreciated.
K
Sounds like corruption.
Try importing the objects into a new database.
Sounds like corruption.
Try importing the objects into a new database.
That's what I do. I actually created a 'shell', and have to go back and get that and start importing objects into it, which definitely works, but I just don't understand why it keeps happening. I spend a lot of time starting over, rebuilding it because this happens and I can't think of anything I'm doing that could cause it.
Thank you.
With just a couple of tables and a couple of queries, I find it somewhat odd that you have nearly 2 gigs of size in this database! If that isn't actually a misprint, I would immediately suspect a couple of things:
Primarily using transferring such a large database over a network is extremely susceptible to corruption introduced by faulty network equipment. This link contains some extremely good information about the possible causes of corruption in linked databases, and reading through your post, the first thing I would check is the network hardware for dropped packets. The IT guys or gals likely won't enjoy having their hardware brought into question, but if you do a simple ping request it could give you an idea if the hardware is, in fact, dropping any packets.
The second thing that comes to mind is that you might benefit from the command line decompile method. Allen Browne's site contains a number of steps to try in recovering from corruption. The decompile command and syntax is on his page as well.
Good luck!
Regards,
Scott
... Some of the tables are very large and only linked in, some are imported. The ODBC is a pervasive odbc engine interface.
...
Hi. What is it you link to via ODBC? I use Oracle InstantClient to link to an Oracle student records system. InstantClient is distributed and maintained by Oracle itself, but I have found that it is not fault tolerant of (in particular) date-time values it sees as incorrect in some linked Oracle tables, and it stops returning records altogether when faced with just one date-time error in a large dataset. I also find that live ODBC links to the Oracle system are very slow in operation.
For this reason I copy the main tables I link via ODBC to off-line copies on the Access database. There are a lot of rows in some of these tables (175,000 in a student table, for instance). In native Access queries on the off-line tables work well, but via ODBC the performance is so poor (often two or three orders of magnitude poorer than native Access) that I would not be able to work live on these tables at all. the overall DB size of my ODBC off-line linked Db is smaller than yours - 0.5Gb vs 2Gb - but even so I have never experienced any Access data corruption issues in more than a year of daily off-line updates to the tables via ODBC.
Your ODBC driver may be a much better performer than mine, and you might have no integrity issues with the linked tables; however, the constant problems you are experiencing suggest some form of error occurring between the database engine and its tables, which is quite unusual with Access in my experience.
-Stewart
o.k. one idea that might help is to unlink the huge tables and use the properties sheet in the query to include a "Source connect string" it might not be as quick but it is an idea.
Another idea is that you could create a view (query) in the original database with only the records needed at the time and link to that.
NeoPa 32,556
Expert Mod 16PB
Like the others, I think this is a size problem.
Is it possible to remove some of your tables to a back-end database and keep them clear of the main front-end code one.
Sorry if this describes what you've already done somewhat, I wasn't clear exactly what was linked where from your description. If any individual table is getting near that size then you need to consider using other software (at least for the back-end).
Hi everyone, and thanks for replying
I'll read through all of your comments and links and will hopefully find something that can help me out.
With regard to the comment about the network, the db is local when i'm working with it so I'm not sure that network problems would be causing this but I will investigate this suggestion further. Thank you.
With regard to the comments about size and such, I really do believe that the size is potentially part of the problem because every month, the tables I am linking to do get larger. I will more carefully evaluate all of your suggestions. Thanks to all of you.
I will no doubt have more questions or will at least post what works and what did not, for those interested. Thanks again.
K
NeoPa 32,556
Expert Mod 16PB
What lovely manners - always a pleasure :)
Good luck with your investigations.
What lovely manners - always a pleasure :)
Good luck with your investigations.
I think that everyone was responding to my desperation so having good manners is the least I can do!
NeoPa 32,556
Expert Mod 16PB
It's nevertheless a pleasure dealing with you :)
It's nevertheless a pleasure dealing with you :)
thanks! you too......i'm glad i found an environment that welcomes all......
It's nevertheless a pleasure dealing with you :)
while you're there, i've got kind of a silly question-could it be that i am bouncing back and forth betwee 2000 and 2003 when opening the database, and that's what's causing the corruption?
it's about two gigs
Since I'm here.
Even close to the 2 gig limit is enough to make it bomb out and completely corrupt the db. I don't think switching between versions should cause you grief. I do that quite often, with many different versions over the years.
See the post: http://www.thescripts.com/forum/post3099476-10.html
i think i've got the perfect solution: tel my boss i don't want to work with databases anymore.......thanks!
No! Don't do that db's can be lots of fun once you understand them. Not to mention decent money can be a result as well. Have you tried to implement any of the suggestions mentioned in the previous posts? If so which one and where do you stand?
NeoPa 32,556
Expert Mod 16PB
i think i've got the perfect solution: tel my boss i don't want to work with databases anymore.......thanks!
LOL
Great idea - except you'd be losing out on a lot of fun. The idea of seeing their face when you told them would be worth a laugh though :D
Anyway, can you explain what is actually in the db that gets corrupted. I'm thinking of how big that one actually is (rather than databases it simply links to)?
I haven't worked with it in a couple of weeks. but check this post at the beginng of April if you want to see me yelling and whining about it. As far as I can remember, it just doesn't open the tables, there are no links in any of them, it doesn't allow me to compact and repair, it's only two of the tables and they're both linked, and that's all I can remember. But when I start whining in April, I will try to be methodical in my whining. No guarantees about my yelling tho. Thanks!
NeoPa 32,556
Expert Mod 16PB
Sounds good. I'll wait for the details as I cannot progress without reliable details.
As soon as you post in here it will come up as a flagged thread that needs looking at, so no worries about continually monitoring ;)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Owen Jenkins |
last post by:
Hello.
For years I've been using the DBEngine.CompactDatabase code to make
backups of backend databases. But now I've struck a baffling problem
where I get an Invalid Argument error. This...
|
by: Pradeep MM |
last post by:
Hi Folks,
I have a issue in Micosoft Jet 4.0 OLEDB.
I am doing a repeated append of data into Microsoft
Access 2002 (XP). For a few files I get the error as
INVALID ARGUMENT.
When I try to...
|
by: Gianluca |
last post by:
This is the simplified code I'm trying to generate:
ilg.DeclareLocal(typeof(int)); // define local integer
Label exit = ilg.DefineLabel(); // define "exit" label
...
|
by: llevi |
last post by:
Hi there,
My aspnet_state.exe service is failing to start due to an invalid argument.
Does anyone know what arguments are required/valid for this service.
I am running XP pro, .NET Framework v...
|
by: Timbo |
last post by:
Hi all,
This is my first message here so i'll try and include all the
information that will help you help me out, if possible.
Basically I am using C# in ASP.NET 2.0 and have a Repeater...
|
by: Nathan Sokalski |
last post by:
I have a DataList in which the ItemTemplate contains two Button controls
that use EventBubbling. When I click either of them I receive the following
error:
Server Error in '/' Application....
|
by: dennijr |
last post by:
ok, shell always used to be easy for me, now its starting to get annoying cause i dont know wats wrong
heres the simplist code possible:
Private Sub IExplorer_Click()
a = Shell("C:\Program...
|
by: robert |
last post by:
On a server the binary (red hat) installed python2.4 and also a
fresh compiled python2.5 spits "sem_post: Invalid argument".
What is this and how can this solved?
Robert
==============
...
|
by: Lambda |
last post by:
When I call the standard strncpy function, I provide it a negative
argument,
such as:
strncpy(s, ct, -1)
I compile the code with gcc, when I run, it says "Segmentation fault".
Do you think...
|
by: 200dogz |
last post by:
Hi guys,
I want to have a button which opens up a new window when pressed.
<asp:Button ID="Button1" runat="server" Text="Open new window" />
...
Button1.Attributes.Add("OnClick",
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |