Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #13691
| From | PW <PW@noemailaddress.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: transfertext error "cannot update" database or object is read-only" |
| Message-ID | <3prkgelflap6kpctffag97faercj3evmdc@4ax.com> (permalink) |
| References | <ngejge9n4ul0oh8rd3vlab21m6a907dk2h@4ax.com> <f2669c99-ed71-4f63-a7a6-53e4468ed1dc@googlegroups.com> |
| Organization | Forte - www.forteinc.com |
| Date | 2019-06-19 10:26 -0700 |
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
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
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
csiph-web