IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New DAMN IT, this is infuriating.
SOMETHING in an SQL Server database is thoroughly farking up Access. Access 97, Access 2000, and Access XP. It just started recently and the guy who manages the SQL data swears he didn't do anything different to it. Certainly not anything different to the fields I'm importing. Access just keeps giving me that useless "Invalid argument" error whenever I try to import it. It's not the structure, because I can Import the resulting table devoid of actual data.

Does SQL do something bizarre with Null data?

I've used up every nasty work I can think of and have resorted to fantasizing about shoving a keyboard up Steve Ballmer's ass.
New MDAC > 2.5?
The MDAC version on the client probably needs to be in a certain range for later versions of the -ahem- database.
-drl
New Re: MDAC > 2.5?
I thought maybe it was one of the References, specifically DAO 3.6 Object Library, but that only worked once.

Here are the references for one that does NOT import:
Visual Basic for Applications
Msft Access 9.0 Object Library
Msft DAO 3.6 Object Library
OLE Automation
Msft ActiveX Data Objects 2.1 Library

Here are the references for one that DOES import (brand new MDB):
Visual Basic for Applications
Msft Access 9.0 Object Library
OLE Automation
Msft ActiveX Data Objects 2.1 Library

I tried removing the DAO 3.6, and that worked once.
Expand Edited by acagle June 9, 2003, 03:31:00 PM EDT
New Re: MDAC > 2.5?
Just for the hell of it, install MDAC_TYP 2.6 (get it from the beast) and see what happens.
-drl
New Re: MDAC > 2.5?
I tried 2.7 and that didn't do anything. I briefly thought I had it fixed by using the DAO 3.51 instead of 3.6; it worked for a while, but now it's doing the same thing again.

I think I will have to enlist the Uber-nerd from downstairs for one final attempt before I reformat the whole $)@#$^*(#&$^ thing.
New Re: MDAC > 2.5?
Curious - don't some of the latter versions of Windows (since ME) have silent "system restore"? After installing DAO of proper version, set a checkpoint ("System Information" tool, "System File Checker" in Windows 98SE), so the thing doesn't get rolled back.

This is what sucks the most about Windows - diagnosing problems in the dark.
-drl
New Re: MDAC > 2.5?
If only their error messages wouldn't be so darned helpful. . . . .
     More Access problems -- this time with SQL Server, too! - (acagle) - (9)
         No solution for that context... - (ChrisR)
         Hmmmmm. . . . . . - (acagle)
         DAMN IT, this is infuriating. - (acagle) - (6)
             MDAC > 2.5? - (deSitter) - (5)
                 Re: MDAC > 2.5? - (acagle) - (4)
                     Re: MDAC > 2.5? - (deSitter) - (3)
                         Re: MDAC > 2.5? - (acagle) - (2)
                             Re: MDAC > 2.5? - (deSitter) - (1)
                                 Re: MDAC > 2.5? - (acagle)

Goose-bumps for any who Know.
59 ms