Access to SQL

[deutschedb]

Hello Experts

I have created a database in Excel, and I have converted it into Access.

Then using Upsizing Wizard in Access, I have converted it into SQL. But now in SQL, though it looks everything correct, it seems I can not edit (add, delete, modify) into this converted database.

I am new to this forum and hopeful to get this Problem solved with your expertise.

Thanks a lot

[rmiao]

Do you have proper permission in the db?

[Island1]

Was it a permissions issue? Did you try going in an modifying same?

Let us know if we can help further ...

Bill

[skhanal]

Are you trying to modify it through Access using SQL Linked tables?

I have seen this happen if there are no primary keys on SQL tables.

[MAK]

Make sure you have created proper login, user and permission to the database and use that login for accessing the tables.