Upgrade from 97 to 2003 and Splitting Database

[Lynne Eske]

Hello,

The company where I work is upgrading from 97 to 2003

Today I was asked to install 2003 on my PC

In the email about how to do the install and convert the database I was
advised that if the database used local tables then the database should be
split.

I followed the instructions but ...........

Firstly, why should I split the database ?

The database has about 30 tables with one of them having about 9000 records.

Secondly, the database was 'secure' before I split it and after the split
there appeared another database just with the tables in.
However, I can access this database without any security whatsoever.
The original database is still secure and it shows the linked tables but how
do I secure the new database ?
Am I right in saying that I now have two databases, a front end and a back
end ?

If so what is the advantage as all it's done is make my data unsecure

Thanks

Lynne

 

['69 Camaro]

Hi, Lynne.

Firstly, why should I split the database ?

If it's a multiuser database and everyone is sharing the same database file from
across the network, corruption is more likely. If you split the database and
place the back end (tables and relationships) on the server and place a copy of
the front end (all other objects) on each user's workstation, there will be less
chances of corruption, you'll be able to update the database with changes more
easily, you'll avoid many concurrency issues, and you can increase performance.
For more information on split databases, please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

Secondly, the database was 'secure' before I split it and after the split
there appeared another database just with the tables in.

That happens when you use the Database Splitter Wizard. I'd advise against
that. If you use it, you'll have to secure the back end afterwards. A
double-whammy. Instead, it's easier if you follow Access MVP Joan Wild's steps:

http://www.jmwild.com/SplitSecure.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.