When attempting to transfer data into a table using Visual Basic Transfer. We can delete the contents of the table from within the VBA Script. When we get to the Transfer command we get the 3027 error. can’t update. database or object is read only.We used to be able to perform this import from 4 different PC’s. We are now down to only 1 PC, an NT workstation that is able to perform this function. It doesn’t matter who is logged in. We are running a NT network, database is on Server.
We can access the database table and enter data into the table manually but not through Visual Basic. Any clues!!??