Runtime is read only ????

[dhstein]

I have the runtime version of Access installed for the users. The database
says that it's read only. But if I provide the query output to the users
they can modify that. So two questions:

1) If the query gets modified, does the underlying table data get modified?

2) If I presented a form based on the query - instead of the query - would
that prevent the user from changing anything?

Thanks for any help on this.

 

[John W. Vinson]

I have the runtime version of Access installed for the users. The database
says that it's read only. But if I provide the query output to the users
they can modify that. So two questions:

Do you have a "split" database, with the users executing the runtime with a
frontend linked to a backend containing the tables?

1) If the query gets modified, does the underlying table data get modified?

Absolutely. A Query has no independent existance! It's just a tool to arrange
data from one or more tables, in whatever combinations you need. The data
exists in the table, and only in the table; if you modify a field in the query
that field is instantly changed in the underlying table.

2) If I presented a form based on the query - instead of the query - would
that prevent the user from changing anything?

You could choose to make the form (or the query) updateable or not, as
appropriate.

Thanks for any help on this.

It might help if you'ld explain the nature of the database and what you're
trying to accomplish!

 

[aaron.kempf]

splitting and linked tables are not the only way to do this.. and they
are not even the best way

SQL Server and Access Data Projects-- it never gives me any problems.

-Aaron