Access 2000 - Unlink databases

[dsmith910]

Hi

I have inherited a dbase which is essentially two dbases linked together. One has tables and virtually nothing else - but that is the only place you can add columns, formating or whatever to a table. The other is where you input the data and it has the queries and reports on it.

Both dbases reside on the same drive in the same folder and are used by only one user. Any ideas what advantage this setup might give? Would I be better to split the two dbases and if so how do I do it?

I intend holding a copy of the dbase and the spreadsheets which now belong with it on a disk off site for security purposes. Thus it would be easier if it were one dbase not two.

Thanks

Doreen

 

[PepeLeMokko]

You have inherited a splitted database, which has the advantage that if you want to work on the objects ( queries, reports, etc..) in a multi user environment, you can do so without affecting the work of the other users.
To split a database, use Tools>database utilities > database splitter

 

[dsmith910]

Hi PepeLeMokko
Many thanks - will have a look at this tonight. If I understand you right with a one user system there's no point or advantage to having it set up that way so I'll split it and stick with just one dbase.

Doreen

 

[JimRich]

There is an advantage if you need to backup just the data file.

Also if you develop another database that needs some of the same data you can more easily use linked data.

Jim

 

[dsmith910]

Hi Jim

Thanks! Will consider this before I actually split the dbase - don't want to make things more awkward.

Doreen