p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Can't update. Database or object is read-only (Error 3027)


Message #1 by "Stefan ROBERT" <Stefan.Robert@a...> on Tue, 19 Jun 2001 00:44:14

I encounter the following problem with an Access Application :



1. An Access program run normally on Compaq Desktpro Pentium Pro

   workstations under WindowsNT SR-3 and Access97 SR-2

   Not secured, the programs and the data are not read-only.



2. Now that we replace the Compaq Pc with IBM PL300 Pentium III 700 MHz

   under WinNT SR-5 and still Access97 SR-2 we receive everytime the 

   following error message (Can't update. Database or object is

   read-only (Error 3027) on the Access statement :

   DoCmd.TransferText acExport, SpecName, Tablename, Filename

   and the resulting output sequential file is not created.



   We do not change anything to the Access97 coding. It is the same pgm.

   The Access database with the programs and data is the same.

   The Access97 program is located on the C: drive.

   The Access97 database with data is located on the Server.

   We made the test with the same user (same WinNT profile).

   The Access programs and data are not secured (not read-only).



Question : what's read-only ?

- the database were we do de extract from ?

- the database were we put the result of the extract (query)

- the file were we want to store the result of the TransferText

  (we check the WinNT permissions - there is no problem).

For wich object is the error code 3027 in this statement ?



How can I've more information about this error code ?

For example, the name of the object that is read-only ?



Can you suggest a track were we can look ahead and make tests ?

We are testing for more than 2 weeks on this problem.



Stefan from Belgium



E-mail : Stefan.Robert@a...

Message #2 by "Karl Kuellmer" <kuellmer@s...> on Thu, 21 Jun 2001 00:53:31
Ok, I experienced a very similar situation,  but in Access 2000.  After 

applying Service pack to NT, TransferText started behaving differently.  

Under the earlier service pack, having a file extension was optional.  

Under the new service pack, the spurious error message about read-only was 

produced by any attempt to do a tranfer text without a file extention.  

Check the file name that you are exporting to.  The anwer is:  nothing is 

read only.  Fake error message.



This one stumped me for three days.  I had to reprogram a number of 

applications because of it.  One of the mainframes can't use file 

extensions, other ones require it...



> 

> I encounter the following problem with an Access Application :

> 

> 1. An Access program run normally on Compaq Desktpro Pentium Pro

>    workstations under WindowsNT SR-3 and Access97 SR-2

>    Not secured, the programs and the data are not read-only.

> 

> 2. Now that we replace the Compaq Pc with IBM PL300 Pentium III 700 MHz

>    under WinNT SR-5 and still Access97 SR-2 we receive everytime the 

>    following error message (Can't update. Database or object is

>    read-only (Error 3027) on the Access statement :

>    DoCmd.TransferText acExport, SpecName, Tablename, Filename

>    and the resulting output sequential file is not created.

> 

>    We do not change anything to the Access97 coding. It is the same pgm.

>    The Access database with the programs and data is the same.

>    The Access97 program is located on the C: drive.

>    The Access97 database with data is located on the Server.

>    We made the test with the same user (same WinNT profile).

>    The Access programs and data are not secured (not read-only).

> 

> Question : what's read-only ?

> - the database were we do de extract from ?

> - the database were we put the result of the extract (query)

> - the file were we want to store the result of the TransferText

>   (we check the WinNT permissions - there is no problem).

> For wich object is the error code 3027 in this statement ?

> 

> How can I've more information about this error code ?

> For example, the name of the object that is read-only ?

> 

> Can you suggest a track were we can look ahead and make tests ?

> We are testing for more than 2 weeks on this problem.

> 

> Stefan from Belgium

> 

> E-mail : Stefan.Robert@a...

Message #3 by Brian Skelton <brian.skelton@b...> on Thu, 21 Jun 2001 01:50:45 +0100
Here's the number of the Microsoft Knowledge Base article dealing with 

this problem - q245407

It suggests two possible solutions. Either change the file extionsion on 

the file you're trying to write to match that of the file type, or 

change a registry setting to allow additional file extensions.

-BDS


  Return to Index