Hello,

Immediately after upgrading win98 to winME, one of the programs I use
to control an access database,  which used to work okay, now throws up
a runtime error 3027 "Cannot update. Datebase or object is read only".

The database is read/write and sharable on an NT server and for
everyone else still using win98 the program works okay.

The line which fails for me but works for everyone else is

appAccess.DoCmd.TransferText acImportDelim, "TSVfile", "BQ", TSVNAME

I can go into Access and manually import the data so the problem is
with the remote VB program and not with Access.

Incidentally, all other editing features of the remote access program
work okay. It's just the block import which doesn't work.

I'd be grateful if anyone could point me in the right direction.

Jim.

: Hello,

: Immediately after upgrading win98 to winME, one of the programs I use
: to control an access database,  which used to work okay, now throws up
: a runtime error 3027 "Cannot update. Datebase or object is read only".

: The database is read/write and sharable on an NT server and for
: everyone else still using win98 the program works okay.

: The line which fails for me but works for everyone else is

: appAccess.DoCmd.TransferText acImportDelim, "TSVfile", "BQ", TSVNAME

: I can go into Access and manually import the data so the problem is
: with the remote VB program and not with Access.

: Incidentally, all other editing features of the remote access program
: work okay. It's just the block import which doesn't work.

: I'd be grateful if anyone could point me in the right direction.

Try resinstalling Access.  What you're calling is an Access method,
not VB or DAO, and it's possible that ME decided to foobar one or more
of the Access DLLs.

If this were your only issue, I'd consider writing your own code to do
the import.  It isn't that hard.

Joe

I tried the re-install but still the same problem. I will do as you
suggest and re-write it in vb.

Thanks

Jim.