Search results for query: *

I have try all possible connection but nothing. if any of the connection were read only then I would not been able to edit the data in the "dbo_Item" but I can. The tables the the SQL creates are in VIEWS table that is the ones that I can update, so the SQL database must have some dependencies...

No I have been login is as "sa" and the same password I can't figure out the cause for this. Thank you

I Just wish to understand why several app can open "dbo_item" and upadate the contents but Access uses the public type of file any reason why. thank you all for trying to help

Hello to all Here is what I have come up with When I select to link the tables from Access I have some tables that they are named public "dbo_Public_Item" I choose that one I can insert a record not a problem, but if I choose the one that is "dbo_item" I can't, those two files are the same...

Hello to all 1 I can insert a new record from other ODBC applications into the SQL database with no problem the issue that I have is with Access I can't insert a new record from Access link 2 I Also I can insert a new record from the SQL Ent Manager 3 so I assume I have the proper permission...

Hello to all I have link a table from an Mssql to Access 2000 I can see the data in the Access end but I can add a record to it can some one tell me why or how I can change this event, I would like to add a record in Access into the SQL database. Thank you all