Temp tables can exist in the FE, or as David Fenton propounds with good
reason, in a separate local mdb created and destroyed for each session. Or
only in memory.
In a multi-user situation, having two people using what they think is "my"
table in a BE could be disastrous.
Clive
"Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote in message
news:407fc5ca$0$39895$5a6aecb4@news.aaisp.net.uk.. .[color=blue]
> "CDB" <alpha@delete.wave.co.nz> wrote in message
> news:c5od4m$d1b$1@news.wave.co.nz...[color=green]
> > The BE is not "opened/closed" by an FE using linked tables from it.[/color]
>
> Thanks, I didn't know that.
>[color=green]
> > How are
> > you opening the back end db?[/color]
>
> FE links to BE tables.
>
> There's a temp table being written I think. Needs to be in the FE?
>
> Cheers, Mike
>[color=green]
> > Clive
> >
> > "Mike MacSween" <mike.macsween.damnthespam@btinternet.com> wrote in[/color]
> message[color=green]
> > news:407fa379$0$39887$5a6aecb4@news.aaisp.net.uk.. .[color=darkred]
> > > The back end is on a server. Compact on close is set on, but on the[/color]
> > clients[color=darkred]
> > > server isn't happening, though no errors are being generated. On my[/color]
> > machine[color=darkred]
> > > here Compact On Close happens fine.
> > >
> > > Is this an NT permissions thing?
> > >
> > > Cheers, Mike
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
