Best way to have a network database

[rsbutterfly16]

hi guys, as of now i have a network access 2003 database as a front end and the sql server 2000 as the backend. I have done some research and i read some forums that the best way to have a fe access db is to actually have a copy for each user locally? is that correct???, then what happens to the datasource? do i have to create one in each local computer? and also if i add or update a report then i have to go to each computer and add it?

 

[Adeptus]

hi guys, as of now i have a network access 2003 database as a front end and the sql server 2000 as the backend. I have done some research and i read some forums that the best way to have a fe access db is to actually have a copy for each user locally? is that correct???,

Best? hmm...
Pro's: Faster execution, and reduced load on the network.
Con's: Harder to maintain (see below).

then what happens to the datasource? do i have to create one in each local computer?

You mean ODBC settings? Yep.

and also if i add or update a report then i have to go to each computer and add it?

Yep.

 

[Kodo]

if i add or update a report then i have to go to each computer and add it?

in addition to the above reponse; Remember, you can be clever as how the new file gets to the client .If you update a report etc.. you put a copy on the server and set a login script up to copy the db fe to their machine when they login.