No access to upsized database

[Guest]

I'm a newby to using Access as a front-end to an SQL database

When I upsized a simple one table database to SQL 7.0, I could not update the data. I received an error stating the database was unmodifiable. I can update the data all day if I go directly to the server, but I can't update the database from my computer

I am the administrator on my computer, the SQL server, and the SQL SA.

How can I update my data???

 

[John Vinson]

I'm a newby to using Access as a front-end to an SQL database.

When I upsized a simple one table database to SQL 7.0, I could not update the data. I received an error stating the database was unmodifiable. I can update the data all day if I go directly to the server, but I can't update the database from my computer.

I am the administrator on my computer, the SQL server, and the SQL SA.

How can I update my data???

One common problem is that the SQL table must have a Primary Key, and
it must be defined in the link to the table that it is the Primary
Key.