Access on SQL server

[Jay Velarde]

Hi,

I need help on configuring Access. I have a running Access application, when
I decided to convert to SQL server as the database. Every table is converted
fine. Now I am having a read-only access even if I am a dbo. Any help is
very much appreciated.

Thanks in advance,
Jay

 

[Jeff Boyce]

Jay

First place to check is in SQL Server, to see what permissions are set on
those tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bob Larson]

Also, as an additional thing to check -

Your tables in SQL Server should have a primary key for each table. And
second, you need to make sure to use the correct ODBC driver based on your
Operating System and Version of SQL Server.

If using SQL Server 2000
On all versions of Windows (XP and above) you would use SQL Server driver.

If using SQL Server 2005
On XP you would use the SQL Native Client driver
On Vista or Win7, you would use the SQL Server driver

If using SQL Server 2008
On XP and Vista you would use the SQL Native Client (10) driver
On Win7 you would use the SQL Server driver.

Hope that helps as well.