Strange Security Issue

[matthewnsarah07]

Bit of strange one that I can't work out.
We have an annual leave database on a server (G: Drive) - the database is just a simple set of tables and one search form. Staff input a leave request via an InfoPath 2003 form which adds the info to the table in access 2003.

All users have access to both the database and the infopath form, the database used to have an Admin account with password attached but i removed this as users were prompted for it when sending the form.

All is well and good for all but one user - this user has all the correct permissions etc. but when they try to send the form to access gets a Windows 3.1 type box talking about Jet db and asking for an admin password but if i enter the password it will not accept it and if i delete the admin bit it still comes up as an error. All drives are on Windows XP and using Office 2003, box that appears is old fashioned type with drop down box for Readonly, Readwrite etc.

Strange one but has anyone come across this and does anyone have a solution?

Thanks

 

[David Eagar]

What Workgroup is the problem user linked to?

 

[matthewnsarah07]

I believe he will be listed as a standard user - I'm wondering looking at some other posts whether its a case of his acvcount not being able to create on the network drive

 

[boblarson]

I'm wondering looking at some other posts whether its a case of his acvcount not being able to create on the network drive

Remember - each user must have read/write/delte access to the directory that the mdb file is in.