Copied database turns "read only".

[gusbrunston]

[tt]
Hello:

(I'm repeating this thread from another forum after several days with no reply.)

Whenever I copy a backend .mdb (the one with all the tables), I cannot use the front end to modify any data. I can go directly to the copied tables, open and modify the data. But when I try to use the front end forms, I get the "this database is not updatable" error.

I've tried this with db's copied from cd's, zip drives, FTP from the web, and have the same result.

Would really appreciate your feedback. Thanks in advance,

Gus[/tt]

[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]

 

[lupins46]

Well I can't see any reason for the problem coming from zip drives or FTP but any database copied from a CD becomes read-only and has to have its properties changed.

 

[gusbrunston]

[tt]
Hi:

Got it! %-) (This usually happens in the shower.)

I used the linked table manager, refreshed the links to the back end, and cured the problem.

Hope this will help someone else.

Cheers.[/tt]

[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]

 

[TheAceMan1]

How are ya gusbrunston . . . . .

Copy the DB to the hard drive first, then [blue]check the file properties in windows explorer[/blue]. I suspect the [blue]Read Only[/blue] attribute is enabled!

See Ya! . . . . . .

 

[gusbrunston]

[tt]
Thanks to both for your attention to my post and taking the time to reply.
Sinceeerly,[/tt]

[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]

 

[TheAceMan1]

gusbrunston . . . . .

Any [blue]resolution achieved[/blue] for your problem?

[purple]It would help others who come to Tek-Tips if the above is true![/purple]

See Ya! . . . . . .

 

[gusbrunston]

Yep. I posted above your reply...it must have crossed in the tunnel. Here it is again:

Hi:

Got it! (This usually happens in the shower.)

I used the linked table manager, refreshed the links to the back end, and cured the problem.

Hope this will help someone else.

Cheers.

[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]