I have an access db set up (ACCESS 97) to grade and score tests.  This db is used by several 

users in the office, each with their own copy on their machine.  It has worked fine until 

recently, but now I'm getting an error message.  It just happens ONLY on MY machine; i.e., the 

program runs fine on other machines.  I realize that this is a machine problem (since it only 

happens to me) and not an access problem per se. 



The error message I'm getting is:



Run-time error '3027':

Can't update.  Database or object is read only.



If I choose debug, it highlights the following line of code:



DoCmd.TransferText acImportFixed, "RawScores", "Raw Scores", vScanFile & ".dat"





I haven't made any changes to my machine nor have I downloaded anything from the web 

lately.  My last virus scan was clean.  I was running ACCESS 2000 on my machine for another 

application and I cannot honestly recall if I used your program after I loaded ACCESS 2000 on 

my machine.  When I encountered the above problem I removed ACCESS 2000 from my 

machine and removed and re-installed Office 97 but that didn't seem to help.  Let me know 

what you think;

Thanks for the help;

Your user is running the app from Access 2000, which has a very odd

requirement for imported text files.  See:



http://support.microsoft.com/support/kb/articles/Q245/4/07.ASP



for the ugly details.  I tore my hair out for hours before stumbling onto

this kb article...



HTH,



-Roy



-----Original Message-----

From: jviscomi@s... [mailto:jviscomi@s...]

Sent: Tuesday, August 14, 2001 12:24 PM

To: Access

Subject: [access] access program





I have an access db set up (ACCESS 97) to grade and score tests.  This db is

used by several 

users in the office, each with their own copy on their machine.  It has

worked fine until 

recently, but now I'm getting an error message.  It just happens ONLY on MY

machine; i.e., the 

program runs fine on other machines.  I realize that this is a machine

problem (since it only 

happens to me) and not an access problem per se. 



The error message I'm getting is:



Run-time error '3027':

Can't update.  Database or object is read only.



If I choose debug, it highlights the following line of code:



DoCmd.TransferText acImportFixed, "RawScores", "Raw Scores", vScanFile &

".dat"





I haven't made any changes to my machine nor have I downloaded anything from

the web 

lately.  My last virus scan was clean.  I was running ACCESS 2000 on my

machine for another 

application and I cannot honestly recall if I used your program after I

loaded ACCESS 2000 on 

my machine.  When I encountered the above problem I removed ACCESS 2000 from

my 

machine and removed and re-installed Office 97 but that didn't seem to help.

Let me know 

what you think;

Thanks for the help;