Operation must have an updateable query . . .

[Robeen]

Access 2010.
Split Database.

I have a 'Save' button on a Form that Inserts a record with 6 values into a linked table using something like this:

            strSQL = "INSERT INTO Work_Load_Daily (Work_Date, Master_Category, Type, Accounts, UserID, DateTime_Entered) "
            strSQL = strSQL & "VALUES (" & "#" & Work_Date & "#" & ", " & "'" & strMasterCat & "'" & ", " & "'" & strType & "'" & ", " & intAccounts & ", " & "'" & strUser & "'" & ", " & "#" & TimeStamp & "#" & "); "

            DoCmd.SetWarnings WarningsOff
            DoCmd.RunSQL strSQL
            DoCmd.SetWarnings WarningsOn

On my computer, this works just fine and the record is inserted as required.
When I copied the Front end to a user's machine and tried to add a record - I got an error that said something like:

Operation must have an updateable query . . .

In the same DB - on the user's machine, I am able to open up and view [using buttons on another form] previous records that I entered during testing from my machine . . .

My first thought was whether the User needs permission to write to the location that the linked tables are in . . . but I don't know for sure.
I thought that since I have the tables on a 'shared' drive that all users have access to . . .

Any ideas?

Thanks!!



Robeen

[lfpm062010]

Things to check On user's machine.

1) Is there a query name "Work_Load_Daily"?

2) Did you refresh the link table "Work_Load_Daily"?

3) When you open the link table "Work_Load_Daily", can you add new records?

[Robeen]

1. Work_Load_Daily is a table only - no query with that name.
2. ?? How would I refresh the link table from the User's machine? She does not have MS Access installed - all she [and I] can see from her machine are the Forms that are available at run time.
3. On the User's machine, I cannot open any Tables. Access is not installed on that machine. Only my Forms are available using the Access Runtime.

I still think that it might be a permissions issue - but not sure exactly what I need to change.

[lfpm062010]

Can the user create a simple test text file on the location where the link table resides?