Splitter Manager Killing ME

[Jack R. Jones]

I worked two months developing a program to work with county office.
Has about 5000 records in it. I was able to load the Access file on CD
and carry it to office, show on maching as it developed. Got to smart
for my breeches and used the Splitter Mgr to divide the database. It
created two tables, Just it is supposed to do, one Myappl.mdb and one
Myappl _be.mdb This is fine on my machine, but now when I carry to
office I can't get it to run, can't read Macros etc. I re-linked with
Mgr. but it wants to carry the path from my computer with it. that
path is not in Office machine to be used. SO I wanted to revert to old
(1) part database as originally made and cannot unlink the files. Am I
stuck with this database split? Hope there is some way to cancell the
Splitter from my database and also clear tables marked with arrow
files. I am using Access 2000
--
LuckyLou
Posted via http://dbforums.com

[Bruce M. Thompson]

> I worked two months developing a program to work with county office.

Has about 5000 records in it. I was able to load the Access file on CD
and carry it to office, show on maching as it developed. Got to smart
for my breeches and used the Splitter Mgr to divide the database. It
created two tables, Just it is supposed to do, one Myappl.mdb and one
Myappl _be.mdb This is fine on my machine, but now when I carry to
office I can't get it to run, can't read Macros etc. I re-linked with
Mgr. but it wants to carry the path from my computer with it. that
path is not in Office machine to be used. SO I wanted to revert to old
(1) part database as originally made and cannot unlink the files. Am I
stuck with this database split? Hope there is some way to cancell the
Splitter from my database and also clear tables marked with arrow
files. I am using Access 2000

Under the "File" menu, select "Get External Data, Link Tables" to open the
"Linked Table Manager" which will allow you to specify the "new" location for
the back end tables.

[Bruce M. Thompson]

> Under the "File" menu, select "Get External Data, Link Tables" to open the

"Linked Table Manager" which will allow you to specify the "new" location for
the back end tables.

Oops! forgot my sig.

:-)
--
Bruce M. Thompson
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

[Patrick]

No you can restore it to a single file configuration simply by
manually deleteing the linked tables and importing the tables from the
back end - File/Get External Data/Import.
Patrick
On Wed, 15 Oct 2003 13:27:20 -0400, Jack R. Jones
<me*********@dbforums.com> wrote:

I worked two months developing a program to work with county office.
Has about 5000 records in it. I was able to load the Access file on CD
and carry it to office, show on maching as it developed. Got to smart
for my breeches and used the Splitter Mgr to divide the database. It
created two tables, Just it is supposed to do, one Myappl.mdb and one
Myappl _be.mdb This is fine on my machine, but now when I carry to
office I can't get it to run, can't read Macros etc. I re-linked with
Mgr. but it wants to carry the path from my computer with it. that
path is not in Office machine to be used. SO I wanted to revert to old
(1) part database as originally made and cannot unlink the files. Am I
stuck with this database split? Hope there is some way to cancell the
Splitter from my database and also clear tables marked with arrow
files. I am using Access 2000

[Pieter Linden]

Delete all the linked tables (they have arrows to the left of them)
and go to the file menu, choose import, MS Access, find your back end
db, then import all the tables.

[Jack R. Jones]

Thank you for replying. I am so thick. I worked my gizzard off
yesterday, over six hours. Went back to my backups (old) pasted, the
new forms, reports, macros in. Made an append query to update my
table. Finaly got it, but if I had just known. Now I do. Thanks
again. At 77 I don't grab on as quick as I used to.
--
LuckyLou
Posted via http://dbforums.com