Julie:

Need more info.

-You using a bound control?
-PLease show the code that opens the connection and recordset.
-What version of ADO?



julie_tennyson@averydennison.com (Julie) wrote in message news:<a9998980.0307231235.47e8096e@posting.google. com>...
> We have forms written in Visual Basic 6.0. They were previously
> written for an Access database which was moved to SQL Server 2000.
>
> Here's the connect string I used:
> ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRI VER={SQL
> SERVER};DATABASE=MPPhoto
>
> The user visualbasic and the user logged in to the computer have full
> rights to the database.
>
> When they open the form which is based on a view it is opened as read
> only with an error 3027. The data control is not set to read only.
> The database file is not read only. All of the permissions are set to
> allow this user read, write and modify.
>
> Can anyone hep me?