Linked table makes source DB read-only ?

[groleau]

We had been using two copies of an Access database--one to add new data and the other for the users to read from.

We got tired of Windows telling us we can't push out the updated DB because the user copy was in use, so I made the user copy just have the parent table linked.

Now Access says the parent DB is read-only!

What's the best way to make a database read-only for most users AND still be able to update it while they are looking at it?

--
Wes Groleau

http://www.Parkview.com/

 

[lespaul]

split FE/BE?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[groleau]

> split FE/BE?

Is that a question or an answer?

That's what we've got. One DB does all the work, the other
contains only a linked view of the table.

But somehow, having them linked like that makes BOTH of them read-only.

--
Wes Groleau

http://www.Parkview.com/

 

[groleau]

SOLVED - well, kind of

The user database had the read-only attribute set.

I did not even have to unset it. I renamed the DIRECTORY containing the user database. That was enough for the master to not know it was serving a read-only database and so it stopped claiming that it (the master) was read-only.

Weird.

--
Wes Groleau

http://www.Parkview.com/