More Access Bizarreness

[Mike Labosh]

I'm trying to import a delimited txt file into Access 2000.

I'm importing this into a new table. Tab Delimited, Quoted Text & Column
Headers. Child's play, right? It b0rked at me with:

"Can't finish updating records because the user named in the previous
message is editing them. wait until the other user finishes and then click
ok again, or click cancel to discard your changes"

I'm the one creating the table from an import. There are no other users in
this table. WHAT previous message? Clicking ok gives me the same message
several times in a row, and then clicking cancel yields another error, this
time saying "Invalid Database Object", and leaves me at the final screen of
the import wizard. So I cancel the import wizard, and re-run it. I select
my txt file and click the advanced button to select my IMEX Specification.
Upon clicking the advanced button, it complains thus:

"Advanced option not available. This option requires the file acwzlib.mde
to be read/write." So I go check on the dumb wizard library, and sure
enough, it's read/write.

I created this database a couple hours ago and have been loading data files,
each file into its own table. Then suddenly I get all this attitude. It's
nowhere near the 2-gig limit, either.

What else should I be looking at?

--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

 

['69 Camaro]

Hi, Mike.

WHAT previous message?

Access users aren't supposed to see either message. The first one was
suppressed (or commented out), and this one should have been, too. The
Import Wizard encountered a record lock and is executing code in a loop
until either the record becomes unlocked (unfortunately, it won't), or the
user decides to cancel the operation. Once you cancel the operation, Jet
tries to rollback the transaction, but no explicit transaction was executed
before the operation began, hence the "Invalid Database Object" error
message.

What else should I be looking at?

Have you tried logging in as the computer's Administrator and using the
Import Wizard's "Advanced Options" button? If you are able to do so as the
Administrator, then it's a permissions issue. Things to check:

1.) Your Windows user account may no longer have "Full Control" security
permissions on the directory where either the ACWZLIB.MDE file or your
Windows user account's TEMP directory is located, or

2.) The permissions set on the Windows Registry keys don't allow your
Windows user account to read the appropriate keys, or

3.) You've run out of disk space, either in your Windows user account's
TEMP directory or the drive where Access is installed, or

4.) Your ACWZLIB.MDE file is corrupted.

If all of the above seem to be in order, then verify that you have MS Office
2K SP-3, Jet 4.0 SP-8, and MDAC 2.8 installed on your computer.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)