You are here:

Using MS Access/MS Access 2010 Macro Error w/ Multi Users

Advertisement


Question
I recently found a post where you answered a question regarding Access error running a macro when two or more users were logged in.  Your reply was the database should be split into a FE & BE.

My question, is this the ONLY fix.  I have several macros that run from a Switchboard or Main page in a MS Access 2010 database.  When the second person logs in none of the links will work for the second user.

Thanks

Answer
It may not be the only answers, but its by far the #1 answer. EVERY multi- user app NEEDS to be split. This is an absolute requirement that experienced Access developers have recommended for a long time. If you share both the FE and the data, you are asking for trouble plain and simple.

If splitting doesn't fix the issue, then you look further.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.