Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #13687 > unrolled thread

transfertext error "cannot update" database or object is read-only"

Back to article view | Back to comp.databases.ms-access

Contents

  transfertext error "cannot update" database or object is read-only" PW <PW@noemailaddress.com> - 2019-06-18 21:32 -0700
    Re: transfertext error "cannot update" database or object is read-only" Ron Paii <ron81pai@gmail.com> - 2019-06-19 05:02 -0700
      Re: transfertext error "cannot update" database or object is read-only" PW <PW@noemailaddress.com> - 2019-06-19 09:54 -0700
      Re: transfertext error "cannot update" database or object is read-only" PW <PW@noemailaddress.com> - 2019-06-19 09:58 -0700
      Re: transfertext error "cannot update" database or object is read-only" PW <PW@noemailaddress.com> - 2019-06-19 10:26 -0700
        Re: transfertext error "cannot update" database or object is read-only" PW <PW@noemailaddress.com> - 2019-06-19 11:41 -0700
          Re: transfertext error "cannot update" database or object is read-only" Ron Paii <ron81pai@gmail.com> - 2019-06-19 13:28 -0700
            Re: transfertext error "cannot update" database or object is read-only" PW <PW@noemailaddress.com> - 2019-06-19 21:54 -0700
              Re: transfertext error "cannot update" database or object is read-only" "Phil Hunt" <abc@nowhere.com> - 2019-06-20 07:34 -0400
                Re: transfertext error "cannot update" database or object is read-only" Ron Paii <ron81pai@gmail.com> - 2019-06-20 05:07 -0700
                  Re: transfertext error "cannot update" database or object is read-only" "Phil Hunt" <abc@nowhere.com> - 2019-06-20 08:14 -0400
                Re: transfertext error "cannot update" database or object is read-only" PW <PW@noemailaddress.com> - 2019-06-21 09:17 -0700

#13687 — transfertext error "cannot update" database or object is read-only"

Hi,

Any ideas why I am getting that error?  I have tried different drives
and folders.  And with the .csv extension (but won't the file get
created with it anyway?).

DoCmd.TransferText acExportDelim, ,"tblRoomsAvailable",
"c:\GCalRoomAvailability"

The from file is part of the Access code database (not linked)

Is there an alternative to create a .csv file?  I wonder why that
isn't working.

-paulw

[toc] | [next] | [standalone]

#13688

On Tuesday, June 18, 2019 at 10:31:17 PM UTC-5, PW wrote:
> Hi,
> 
> Any ideas why I am getting that error?  I have tried different drives
> and folders.  And with the .csv extension (but won't the file get
> created with it anyway?).
> 
> DoCmd.TransferText acExportDelim, ,"tblRoomsAvailable",
> "c:\GCalRoomAvailability"
> 
> The from file is part of the Access code database (not linked)
> 
> Is there an alternative to create a .csv file?  I wonder why that
> isn't working.
> 
> -paulw

Have you tried the exporting the table manually from the Access UI?

PS: what file is part of the access code database? Not the export file.

[toc] | [prev] | [next] | [standalone]

#13689

On Wed, 19 Jun 2019 05:02:32 -0700 (PDT), Ron Paii
<ron81pai@gmail.com> wrote:

>On Tuesday, June 18, 2019 at 10:31:17 PM UTC-5, PW wrote:
>> Hi,
>> 
>> Any ideas why I am getting that error?  I have tried different drives
>> and folders.  And with the .csv extension (but won't the file get
>> created with it anyway?).
>> 
>> DoCmd.TransferText acExportDelim, ,"tblRoomsAvailable",
>> "c:\GCalRoomAvailability"
>> 
>> The from file is part of the Access code database (not linked)
>> 
>> Is there an alternative to create a .csv file?  I wonder why that
>> isn't working.
>> 
>> -paulw
>

*---


>Have you tried the exporting the table manually from the Access UI?
>


Yes Ron.  Same error.  This (DoCmd.TransferText acExportDelim, ,
"tblRoomsAvailable", "C:\GCalRoomAvailability.CSV") gives me" runtime
error 3011:  The Microsoft Access database engine could not find the
object "GCALRoomAvailability#csv...".

Without the extension I get the read-only error.

>PS: what file is part of the access code database? Not the export file.


Not sure what you mean.  The file to export from  is in the split code
part not the data.accdb and has data in it.

Another form that uses the same command and syntax but with an .ics
extension (    DoCmd.TransferText acExportDelim, , "tblqbftemp",
"c:\Lodge-ical\names.ics", -1) generates the same error now but has
worked for many years.

-paulw

[toc] | [prev] | [next] | [standalone]

#13690

On Wed, 19 Jun 2019 05:02:32 -0700 (PDT), Ron Paii
<ron81pai@gmail.com> wrote:

>On Tuesday, June 18, 2019 at 10:31:17 PM UTC-5, PW wrote:
>> Hi,
>> 
>> Any ideas why I am getting that error?  I have tried different drives
>> and folders.  And with the .csv extension (but won't the file get
>> created with it anyway?).
>> 
>> DoCmd.TransferText acExportDelim, ,"tblRoomsAvailable",
>> "c:\GCalRoomAvailability"
>> 
>> The from file is part of the Access code database (not linked)
>> 
>> Is there an alternative to create a .csv file?  I wonder why that
>> isn't working.
>> 
>> -paulw
>
>Have you tried the exporting the table manually from the Access UI?
>
>PS: what file is part of the access code database? Not the export file.


*--

Sorry - the read-only error

[toc] | [prev] | [next] | [standalone]

#13691

On Wed, 19 Jun 2019 05:02:32 -0700 (PDT), Ron Paii
<ron81pai@gmail.com> wrote:

>On Tuesday, June 18, 2019 at 10:31:17 PM UTC-5, PW wrote:
>> Hi,
>> 
>> Any ideas why I am getting that error?  I have tried different drives
>> and folders.  And with the .csv extension (but won't the file get
>> created with it anyway?).
>> 
>> DoCmd.TransferText acExportDelim, ,"tblRoomsAvailable",
>> "c:\GCalRoomAvailability"
>> 
>> The from file is part of the Access code database (not linked)
>> 
>> Is there an alternative to create a .csv file?  I wonder why that
>> isn't working.
>> 
>> -paulw
>
>Have you tried the exporting the table manually from the Access UI?
>
>PS: what file is part of the access code database? Not the export file.


*--

It was a combination of things Ron!!

Something was wrong with the database(s).  Even though I did a compact
and repair on both the code and data, and also recompiled the code, it
did not help.

So, I copied everything I need into another Access database and
changed the transferdatabase file export path to a subfolder of the
c:\ drive (same errors if I just went to c:\) I now no longer receive
any errors and I have a valid .csv file!!

So this works!

DoCmd.TransferText acExportDelim, , "tblRoomsAvailable",
"C:\lodge-ical\GCalRoomAvailability.csv"

Now I need to see if Google Calendar will accept it.  I am planning on
having to make some changes to the file and do some troubleshooting.

Thanks again!

One more for the memory bank.

-paulw

[toc] | [prev] | [next] | [standalone]

#13692

On Wed, 19 Jun 2019 10:26:25 -0700, PW <PW@noemailaddress.com> wrote:

>On Wed, 19 Jun 2019 05:02:32 -0700 (PDT), Ron Paii
><ron81pai@gmail.com> wrote:
>
>>On Tuesday, June 18, 2019 at 10:31:17 PM UTC-5, PW wrote:
>>> Hi,
>>> 
>>> Any ideas why I am getting that error?  I have tried different drives
>>> and folders.  And with the .csv extension (but won't the file get
>>> created with it anyway?).
>>> 
>>> DoCmd.TransferText acExportDelim, ,"tblRoomsAvailable",
>>> "c:\GCalRoomAvailability"
>>> 
>>> The from file is part of the Access code database (not linked)
>>> 
>>> Is there an alternative to create a .csv file?  I wonder why that
>>> isn't working.
>>> 
>>> -paulw
>>
>>Have you tried the exporting the table manually from the Access UI?
>>
>>PS: what file is part of the access code database? Not the export file.
>
>
>*--
>
>It was a combination of things Ron!!
>
>Something was wrong with the database(s).  Even though I did a compact
>and repair on both the code and data, and also recompiled the code, it
>did not help.
>
>So, I copied everything I need into another Access database and
>changed the transferdatabase file export path to a subfolder of the
>c:\ drive (same errors if I just went to c:\) I now no longer receive
>any errors and I have a valid .csv file!!
>
>So this works!
>
>DoCmd.TransferText acExportDelim, , "tblRoomsAvailable",
>"C:\lodge-ical\GCalRoomAvailability.csv"
>
>Now I need to see if Google Calendar will accept it.  I am planning on
>having to make some changes to the file and do some troubleshooting.
>
>Thanks again!
>
>One more for the memory bank.
>
>-paulw


*---

I successfully imported it into a Google Calendar!  YeeHaw!

Now what's next? :-)

-paulw

[toc] | [prev] | [next] | [standalone]

#13693

On Wednesday, June 19, 2019 at 12:40:22 PM UTC-5, PW wrote:
> On Wed, 19 Jun 2019 10:26:25 -0700, PW <PW@noemailaddress.com> wrote:
> 
> >On Wed, 19 Jun 2019 05:02:32 -0700 (PDT), Ron Paii
> ><ron81pai@gmail.com> wrote:
> >
> >>On Tuesday, June 18, 2019 at 10:31:17 PM UTC-5, PW wrote:
> >>> Hi,
> >>> 
> >>> Any ideas why I am getting that error?  I have tried different drives
> >>> and folders.  And with the .csv extension (but won't the file get
> >>> created with it anyway?).
> >>> 
> >>> DoCmd.TransferText acExportDelim, ,"tblRoomsAvailable",
> >>> "c:\GCalRoomAvailability"
> >>> 
> >>> The from file is part of the Access code database (not linked)
> >>> 
> >>> Is there an alternative to create a .csv file?  I wonder why that
> >>> isn't working.
> >>> 
> >>> -paulw
> >>
> >>Have you tried the exporting the table manually from the Access UI?
> >>
> >>PS: what file is part of the access code database? Not the export file.
> >
> >
> >*--
> >
> >It was a combination of things Ron!!
> >
> >Something was wrong with the database(s).  Even though I did a compact
> >and repair on both the code and data, and also recompiled the code, it
> >did not help.
> >
> >So, I copied everything I need into another Access database and
> >changed the transferdatabase file export path to a subfolder of the
> >c:\ drive (same errors if I just went to c:\) I now no longer receive
> >any errors and I have a valid .csv file!!
> >
> >So this works!
> >
> >DoCmd.TransferText acExportDelim, , "tblRoomsAvailable",
> >"C:\lodge-ical\GCalRoomAvailability.csv"
> >
> >Now I need to see if Google Calendar will accept it.  I am planning on
> >having to make some changes to the file and do some troubleshooting.
> >
> >Thanks again!
> >
> >One more for the memory bank.
> >
> >-paulw
> 
> 
> *---
> 
> I successfully imported it into a Google Calendar!  YeeHaw!
> 
> Now what's next? :-)
> 
> -paulw

Glad you got it working.

Was this a Windows 10 box?
I have see issues with security setting on folders causing simple file commands to fail. I can see the base of a drive being locked down by windows. 

[toc] | [prev] | [next] | [standalone]

#13694

>> >
>> >It was a combination of things Ron!!
>> >
>> >Something was wrong with the database(s).  Even though I did a compact
>> >and repair on both the code and data, and also recompiled the code, it
>> >did not help.
>> >
>> >So, I copied everything I need into another Access database and
>> >changed the transferdatabase file export path to a subfolder of the
>> >c:\ drive (same errors if I just went to c:\) I now no longer receive
>> >any errors and I have a valid .csv file!!
>> >
>> >So this works!
>> >
>> >DoCmd.TransferText acExportDelim, , "tblRoomsAvailable",
>> >"C:\lodge-ical\GCalRoomAvailability.csv"
>> >
>> >Now I need to see if Google Calendar will accept it.  I am planning on
>> >having to make some changes to the file and do some troubleshooting.
>> >
>> >Thanks again!
>> >
>> >One more for the memory bank.
>> >
>> >-paulw
>> 
>> 
>> *---
>> 
>> I successfully imported it into a Google Calendar!  YeeHaw!
>> 
>> Now what's next? :-)
>> 
>> -paulw
>
>Glad you got it working.
>
>Was this a Windows 10 box?
>I have see issues with security setting on folders causing simple file commands to fail. I can see the base of a drive being locked down by windows. 

Yes. Windows 10.  I checked if both the code and data accdb was set to
read-only but they were not. 

But writing to drive C itself and not the folder still generates the
other error "cannot find #GCalRoomAvailability.csv"  but works in the
subfolder.  That generated the read-only error before moving
everything I needed to another accdb.

I now have a Google Calendar on a webpage that is automatically
updated when the calendar is updated (refreshing the browser when
needed). And with data from my application creating the .csv file.

 Pretty cool!

-paulw

[toc] | [prev] | [next] | [standalone]

#13696

Some windows 7 machine also locks down C: drive, forcing you to write to a 
folder under C instead. I cannot find where the setting is. Anyone  ? 

[toc] | [prev] | [next] | [standalone]

#13697

On Thursday, June 20, 2019 at 6:34:21 AM UTC-5, Phil Hunt wrote:
> Some windows 7 machine also locks down C: drive, forcing you to write to a 
> folder under C instead. I cannot find where the setting is. Anyone  ?

Right click on the drive or folder
Select Properties
Select Security
Select Advanced
Select Effective Access
Use Select a user to enter the current login
Select effective access

You can change the access levels or take ownership of the folder.

IMO I would not store files in the base folder, or change permissions on a base folder; you will be opening security holes on the system.

[toc] | [prev] | [next] | [standalone]

#13698

I will try it when I get home to the machine.
The strange thing is I can open Notepad and save the file under C drive. I 
just cannot use Explorer left click to new a text doc.

"Ron Paii" <ron81pai@gmail.com> wrote in message 
news:11b85cd9-7bf3-48e3-ac94-ed64dcbc326e@googlegroups.com...
> On Thursday, June 20, 2019 at 6:34:21 AM UTC-5, Phil Hunt wrote:
>> Some windows 7 machine also locks down C: drive, forcing you to write to 
>> a
>> folder under C instead. I cannot find where the setting is. Anyone  ?
>
> Right click on the drive or folder
> Select Properties
> Select Security
> Select Advanced
> Select Effective Access
> Use Select a user to enter the current login
> Select effective access
>
> You can change the access levels or take ownership of the folder.
>
> IMO I would not store files in the base folder, or change permissions on a 
> base folder; you will be opening security holes on the system. 

[toc] | [prev] | [next] | [standalone]

#13700

On Thu, 20 Jun 2019 07:34:18 -0400, "Phil Hunt" <abc@nowhere.com>
wrote:

>Some windows 7 machine also locks down C: drive, forcing you to write to a 
>folder under C instead. I cannot find where the setting is. Anyone  ? 
>


*---

I remember that too.  Probably why I changed the extract to a folder
on the C drive way back when.

-paulw

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web