Julie (ju************@averydennison.com) writes:
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.
Error message 3027 in SQL Server is
Could not find filegroup '%.*ls' in sysfilegroups for database '%.*ls'.
Somehow I suspect that your error 3027 comes from another source, as
the SQL message does not really fit in your brief description.
You probably need to track down which component is producing the error.
Even better is of course if you can find a text to that message.
I'm sorry for not being more helpful, but without any knowledge about
your application it is difficult to say anything useful.
--
Erland Sommarskog, SQL Server MVP,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp