How to edit a SQL Server table from MS Access?

Hi guys,

I need provide some of my users an easy way of accessing a SQL Server table through MS Access so that

they can edit the table.

Please let me know which of the following is more appropriate to accomplish this task.

1. Creating a Data Access Page

2. Creating a Link Table

I thought I could it do it though a Data Access Page but I was only able to see the data but not edit it. But, I

know there is a way of doing this. Please throw some light on this topic.

Thanks a lot for your time.

Regards,

-RL.

Tables must have a key to be editable in access|||

Hi TiJaLeII,

Thanks a lot. Now I could be able to edit the data.