How to edit a SQL Server table from Microsoft ACCESS?

Hi guys,

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

that they can edit the data in the table.

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

1. Creating a Data Access Page (OR)

2. Creating a Link Table

I tried to create a Data Access Page but I could only be able to see but not edit the data in the table. But, I

guess there is a way to do that.

Please throw some light on this topic.

Thanks a lot for your time.

-RL

Hi RL,

If I understood you correctly, you have 2 questions:

(1) Use Data Access Page or a Linked Table? Well, these are 2 separate technologies - one is a web form, the other requires opening a mdb database in Access and accessing data through a normal Access form. It's up to you and your users to select what's easier - having a centralized web page seems simpler, but requires IIS.

(2) Your data is read-only in the Data Access Page? Have you changed the DataEntry property to True? Check all the properties to make sure everything is setup correctly.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.