SQL server tables read-only to ADP

I have successfully migrated an Access 2003 database to SQL server - at least
all the tables and queries that resolve into views migrated successfully. I
also sucessfully migrated all my forms and code into an ADP project.
Everything works with one HUGE exception. All my tables on the SQL server are
read-only to ADP.

Why is this? Is it security?

Permissions allow users the ability to create, read, update, and delete
data. Perhaps you don't have the appropriate permissions assigned to the
login that you are using to connect to the database server.

If you want to allow select across the board simply add the db_datareader
fixed role to the login. That will allow the login to select data. If you
want to login to have update rights as well give them the db_datarwriter
role. That will allow them to write to all tables within that database. If
you only want to give them rights to a few tables use the GRANT statement
(GRANT UPDATE ON <tablename> TO <user>).

--
Keith


"Tony Z" <TonyZ DeleteThis @discussions.microsoft.com> wrote in message
news:76F1AE71-B34F-4945-A9CE-8BA796D8606A@microsoft.com...
 > I have successfully migrated an Access 2003 database to SQL server - at
least
 > all the tables and queries that resolve into views migrated successfully.
I
 > also sucessfully migrated all my forms and code into an ADP project.
 > Everything works with one HUGE exception. All my tables on the SQL server
are
 > read-only to ADP.
 >
 > Why is this? Is it security?<!-- ~MESSAGE_AFTER~ -->