Search results

I manage and maintain a few multiuser Access databases (each one has no more than 5 users at any given time). One occassional nagging problem that I encounter is my db being placed in an 'unuseable' state (i.e. db needs to be repaired before continued use). I am assuming that this problem is...

Have a database being used in a multiuser on evironment that, on occasion, is placed into an 'unusable' state and requires kicking all the users out and repairing it. Wonder if some error handling might prevent this from happening. Thoughts? Opinions? Thanks

I have a front-end and a back-end which both reside on the server. The tables are simply linked. Is there a better (read, more efficient) way to do this? Have always thought that performing the link thru code or ODBC would be more efficient but thought I would check in with experts. thx