Using Access as a front-end to SQL

G

Guest

I upsized an Access database to SQL. Now I can modify the database from the Access I upsized from. What's wrong? I'm an administrator on everything.
 
N

Naresh Nichani MVP

Hi:

Do your tables have a primary key? If not the ADP projects will not allow
you to add/update records from tables.

Regards,

Naresh Nichani
Microsoft Access MVP
Jerry Nelson said:
I upsized an Access database to SQL. Now I can modify the database from
Click to expand...
the Access I upsized from. What's wrong? I'm an administrator on
everything.
 

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

Split Database vs. Access Project 3
SQL upsize 2 databases 2
Trouble upsizing Access to SQL 5
Access front-end and SQL Server back-end table lock 2
SQL Server 13
Upsizing ACC 97 to SQL 2000 1
Access Frontend to SQL database 2
Upsizing Access 2000-SQL Server2005 6

Top