Re: Lost all joins

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
>>


.