one database or two?

[TwentySixDays]

HI,
I have a sales system with a telesale element.
I have designed the system all with Access 2007 databases one front end and two backends.
The front end has all the code, forms and reports and sits on each users PC.
The two backends sit on another PC.
The back ends are split between customer information in one and all the other data in the other. This was done so that we could email the small customer database to a remote site that did not need the sales order information.

The question is. Is having two backend databases less efficient for order entry which needs customer and sales information than if I put all the data in one database?

Thanks.

 

[Mr. B]

In my opinion, there would no difference. While there are other ways of accomplishing what you are doing by using the method you describe, if it works for you then there should not be any other issues. Access will not know the difference between the two databases. In fact, I have seen comments from others that talked about being able to have larger data sets (exceeding the 2 gig limit per one database file) by having a frontend access multiple database files.

Good luck with your project.

 

[TwentySixDays]

In my opinion, there would no difference...Good luck with your project.

Thanks for the info. I am trying to convince them that should change to SQL Server in the near future. There are 4/5 concurrent users and response times are suffering.

Stuart.

 

[Simon_MT]

The problem with two BE databases is overcoming the ldb file that slows down queries. With FE/BE solutions I keep a BE File always open. This has had a dramatic effect on performance since Access 1997. I did implement a dual BE at one stage and permanently opened a file in both BE files. Like you there were reasons for doing this then I thought - just consolidate both into one.

Simon

 

[TwentySixDays]

...With FE/BE solutions I keep a BE File always open....
Simon

Thanks again Simon, sorry my resposes are slow but would you believe we don't have internet at work .

1) When you say keep the BE database open, do I just need to open on my PC (or the one the BE is on) or is there a setting I need to change?

2) The reason for the two BE has not really materialized as the remote user can now dail-in so I am going to consolidate them shortly and make my like a bit easier .

Stuart

 

[Simon_MT]

I have a table called Companies that I store all my common variables. This is Bound to the Main Menu which stays open so that every user stays attached to the backend. Some developers, hide a small form to do the same trick.

Simon

 

[TwentySixDays]

Thanks Simon