No access to upsized database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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???
 
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???
Click to expand...

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.
 
Back
Top