How do macros for menus affect a multi-user...

[Guest]

Hello,

I've almost completed a database that is menu-driven...I have left the
macros for these menus till last.

However, this database will be a multi-user app and will be accessed via a
Citrix Server. Should I go ahead and implement the macros to open/close menus
or should I leave it as it is?

Thanks,

Rookie.

 

[Ken Snell [MVP]]

If you split the database into a backend and a frontend, and give each user
his/her own copy of the frontend, then opening/closing menus will be done
for just that user in that frontend. If you plan to have multiple users use
the same file, don't. This will lead to corruption and many other problems.

See these articles for more info about splitting a database:

http://www.granite.ab.ca/access/splitapp/index.htm

http://members.iinet.net.au/~allenbrowne/ser-01.html

 

[Guest]

Hey Ken,

Thanks for your advice...and the links as well. If that's the case, I won't
split the DB.

Have a great week,

John.

 

[Ken Snell [MVP]]

You may have misunderstood my reply.

If you are going to have multiple users, DO split the database. My comment
about "don't" was a recommendation that you do not have multiple users using
the same file.

Sorry for the confusion.