I need to update some tables in SQL Server from a VB application.
During the run time, these tables were not updatable for some reason.
I do not understand why they are not updatable.
This is the way I connect to SQL Server from a VB application as
sConnect = "ODBC;DSN=ODBC_SQLServer;"
sConnect = sConnect & "DATABASE=DatabaseName;"
sConnect = sConnect & "UID=LoginID;" & "PWD="
sConnect = sConnect & "Password;"
Set WK = DBEngine.Workspaces(0)
Set DB = WK.OpenDatabase("", False, False, sConnect)
Set rs = DB.OpenRecordset("ChapterMemberRef", dbOpenDynaset, dbSeeChanges)
All tables in the SQL Server have permission to be updatable by
the login ID 'LoginID' and Password 'Password'.
The structure of 'ChapterMemberRef' has the following
This table must allow to have duplicate MemberIDs and ChapterCodes.
There is no primary key in this table.
This table is a bridge table between a table named, Members which
has a primary key MemberID and another table named, Chapters which
has a primary key ChapterCode.
Does anybody have any suggestion?
Hope to hear your experienced answers from you soon. Thanks.