Unlink Tables or Un-split 1

[agape234]

I have a db that I was copied from another workstation. I want to look at this db in detail so I can modify it to suit my needs. I see a master folder with some mdb files, and a main.mdb that has a bunch of linked tables in it and not much else.
Point me to a good tutorial on splitting a db, and what the results would be. I am assuming this db has been split.

 

[Lightning]

A Split database usually consists of a Back-end database which contains all the data tables (and nothing else) and a Front-end database with all the Forms, Queries, Reports AND links to the back-end tables. If you have a database which contains "...a bunch of linked tables in it and not much else" you either do not have all the split database OR (most likely) the forms, queries and reports have all been hidden. To check for hidden objects, go to Tools|Options|View and make sure the Hidden Objects and System Objects checkboxes are ticked.

As for a book or tutorial on database splitting, read the Access On-line Help topic Split an Access database and do a keyword search on this site for "Splitting a database". Also check out the FAQ section.

The rationale for a split database is basically to allow multiple users to access current data at the same time, and to allow system development without affecting those same users until you are ready to roll out any changes.

To unsplit a database:
1. Make sure you know where the tables are located. Use the Linked Table Manager to find this.
2. Delete all the links to the tables from your Front-End database.
3. Use Files|Get External Data|Import to import the tables from the Back-end to the Front-End.

Your application is now unsplit.

HTH
Lightning

 

[agape234]

Excellent that helped a bunch.
However, I am seeing a bunch of Select queries that, when I go to look at them they give me the same message, looking at for the info looking for a file share on the old machine. It does open a window that has this in it........
SELECT Sum([Days - Days Table].[Number of Days]) AS [SumOfNumber of Days]
FROM [Days - Days Table]
GROUP BY [Days - Days Table].[Type Day]
HAVING ((([Days - Days Table].[Type Day])="Annual - Enlisted&quot);

What are these and how do I interpret the text inside these.
I don't mess with this stuff often enough.