How do I setup a 'split' database?

[DC1]

I wish to change my current database from ‘embedded’ to ‘split’… how do I do this?

[frofa]

See DACM’s tutorial HERE. There is an automated wizard (by the same author) now that lets you do it - see HERE.

[jayArr]

I would STRONGLY advise contemplating a developing a database application to either
a) start out with a split database
or
b) split it at the earliest opportunity particularly if the database exceeds the >50% of the time failing and having you to recover before starting.

A split database (in my experience ) will take the >50% statistic down to <10% of the time.

The time and effort taken to split the database will rapidly be recovered.