MDB does not reflects updated result to remote user ?

[puneet82sri]

Hi All,

I am facing a problem where remote users are not getting updated results on
java application even after the MDB has been updated on server m/c. Remote
application is using system DSN.

1. Remote application are connected with MDB on a server.
2. I update the MDB by copying the new MDB.
3. Remote app still get old results.

But if the MDB is accessed from the server, results are updated.

* Please detail the cause.
* What needs to be done to solve the problem ?


Thanks
Puneet

 

[Maha Arupputhan Pappan]

Hi Puneet,

Good day.

Suspect it could be access rights/privelege issue. Does all the users has
read/write access to the folder where the MDB is stored?

How do you link the MDB at clients? Please explain.

 

[puneet82sri via AccessMonster.com]

Suspect it could be access rights/privelege issue. Does all the users has

read/write access to the folder where the MDB is stored?

Yes i have given all writes.

How do you link the MDB at clients? Please explain.

Its through system dsn.

It seems to be some caching in connection object.

But the strange part is if i open the mdb and save it, remote user gets
updated results.


Thanks
Puneet

--

 

[Maha Arupputhan Pappan]

I linked a table from a MDB. Update the linked table from Form input.
Refreshed the linked table in the application, surprisingly worked fine.

Try allowing group "Everyone" with Full Control for the folder. See if this
helps. I did the same here.