SQL-View in access not editable (migration problem from SQL2000 to SQL2012)

[herbert]

Hello



I'm new, so maybe the question isn't right here.

I use Access2003/2010 as frontend and SQL2000 as backend
There I've tables like '_Table1' and a the view like 'T_Table1'
The view is: Selcect * FROM _Table1 with (NOLOCK)

In Access is the view 'T_Table1' linked. This works fine at SQL2000

Now I'll do the same at SQL2012, but the linked view 'Table_1' is not editable in Access

Anyone an idea for me? (It seems not to be a problem of permissions, my user is in dbo group and that happens with other users too)

Thank you for your help
Herbert

[ranman256]

NORMALLY, 'views' are NOT editable (hence view)
I always edit the table version. Is this possible?

[herbert]

Hi,
that was an Access frontend/backend solution (starting with access95 ) then backend was moved to sql2000.
Afterwards there were some problems with locked entries, and so on. The solution was working with views and with nolock (changing the tablenames from t_xy to _xy and creating views with the tablename t_xy ). That is working on SQL2000, there were no blocking problems and no changes in many queries and codes at frontend Access necessary

Is it not possible to have editable views ??

[herbert]

Hi
I've solved the problem

to get editable views is an unique index necessary. My vb-codefor database-linikng did it only with linked tables to sql2000 server, I've corrected for the SQL2012 and it works now.

@ all (I don't know it's correct, but it works), after linking a table I create the index for the primary key field like this:
CurrentDB.Execute "CREATE UNIQUE INDEX __uniqueindex ON [T_Table1] ([ID]) WITH PRIMARY"