Link to home
Start Free TrialLog in
Avatar of Mohammad Alsolaiman
Mohammad AlsolaimanFlag for Saudi Arabia

asked on

In network approach, use Split database or one file with shortcut to every client?

Hi:
Which is better to do , when I need to deploy a small application on a network!
1-      Split my ms app. To front and back end, put the back end in the server and then link all clients to it.
2-      Without splitting the ms app. , just put the app file in the server, and take a shortcut to every client.
Please help
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image



In a nutshell:
Split the DB

Front end MDB (accde) on each users workstation.
Linked into one single back end db on a server...
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

  #1, #1, and #1

Jim.
Any and all cases ... Split, each user separate copy of FE. Period.

mx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
#4, great point
trailer...

Access db size limit is 2GB, so with one db, this is your hard limit.
With a very basic split db, you at least then have 4GB
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mohammad Alsolaiman

ASKER

thank you very much for participate