Viewing SQL Database

[aron.ridgway]

Hi There,

Im fairly new to access, so apologies if this has a very easy solution.

Basically i want to view an SQL Supplier Table, I have added this table but its allowing me to edit it which i do not want. I only want to use its information, I've created a query on the table which is my view?

I'm just wondering if there was an easier way of having the table as read only or maybe importing an SQL View?

thank you in advance!

Aron

 

[namliam]

You can make your own table in Access without problems, easiest way to ensure "read only" is to have the user you connect with to the database have only read only rights.

 

[aron.ridgway]

Thank you for the reply!

Umm how do i go about that? is it done within Access?

We use a generic login for SQL will that matter?

thanks

 

[namliam]

If a generic user logon for SQL has full read/write privileges, then you have a bigger problem!!!!

Generic users should NEVER have full privileges, only read ....
Personal accounts is another matter.

Solve the bigger problem first, then come back to this one.

 

[aron.ridgway]

I've looked into this and we do have other permissions, i am just use to using mine that enables me to do everything! So if i add the Table using an account without Write permissions will that resolve my issue?

thanks!

 

[namliam]

Yes if you use a read only account you will only be able to read, not write, thus not edit.

 

[aron.ridgway]

Is there a way of loading SQL-Views instead of Tables? will this enable them to only be read only?

If so how do you add a view into access?

thanks

 

[namliam]

You can access a view either as a normal table or use a pass through query...
I THINK you can make a pass through query to be read only, the absolute savest way and best way and really only way is to create a generic READ ONLY account