Read Only Problem?

[stazza18]

We have a system that runs a process our company does. During this process, an excel file is transferred to an flat file. We never had a problem until today. Now when the code runs and it gets to the Docmd. transferspreadsheet portion, it is giving me this error: 'Runtime error 3027: Can't Update: database or object is read-only'. Where we are lost is the fact that none of the objects or the database is read only. We also haven't changed a thing. This error came out of nowhere. Any ideas or suggestions would be greatly appreciated. Thanks.

 

[smedvid]

Just a suggestion or two... determine where the issue is coming from. Attempt to move the file to a local C:\ to see if it imports. Compact/Repair the MDB then attempt to import. Next, use a backup copy of the MDB to see if that can import the file... ??? htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[stazza18]

It is very odd, the database was on two different local machines with the same network user. He placed a copy of the database and the excel spreadsheet on our share drive and I put it on my local machine. I ran it fine. I had thought it was a problem with the database but it seems to be something else. Thanks for the info.

 

[pcstammis]

i was running into the same problem when i reprogrammed a small telecom call data reporting program from access 97 to acces2000. Before i could import a flat, comma seperated text file without the need of a file exentions name.
in access 2000 i discovered that the filename needed the extension .txt before i could import it. Same applied to other txt files that did not have the .txt extension.

This might give you an idea to solve your problem.

 

[Hap007]

Dear stazza18,

Sounds like somebody has the output file open. This would be excel or notepad or word. Just make sure that no one has the file open and I bet your problem will be solved.

Worst case, just re-boot the PC or Server wher the files are located.

Good Luck,
Hap


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers

 

[cobweb]

Hi there:
I have just come across a problem very similar to that mentioned above.
When I am trying to export a table to a text file I get error 3027 object or table is read only.
This is because I have just upgraded to Access XP from 97.
THe answer? In regedit change the HKEY_LOCAL_MAchine/SOFTWARE/MICROSOFT/JET/4.0/ENGINES/TEXT/DISABLED EXTENSIONS
setting to include the extension that you want - so if your file extension is xxx then add xxx to the list.
My problem is that I have 999 permutations!
Any ideas, anybody, please?!

Thanks

 

[smedvid]

Create an intermediate temp file then rename it? Use file scripting object.. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...