Recordsets different with Windows Vista?

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a new computer running Vista. I tried to use my database with it and
have come across several problems. The one I'm working on now is a
recordset. The following code creates links to documents related to my
contacts.

Public Sub Make_Link(docname As String, strComment As String, strDocType As
String)
'Put a link to the file in the SubLinks form
Dim rstLinks

Set rstLinks = CurrentDb.OpenRecordset("Links")
rstLinks.AddNew
rstLinks.ContactID = Forms!Master!ContactID
rstLinks.LinkDate = Now
rstLinks.Link = "#" & docname & "#"
rstLinks.Comment = strComment
rstLinks.fldFileType = strDocType
rstLinks.Update
rstLinks.Close
End Sub

When I run the code on my Vista computer, I get this error message...
"Run-time error '3027':
Cannot update. Database or object is read-only."

All computers are running Access 2007. Any ideas? Thanks!!!
 
Did you copy the database to your new computer using a CD? If so, uncheck
the read-only attribute on the file.
 
Back
Top