Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run time Error 3027

Status
Not open for further replies.
anon1971

anon1971

Programmer
Aug 9, 2008
88
US
the code below give a run time 3027 error that says the database is read only. That is not the case however I just upsized the access database to sql 2005 does anyone know what the problem is I have tried everything?

Set rst = CurrentDb.OpenRecordset("Processing", dbOpenDynaset)

rst.AddNew
 
Sort by date Sort by votes
I got it the reason for this is I didn't have a primary key on the sql server for that table.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Question
TransferSpreadsheet 3125 Error
Replies
5
Views
1K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Find error in currency feild 2
Replies
8
Views
919
Andrzejek
Andrzejek
Aurillius
  • Locked
  • Question
Convert Date/Time cell to a date and time in VBA
Replies
2
Views
743
Andrzejek
Andrzejek
Kim296
  • Locked
  • Question
Sending Gmail using vba Send error
Replies
6
Views
980
strongm
strongm
EM1107
  • Locked
  • Question
calculated time difference. 1
Replies
2
Views
701
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top