Can it be read only ?

J

Jason

I am using Access 97 to connect a data source (MySQL) via ODBC.

I have linked the tables in MySQL to the Access database and developed a
Select Query to retrieve information from the MySQL database.

I would like to know does the result of the SELECT query read-only ? If
not, what attribute of the SELECT query should I change so that it is
read-only ? This is because I don't want to change the content of the
database in MySQL accidentally.

Thanks
 
R

Rick Brandt

Jason said:
I am using Access 97 to connect a data source (MySQL) via ODBC.

I have linked the tables in MySQL to the Access database and
developed a Select Query to retrieve information from the MySQL
database.
I would like to know does the result of the SELECT query read-only ? If not,
what attribute of the SELECT query should I change so that it
is read-only ? This is because I don't want to change the content
of the database in MySQL accidentally.

Thanks
Click to expand...

Set the RecordSetType to Snapshot.

Or you could use passthrough queries instead of linked tables. They are
automatically read only.
 
M

MacDermott

I've never worked with MySQL, but in SQL Server I would create a View, and
give the user read-only permissions on it, instead of linking directly to
the table.
That way your data is protected, not just from this application, but from
anybody else who might be linking to it...
 
Top