splitting databases
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Splitting Databases

Splitting Databases

resolvedResolved · Low Priority · Version 2003

replyReply Fri 20 Mar 2009, 16:37Delegate Katharine said...

Katharine has attended:
Access Advanced course

Splitting Databases

Is there a need to split the database if it will be webbased and accessed remotely from 9 sites.

For upcoming training course dates see: Pricing & availability

replyReply Tue 7 Apr 2009, 15:54Trainer Andrew said...

RE: Splitting Databases

Hi Katherine

Thank you for your question. The purpose of the utility to split Access databases (Tools > Database Utilities > Database splitter) is to spread the operational load across two databases. The backend database will store the tables and the front end database focusses on users forms and queries.

With regard to web hosting it's hard to give a definitive answer. It will most likely depend on how the website interacts with your database and for that you need to talk to your website administrator.

Kind regards,
Andrew

Tue 14 Apr 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
training for microsoft access and other Microsoft training courses.

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard