COMPACT AND REPAIR

[Guest]

Hello,

On a split data base FE/BE using shared folder on network, how do you
perform the compact and repair?Do you go to each and perform this function
and how does it affect the other users that are connected to the same DB?

Thanks

 

['69 Camaro]

Hi.

On a split data base FE/BE using shared folder on network, how do you
perform the compact and repair?Do you go to each and perform this function
Yes.

and how does it affect the other users that are connected to the same DB?

One needs to have exclusive access to the database in order to compact and
repair the database. The database will neither compact nor repair if
another user has the database open. This doesn't mean that one _must_ open
the database in exclusive mode, but with a multiuser database, this is
probably the simplest method.

For more information about on this subject, please see the following Web
page:

http://www.Access.QBuilt.com/html/gem_tips.html#Compacting

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

Thanks for the website and it covers FE/BE design but one more question,

Would it be better the set the current four users for compact and repair on
exit and i would then do the compact and repair on the backend when ever i
wanted ?Version Access 2000 pro
Thanks for the support

 

['69 Camaro]

Hi.

Would it be better the set the current four users for compact and repair on
exit

This makes sense when the FE is copied to each workstation. However, if the
FE is shared by multiple users on the server (not a recommended practice),
then if any other user has the database open when another user exits out,
the compaction will fail.

and i would then do the compact and repair on the backend when ever i
wanted ?

Yes.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

Shared FE???Now i have to ask you since i am new to this, i created my DB and
also created a switchboard for user simplicity.I had my master copy on my
machine, i draged and dropped the FE on each users folder then placed it on
their desktop and linked it to the one shared folder(tables) on the
network.Did i do everything correctly since if i try to change the design for
query on one user, the switchboard button using that query on another user
machine gives an error.Please advise if i did this incorrectly.
Thanks

 

[Tony Toews]

Shared FE???Now i have to ask you since i am new to this, i created my DB and
also created a switchboard for user simplicity.I had my master copy on my
machine, i draged and dropped the FE on each users folder then placed it on
their desktop and linked it to the one shared folder(tables) on the
network.Did i do everything correctly since if i try to change the design for
query on one user, the switchboard button using that query on another user
machine gives an error.Please advise if i did this incorrectly.

Yes, you've done what we recommend.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm