Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Washington (not DC)
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unable to Import

    I am using Access 2000 -- the DB is on a shared drive. This DB is shared by myself and only one other person. The permissions/security etc are whatever is standard out-of-the-box for A2K. We perform a daily import of a text file. Yesterday, I attempted this and got the following message -- "Cannot Updateatabase or Object is Read-Only!". There have been NO permission changes etc. I had the other person attempt the import and all worked fine from her PC. After checking all that I can think of -- found nothing to indicate DB or any tables, queries, etc in a READ-ONLY state. This morning I had the file restored from a backup of about 2 weeks ago...thinking this may solve the problem. Not so, still I cannot import (same message) and other person can import. Can anyone give a clue as to where else to look at why this is happening.

    TIA
    <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  2. #2
    New Lounger
    Join Date
    Jan 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Import

    Have you checked if the other user is opening the database in exclusive mode?

  3. #3
    justme417
    Guest

    Re: Unable to Import

    Thanks for the thought, but the other person would not know how to open Exclusive...and I did check that, watching her open the DB.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unable to Import

    It sounds like you might have an orphan ldb file that needs to be deleted.
    Charlotte

  5. #5
    justme417
    Guest

    Re: Unable to Import

    Charlotte: Thanks for the suggestions....but no luck there either. I have replaced the system.mdw file, thinking that might have some effect, but nada, no-way, nothing. At this point I am thinking that the only relief will be to rebuild the DB from scratch...I sure hope there is a different solution as there are about 50 forms, queries and reports to redo.

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Import

    I had a problem like this before and I was able to solve it by creating a new blank database and importing all the forms, queries, tables, etc. from the old db and it worked. You might give it a shot.

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Import

    Have you tried the sr1 patch for access 2000
    it cured the same problem for me
    HTH
    JerryC

  8. #8
    New Lounger
    Join Date
    Jan 2001
    Location
    Washington (not DC)
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unable to Import

    An Update to my problem:
    A co-worker of mine put this problem on a News Group and someone came up with a similar problem, where they changed the filename extension and all worked fine.

    The file extension which we use is .STS -- has worked for years on two different PC's running the same database. I changed the .STS to .TXT and all is now ok on my pc...but the other pc works just fine using .STS.

    All I can say is thank you all for your suggestions, they were all very logical.

    Final thought.....go figure.
    Thanks
    <font face="EraserDust">JustMe</font face=dust>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •