Split databases

[JimS]

I have been developing a db for some time now. Its tables are either local or
link to an older db (dbname-BE.mdb). I want to make all the local tables into
a backend. I used "database splitter", which has worked fine for me in the
past, and it bombed with subscript out of range errors. I presume it has
something to do with the existing linked tables, but I'm not sure.

I tried to manually do the job by creating a linked table pointing to a
"backend" set of tables, then renaming, but the rename process wants me to
delete all the relationships first. Maybe the secret is to go backwards, in
other words, create a blank db, then copy all the database objects into it
except the tables, then link all the tables.

Any other thoughts?

 

[Craig]

Jim,

Your headed in the right direction. Usually what I do is to keep the tables
local until I'm ready to distribute my db. Reason being is so that I don't
have to jump back and forth to make table changes.