error 3027 Help

[Killa]

I am having a problem i think its to do with the access database security

i open a new recordset as below on my computer this allows me full access to edit the newly created recordset BUT if i run this on another computer i get the 3027 error

I've checked the file and folder permissions and they are ok


how can i get round this ?

what username does dao pass to the database? if one is not supplied is it the log on one or the one from the microsoft application that invoked it or the default admin one?


Dim DbJobmemo As DAO.Database
Dim rsjob As DAO.Recordset
Query$ = "SELECT [Job memo].* "
Query$ = Query$ & "FROM [Job memo] "
Query$ = Query$ & "WHERE ((([Job memo].[Job No])=""" & ProjectNumber & ""&quot);"
' load specific data from fromject number
Set DbJobmemo = OpenDatabase("some file&quot
Set rsjob = DbJobmempenRecordset(Query$)
rsjob.Edit

 

[techoduro]

I've had the same problem, I solved removing the Microsoft DAO 3.6 Objet Library at the references, and adding Microsoft DAO 3.51 Objet Library. My problem popped up when I was trying to update an xbase table, and also when I was trying to write directly to a dotmatrix printer, opening LPT1 as a file. I hope this helps you.