Database Splitter

[fong.yang@martecgroup.com]

I used the Database Splitter wizard in Access 2002 to split my database
into front end database and back end database. How do I undo the split
and join them back into just one database. Thanks.

[Keith Wilby]

Re: Database Splitter

<fong.yang@mart ecgroup.com> wrote in message
news:1141748042 .314484.96650@i 40g2000cwc.goog legroups.com...[color=blue]
>I used the Database Splitter wizard in Access 2002 to split my database
> into front end database and back end database. How do I undo the split
> and join them back into just one database. Thanks.
>[/color]
Delete the *linked* tables and import the actual tables in their place.

Keith.

https://www.keithwilby.com

[Larry Linson]

Re: Database Splitter

<fong.yang@mart ecgroup.com> wrote
[color=blue]
> I used the Database Splitter wizard in Access
> 2002 to split my database into front end
> database and back end database. How do I
> undo the split and join them back into just
> one database. Thanks.[/color]

There is no "unsplitter wizard", so you will have to do it manually...
others have given you some suggestions. It is easy to simply delete the
bound tables and queries, and use Files | Get External Data | Import...

Larry Linson
Microsoft Access MVP

Larry Linson
Microsoft Access MVP

[salad]

Re: Database Splitter

Larry Linson wrote:
[color=blue]
> <fong.yang@mart ecgroup.com> wrote
>[color=green]
> > I used the Database Splitter wizard in Access
> > 2002 to split my database into front end
> > database and back end database. How do I
> > undo the split and join them back into just
> > one database. Thanks.[/color]
>
> There is no "unsplitter wizard", so you will have to do it manually...
> others have given you some suggestions. It is easy to simply delete the
> bound tables and queries, and use Files | Get External Data | Import...
>
> Larry Linson
> Microsoft Access MVP
>
> Larry Linson
> Microsoft Access MVP
>
>[/color]
Or create a new database and then import the front end (as well as
menus) and the import the backend. Rename to whatever.

[Larry Linson]

Re: Database Splitter

Yours is probably a better approach, as it can clear up some hidden glitches
that may occur during development.

Larry Linson
Microsoft Access MVP

"salad" <oil@vinegar.co m> wrote in message
news:Fv3Qf.2087 $k75.708@newsre ad3.news.atl.ea rthlink.net...[color=blue]
> Larry Linson wrote:
>[color=green]
>> <fong.yang@mart ecgroup.com> wrote
>>[color=darkred]
>> > I used the Database Splitter wizard in Access
>> > 2002 to split my database into front end
>> > database and back end database. How do I
>> > undo the split and join them back into just
>> > one database. Thanks.[/color]
>>
>> There is no "unsplitter wizard", so you will have to do it manually...
>> others have given you some suggestions. It is easy to simply delete the
>> bound tables and queries, and use Files | Get External Data | Import...
>>
>> Larry Linson
>> Microsoft Access MVP
>>
>> Larry Linson
>> Microsoft Access MVP[/color]
> Or create a new database and then import the front end (as well as menus)
> and the import the backend. Rename to whatever.[/color]