Split Database Problem

[funderburgh]

I have a prior thread regarding a message about "Linked" tables, which I don't believe I have. Digging around only finds references to importing or sharing data with other databases, which I am not doing.

However, I have split the database so I can have the data reside on a server and applications on workstations. Since the split I have added tables. These tables are not showing immediate updates, they are acting like the forms and reports of the application.

I suspect that my problem getting messages about "linked" tables stems from the fact that the database has been split, or that I have added tables after the split.

I tried spliting again, and the results were really bad - I could not even start the application.

Anyone know how to "un-split" or "re-split", or have any other perspective? Any help is warmly appreciated.

 

[rainman89]

create a new database and import everything into that.

You might have to point your queries to the correct tables etc, but that should work.

then BACKUP and try again.

 

[funderburgh]

Thanks for your help. BTW, I am fully backed up (including off site). That's why when I tried to split again and had a problem I easily went back to the state before that operation. I don't have archived generations of my development however that would allow me to restore to a specific point in the process. That would be great, but impractical in our environment.

 

[rainman89]

I always backup with a time that way i know that before 12:45 it was working, and now its not, ill go to 12:45 and restore from there.

Hope that works for you.

 

[boblarson]

When you add tables to the backend, you need to link them by going to the frontend and running the FILE > GET EXTERNAL DATA > LINK TABLES selection and then selecting the new tables in the dialog after selecting the backend database in the list.

You don't need to split over.

 

[funderburgh]

Thanks so much for the help, this one was confusing. I am correct though, that if I want to add a field I have to "unsplit" - right? Or is there a trick that will allow me to modify the structure of a split (linked) table?

 

[boblarson]

Thanks so much for the help, this one was confusing. I am correct though, that if I want to add a field I have to "unsplit" - right? Or is there a trick that will allow me to modify the structure of a split (linked) table?

make the change in the backend then go to the frontend, delete the linked table in the frontend and then relink it.