Frontend/backend: Writing data not working on some computers

[Evilferret]

Description of my setup / the problem:

SERVER1 - Holds the database back end. Permissions on the database file (And folders it's in) are full access for everyone.

COMPUTER1 - Windows 7, this computer originally created the database using Access 2010 Professional. This computer runs the front end of the database successfully, no problems.

COMPUTER2 / COMPUTER 3 - Windows XP running Access 2010 Runtime / Windows 7 running Access 2010 Runtime. These computers both get a security warning when opening the database. They read data fine, but do not write any data. No error message is displayed / nothing to indicate that there is a problem.

I have rechecked file/folder permissions on the network and can't find any issues. I'm guessing that the problem either occurs because
(A) Access 2010 Runtime works differently than Access 2010 Professional and is unable to write for some reason (Unlikely)
or
(b) Access 2010 detects that the file didn't originate from the local computer and limits it's permissions for writing data (More likely)



In either case, I'm wondering how to resolve this issue.

[Evilferret]

Figured it out.

My server has a mapped network drive (S:\). Access seems to have trouble with this.

I reconnected my backend as the actual network path (\\Server\Database) rather than referring to it via the mapped network drive (S:\Database), and it worked ok.

[RuralGuy]

Thanks for sharing your solution.