Re: Lost all joins

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Not butting in. All advice is always welcome.
I turned offthe autocorrect option and also in the ImportObjects Screen, i
went into the options screen and selected them all. And it WORKED.
It was simple -once you know it.

Thank you

"Gary Walter" wrote:

> Hi Sylvie,
>
> PMFBI
>
> I'm still running AccessXP so do not know
> for sure if following is important for 2003...
>
> try this:
>
> Start a new db for front end.
>
> Turn off Autocorrect in Options.
>
> Import only the tables.
>
> Relink to new backend.
>
> Now, import everything else.
>
> Apologies again for butting in,
>
> gary
>
>
> "Sylvie" <Sylvie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:4DA00A84-4786-41AD-BB4F-631A31397752@xxxxxxxxxxxxxxxx
> > Hi Michel, thank you. I had tried it and it doesn't work.
> >
> > Hi Steve, thank you for your input. The tables are still linked (i checked
> > the relationship screen), it is just the joins in all the queries that are
> > gone. Plus all the fieldname in the field pane of the query design have
> > been
> > replaced by exp1, exp2, etc... followed by : and then the fieldname.
> > So not only do i have to redo all the joints but i need to go to each
> > fieldname to erase the first part so the fieldname shows.
> >
> >
> >
> > Steve, i will keep your code and try and figure it out so i can customize
> > it
> > for other databases
> >
> > "Sylvie" wrote:
> >
> >> I made a copy of a database which is made up of a front and back end.
> >> The backend data doesn't change. Then in the copy version of the
> >> database, I
> >> relinked all tables. But when i checked the queries all joins between
> >> tables
> >> are gone and i have to recreate all those links for the queries to run.
> >> Is this normal in Access 2003?
> >> If there a way to recreate all those joins automatically (it would be a
> >> huge
> >> amount of work of recreate all of them manually).
> >> Help
> >>
>
>
>
.

Quantcast