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 & """
);"
' load specific data from fromject number
Set DbJobmemo = OpenDatabase("some file"
Set rsjob = DbJobmempenRecordset(Query$)
rsjob.Edit
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 & """
);"' load specific data from fromject number
Set DbJobmemo = OpenDatabase("some file"
Set rsjob = DbJobmem
penRecordset(Query$)rsjob.Edit
