No access to upsized database


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???
 
Ad

Advertisements

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upsizing Access Database 5
Upsizing 100 Databases 2
Error upsizing a database 2
SQL upsize 2 databases 2
Upsize Access Tables ? 2
Access upsizing problem 2
Database Corruption and advice on upsizing 9
upsizing 1

Top