Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-09-2016, 08:33 AM   #16
letsaccess
Newly Registered User
 
Join Date: Oct 2016
Posts: 14
Thanks: 25
Thanked 0 Times in 0 Posts
letsaccess is on a distinguished road
Re: Need some advice

Quote:
Originally Posted by jdraw View Post
What exactly is the DB size issue?
Have you run compact and repair on FE(s)?

You do NOT need multiple BEs.

The FE size is just 20MB but the BE more than 1GB , when I split the DB I sent to every users one FE file to working on it in his Machine should I Compact and repair all of them ?

letsaccess is offline   Reply With Quote
Old 10-09-2016, 08:37 AM   #17
letsaccess
Newly Registered User
 
Join Date: Oct 2016
Posts: 14
Thanks: 25
Thanked 0 Times in 0 Posts
letsaccess is on a distinguished road
Re: Need some advice

Quote:
Originally Posted by CJ_London View Post
you said



Docman suggested



Basically every user should be running their own copy of the front end located on their own machine. If they don't, not only do you get the issues mentioned by Docman, but you also risk corrupting the front end, let alone making it impossible to maintain unless everyone is off the system.
When I split the DB I sent to all users copy of the FE file to use it on his machine is that OK or no , why I can't use many BEs one for each department and link all of them in one FE is that bad idea ?
letsaccess is offline   Reply With Quote
Old 10-09-2016, 09:09 AM   #18
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,138
Thanks: 40
Thanked 3,613 Times in 3,488 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Need some advice

Quote:
why I can't use many BEs one for each department and link all of them in one FE is that bad idea ?
you can, but you won't be able to have relationship rules between the two db's and potentially make it slower.

I'm going to drop out of this discussion for now, but you are obsessing about the db size. Slow performance and size are not related. What matters is a well constructed back and front ends and decent network performance.

You have asked for advice and basically ignoring it in favour of your original two thoughts to resolve the problem.

investigate all of these and answer them
  • slow network (easy to determine) - not answered
  • lack of indexing - not answered
  • poorly designed queries - not answered
  • poorly designed forms - not answered
  • users using same front end (an easy win to fix) - answered, each user has own front end
  • backend needs compacting (another easy fix) - not answered and could solve your size issue


__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is online now   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
letsaccess (10-09-2016)
Reply

Tags
access , link , odbc , sql

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Advice and integer and long advice required smiler44 Excel 4 10-30-2013 07:50 AM
Need Advice Starnheavn General 4 05-04-2012 11:43 AM
Advice? sueviolet Tables 7 07-11-2003 12:55 PM
Bit of Advice Chimp8471 General 6 06-06-2003 01:48 AM
Looking for some advice please.... Monti2 General 3 05-07-2003 09:53 AM




All times are GMT -8. The time now is 12:23 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World