Multiple User Database 2003 - Best way to deploy (nationally)

[noaccessguru]

Great, thats what I though.
It will just be me for the moment...but will have an ACL set up for this for others eventually to be added if needed.



Thanks

[ssanfu]

Had to add my 2 cents.....

<snip>...and by the sounds of it if I have multiple users using the same FE it will cause the database to run pretty slowly.

Three things:

1) Multiple people accessing the (one) FE from a server location will corrupt your BE. Not a question if IF, just when.

2) It is slow because you have to transfer all of the data PLUS the forms, queries & reports from the FE server location to your hard drive. If the FE is located on your hard drive, only the data has to come across the network.

3) If you have any local tables (tables in the FE that hold intermediate data or temp data) and you have multiple people in the (one) FE, they will be contaminating/corrupting/mixing data in each others forms/reports. Not very reliable.

<snip>I cant imagine the database will exceed 2GB in a hurry<snip>

Make sure you do a Compact & Repair on a regular basis to combat bloat. And that you make backups. Hopefully, the network drive will be backed up every night.

[June7]

Good point about the temp tables in FE, I forgot to mention that.