Slow server

[ebiscaro]

Is this feaseble?

My table are on a server linked to the user FORM, Queries ETC. The server, is somehow slow. I was thinking: is there a way to have all user to have all the DB in their hard drive and only refresh the new data I will put on the server each time they open their database?
Thank you

 

[namliam]

As long as its read only (server => DB) offcourse!! Keep in mind tho Access has a 2 GB datalimit...

if users then want to update and upload (DB => Server) also doable but hard nut to crack taking into account multiple changes by different users and stuff [Dont start on this one {Just my advice}]

Regards

The Mailman

 

[ebiscaro]

how to?

Thank you, The database is read only but for me who upload and manage the data entry so I guess this could be done, the only problem is that I do not know how? Sorry, can you at least put me on the right way?
Thank you also for the 2 GB limit, I did not know that.
Ciao

 

[namliam]

The 2 gb limit isnt really a problem as you can have multiple BE, although responsetimes are going to get more and more a problem...

The refreshing is not that hard, just use linked tables to the servers and run a series of append/update queries.

You might want to keep track of the updates in a work table or something.

Hope this will get you going....

Regards