Multi user Database - sizing issues

[Neil07979]

Hi All,

I have created various databases - and have always come accross the problem of users having different pixel settings on their monitor and therefor corrupting the size of the database.

Is there any way to size the actual database depending on the setting of the individual user at the time?

Thanks, Neil

 

[Bob Miller]

Hi All,

I have created various databases - and have always come accross the problem of users having different pixel settings on their monitor and therefor corrupting the size of the database.

Is there any way to size the actual database depending on the setting of the individual user at the time?

Thanks, Neil

Try the Form scaling/resizing tool link here:
http://www.mvps.org/access/general/gen0002.htm
Hope this helps.

 

[The_Doc_Man]

Another issue is that if this is a true multi-user system, you would do better to make a split Front-End/Back-End style. FE/BE splits mean that the forms and such reside on each machine. Only the tables are on your shared server.

See, the issue is that display settings are in the REGISTRY, not in Access itself. They HKEY_LOCAL_MACHINE hive, if I recall correctly. If two users touch a shared, unified (not split) database at the same time and they have different display hardware settings, the forms can only be right for at most one of them. But if the forms are in the FE and are adjusted (perhaps using the link from Bob Miller's post), they should never again be corrupted (for this reason; no guarantees about other causes).