SQL Server Express Access 2003

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

Guest

I'm able to create the table etc via SQL Server Express tools. I create link
to the database and can see the data in the form, but I cannot add or change
any records, what must I do to allow RW access on the table?
 
basically add an uniuque index

pieter

tcmichals said:
I'm able to create the table etc via SQL Server Express tools. I create
link
to the database and can see the data in the form, but I cannot add or
change
any records, what must I do to allow RW access on the table?
Click to expand...
 
are you using the WIMPY mdb format?

you should just wait for Access 2007 and use SQL Express then.

MDB is LAME
 
You must log in or register to reply here.

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

What are the steps to fix damaged MDF files in SQL Server? 0
SQL Server Backend is Read Only 7
Access and SQL Server 7
Best way to deploy Access read-only database that is linked to SQL tables 6
Access and SQL Server Express 2
Data Access Pages Data Source 2
Write Conflict in Access with SQL server Tables 3
Similarities / differences b/w Access and SQL Server Express 7

Back
Top