Linked tables from sql

[Artemis]

I have made an ODBC link to a SQL database on our companies server so that I can interrorgate the table for information. This is working well and I can produce a form showing the data I want.

My question is if I delete any text from a field on the form it deletes the information on the server. Is there anyway of telling Access to read only and not write. Should I have imported the information rather than link it?

I'm nearly there just this final hurdle to overcome.

Graeteful for any help the experts can offer.

 

[speakers_86]

If you import the information, you will still be able to manipulate the data, but the changes will not be reflected on the server.

If want to maintain the data link and not allow changes to the data, in the form you could change the control's enabled value to no (there is another similar control value you could use as well, but the name escapes me). When the form opens, you could set the allow edits value to false. Or when the form closes you can choose not to save changes. Just google to find that out if interested.

The benefit of maintaining the link is that the data in Access will be updated every time the form is opened. If you import the data, the data is as old as the import is.

 

[Artemis]

Speakers86

Many thanks for the information however, when I change the fields property from Embedded Yes to No this grays the data out and therefore I can no longer edit it.

If I was to delete the data and just close the form with out saving would this not delete anything from the SQL database?

Thanks in advance for the help.... By I need it!

 

[HiTechCoach]

I have made an ODBC link to a SQL database on our companies server so that I can interrorgate the table for information. This is working well and I can produce a form showing the data I want.

My question is if I delete any text from a field on the form it deletes the information on the server. Is there anyway of telling Access to read only and not write. Should I have imported the information rather than link it?

I'm nearly there just this final hurdle to overcome.

Graeteful for any help the experts can offer.

It really is easy to make it read only. Just change the form's recordset type to snapshot.

 

[Artemis]

RESOLVED THANK YOU TO - Speaker86 & HiTechCoach

 

[HiTechCoach]

You're welcome!

Glad we could assist.

 

[HiTechCoach]

From Artemis's PM so that ev eryone may benefit:

Hi,

Thanks for your help so far. I put that the issue was resolved however, How can I change the recordset type on my form if I don't have access to the SQL code. I have googled this and it would appear that the SQL code needs changing. Is this correct? or can it be changed within my form?

Grateful for your help

What I was referring to is a property for the Form. On the data tab: Recordset Type set to Snapshot

I use this a lot make form's read-only.

 

[Sess]

Sorry to cut into a thread. This is great I learned from this for 'read only forms' but I am wondering, on the Record Type there is a choice of Dynaset, Snapshot and Dynaset (Inconsistent Updates). I understand the Dynaset you can update, Snapshot you can not, but what is with the "Inconsistent Updates"?
Thank you.