Unable to insert record

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

Guest

I copied my sql server database onto another server to use with
Access Forms.

I changed the link to point to the new server, I am able to read the data
but I am unable to insert or modify records.

Any ideas what I may be doing wrong?

I am able to insert/modify the data using same user using Query Analyzer.

Therefore, there seems to be something to do with Access database.

Thank you,
-Me
 
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

Record-Locking remains open after closing 0
VBA - retrieve data on last create named range from previous inserted named range 0
Insert Into from Form fields? 2
INSERT to excel file 4
SQL Server Question 2
can't insert new records 8
Access 2007 Split Assets db, issue moving to new directory 0
Cannot insert new record into sql 2005 View from Access form 1

Back
Top