i have a database that i am trying 2 convert from access to SQL Server...
but when i try to read the SQL Server tables through MSAccess i can't enter or edit data... the database properties, and the user permissions are NOT readonly in both access and SQL Server - so whycan't i write data?
Thanks KrisWhat was the error and ensure the login used to connect from MS Access to SQL server does have required privileges.|||no error i just can't add or edit data ...
special privalages?? - i dun no exactly what u mean but i dun think there should be|||ata bare minimum the user account that you are using should have read select update insert and delete permission on the tables.
are you using a sql login to connect to the sql server or are you using a trusted operating system account?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment