Read-Only problem

[Maquis]

Hi there, I hope someone can help me debug this issue.

I created a database with a command button that automates importing a text file. The command button code is fairly straightforward, just a TransferText statement and an append query.

When I run the code, it imports the file just fine, but when a user runs the code, she gets a "Can't update. Database or object is read-only." error message.

I've checked her network permissions and she has full Read/Write permissions to the database directory as well as the directory containing the text file. The database also is not read-only and she is the only person with the database open when she tries to import.

Any ideas? Maq
<insert witty signature here>

 

[mikevh]

I just upgraded from Access 97 to Access 2000 and was
having a similar problem. I got the same message you
mention whenever I tried to import or export a text
file and couldn't see any reason for it. I found the
article below at the Microsoft Knowledge Base. The
upshot is that you can't import or export text files
that don't have Microsoft's standard extensions, unless
you edit the registry. (For now I'm just working
around it by using approved extensions. Doing this is sufficiently annoying that I may just read up on it and edit the registry when I get the time, though.)

http://support.microsoft.com/default.aspx?scid=kb;en-us;245407

 

[Maquis]

Thanks for the reply Mike. I found the same article yesterday while doing some more research. That sounds like exactly the problem, since when we re-name the file to xxx.txt it works ok.

The odd thing is I checked my registry settings and I don't have the suggested mods on my PC, but my PC imports the file with no problem.

Oh well, I'm snowed in at home today. I'll work on it some more once my dog sled makes it back to the office. Maq
<insert witty signature here>