Issue with attachment field in VBA

[sjslall]

DB Setup
Backend: Table with attachment field
Frontend: Forms with linked table to backend

The app has been created and worked fine.
I was able to add the attachment to the table and retrieve the document.
All went fine.

Now once this was ready for multiuser access, I compiled the VBA code from the VB editor and created a accde file and distributed to the users for testing.

I first tested it on my system and a VM i have and all went well, without any issues.

However whenever another user uses the accde file, they are UNABLE to add a new attachment.

They can Fetch the attachments and View them without any problem.

I did a thourogh check and found that the Error raised was at the:
rs_parent.addnew command

Error:

This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired.

Is there a way like insert into that can be used with the attachment?

Please assist!!!!

 

[HiTechCoach]

I personally avoid the attachment data type. I have had to many issues with them.

See if this helps:
Microsoft® Access 2007 Working with the Attachment DataType

 

[sjslall]

Ok found out why the error is there.
This is not related to just the attachment field.
When I created a dummy Frntend and backend with just a text field and tried adding a rec to the BE database, get error 3027 : DB is read only.
You get this error when someone else tries logging from their system to the shared folder. I however am able to add the rec.

All users have FULL control for write & read on the shared folder.

Need help getting the 3027 error fixed.

TRied with rs=db.openrecordset("table1",dbopendynaset) and get invalid parameter.