Cannot Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My data base opens fine & I build a table of file names to be imported. When
I click on 2-3 of them & then click the "IMPORT" button, the DoCmd.ImportText
command gives me the 3027 message "Cannot Update. Database or object is read
only." for EACH file name. At least one table (ImportNames) has already been
updated, so I'm thinking it's an object, maybe the RawData table that I'm
importing INTO. This database worked fine a few weeks ago on my Win2K box,
but now on my XP box it fails. Both boxes run Access2000.
Can someone tell me how to remedy this. I'm under some mild pressure to
turn in my old laptop. Thanks. -Bill.
 
It's not completely clear to me what you mean by "build a table of file
names" and then you "click on 2 - 3 of them". Are you doing this on a form,
and the "IMPORT" button is on the form, and the button runs code that
includes the DoCmd.ImportText action?

Assuming that the answers are yes, the error message that you get can result
from different causes.

(A) For security reasons, newer versions of ACCESS will not import text
files with nonstandard files extensions -- the only file extensions that can
be used for text files for ACCESS to import them are ".txt", ".csv", ".tab",
and ".asc". To handle this, see these Knowledge Base articles:

ACC2000: Importing or Linking a Text File Fails for a File That Does Not
Have a Valid File Name Extension
http://support.microsoft.com/default.aspx?id=304206

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb;[LN];245407

ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144

(The renaming of the file is the preferable method.)


(B) Be sure that the path string is properly constructed. A common error is
the omission of a backslash in the path.


(C) The length of the path and file name string cannot exceed 64 characters.
See this Knowledge Base article:

ACC2000: Error When You Export an Object to a Path and File Name Longer Than
64 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;250459
 
Ken, The first tip was the kicker. I remember (now) that I had to add the
dot fds file extension when we went to NT too. It worked great. Thanks a
bunch. You folks are awsome...I hope someday to be there too. ;-) Thanks
again, -Bill.

Ken Snell (MVP) said:
It's not completely clear to me what you mean by "build a table of file
names" and then you "click on 2 - 3 of them". Are you doing this on a form,
and the "IMPORT" button is on the form, and the button runs code that
includes the DoCmd.ImportText action?

Assuming that the answers are yes, the error message that you get can result
from different causes.

(A) For security reasons, newer versions of ACCESS will not import text
files with nonstandard files extensions -- the only file extensions that can
be used for text files for ACCESS to import them are ".txt", ".csv", ".tab",
and ".asc". To handle this, see these Knowledge Base articles:

ACC2000: Importing or Linking a Text File Fails for a File That Does Not
Have a Valid File Name Extension
http://support.microsoft.com/default.aspx?id=304206

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb;[LN];245407

ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144

(The renaming of the file is the preferable method.)


(B) Be sure that the path string is properly constructed. A common error is
the omission of a backslash in the path.


(C) The length of the path and file name string cannot exceed 64 characters.
See this Knowledge Base article:

ACC2000: Error When You Export an Object to a Path and File Name Longer Than
64 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;250459

--

Ken Snell
<MS ACCESS MVP>


Bill said:
My data base opens fine & I build a table of file names to be imported.
When
I click on 2-3 of them & then click the "IMPORT" button, the
DoCmd.ImportText
command gives me the 3027 message "Cannot Update. Database or object is
read
only." for EACH file name. At least one table (ImportNames) has already
been
updated, so I'm thinking it's an object, maybe the RawData table that I'm
importing INTO. This database worked fine a few weeks ago on my Win2K
box,
but now on my XP box it fails. Both boxes run Access2000.
Can someone tell me how to remedy this. I'm under some mild pressure to
turn in my old laptop. Thanks. -Bill.
Click to expand...
Click to expand...
 
You're welcome! :-)

--

Ken Snell
<MS ACCESS MVP>

Bill said:
Ken, The first tip was the kicker. I remember (now) that I had to add the
dot fds file extension when we went to NT too. It worked great. Thanks a
bunch. You folks are awsome...I hope someday to be there too. ;-)
Thanks
again, -Bill.

Ken Snell (MVP) said:
It's not completely clear to me what you mean by "build a table of file
names" and then you "click on 2 - 3 of them". Are you doing this on a
form,
and the "IMPORT" button is on the form, and the button runs code that
includes the DoCmd.ImportText action?

Assuming that the answers are yes, the error message that you get can
result
from different causes.

(A) For security reasons, newer versions of ACCESS will not import text
files with nonstandard files extensions -- the only file extensions that
can
be used for text files for ACCESS to import them are ".txt", ".csv",
".tab",
and ".asc". To handle this, see these Knowledge Base articles:

ACC2000: Importing or Linking a Text File Fails for a File That Does Not
Have a Valid File Name Extension
http://support.microsoft.com/default.aspx?id=304206

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message
When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb;[LN];245407

ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144

(The renaming of the file is the preferable method.)


(B) Be sure that the path string is properly constructed. A common error
is
the omission of a backslash in the path.


(C) The length of the path and file name string cannot exceed 64
characters.
See this Knowledge Base article:

ACC2000: Error When You Export an Object to a Path and File Name Longer
Than
64 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;250459

--

Ken Snell
<MS ACCESS MVP>


Bill said:
My data base opens fine & I build a table of file names to be imported.
When
I click on 2-3 of them & then click the "IMPORT" button, the
DoCmd.ImportText
command gives me the 3027 message "Cannot Update. Database or object is
read
only." for EACH file name. At least one table (ImportNames) has
already
been
updated, so I'm thinking it's an object, maybe the RawData table that
I'm
importing INTO. This database worked fine a few weeks ago on my Win2K
box,
but now on my XP box it fails. Both boxes run Access2000.
Can someone tell me how to remedy this. I'm under some mild pressure
to
turn in my old laptop. Thanks. -Bill.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top