splitting databases

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

Splitting Databases

resolvedResolved · Low Priority · Version 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:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Server loaded in 0.07 secs.