Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

splitting databases

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

Splitting Databases

ResolvedVersion 2003

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.

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.

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.18 secs.