G'day, With a (Access 2003) database that is split (frontend application and
backend datatables) how can I 'pass' a password from the frontend that
allows access to the datatables which are secured by the tables.

Tony

"Tony" <ricecustard@hotmail.com> ha scritto nel messaggio
news:4186c96f@news.comindico.com.au...[color=blue]
> G'day, With a (Access 2003) database that is split (frontend application[/color]
and[color=blue]
> backend datatables) how can I 'pass' a password from the frontend that
> allows access to the datatables which are secured by the tables.
>
> Tony[/color]

How do you connect to it?
MAssimiliano

Thanks for your reply.

I have the traditional front end and backend data file where the tables are
linked in the traditional way. Put another way it is the conventional
'split' database situation with linked tables.

In this case the data tables have been protected with a password and this
produces an error when the front end is opened. (Cannot remember the exact
error).

I want a user to be able to open the front end, have it make the connection
by hardcoding the password. This offers me the advantage of the data being
accessed only through the forms.

What I cannot do at the moment is 'pass' the password to the data file.
"MA" <master@massimilianoamendola.it> wrote in message
news:Mw7id.30070$B06.4093@news.edisontel.com...[color=blue]
>
> "Tony" <ricecustard@hotmail.com> ha scritto nel messaggio
> news:4186c96f@news.comindico.com.au...[color=green]
> > G'day, With a (Access 2003) database that is split (frontend application[/color]
> and[color=green]
> > backend datatables) how can I 'pass' a password from the frontend that
> > allows access to the datatables which are secured by the tables.
> >
> > Tony[/color]
>
> How do you connect to it?
> MAssimiliano
>
>[/color]

"Tony" <ricecustard@hotmail.com> ha scritto nel messaggio
news:4189c170$1@news.comindico.com.au...[color=blue]
> Thanks for your reply.
>
> I have the traditional front end and backend data file where the tables[/color]
are[color=blue]
> linked in the traditional way. Put another way it is the conventional
> 'split' database situation with linked tables.
>
> In this case the data tables have been protected with a password and this
> produces an error when the front end is opened. (Cannot remember the[/color]
exact[color=blue]
> error).
>
> I want a user to be able to open the front end, have it make the[/color]
connection[color=blue]
> by hardcoding the password. This offers me the advantage of the data[/color]
being[color=blue]
> accessed only through the forms.
>
> What I cannot do at the moment is 'pass' the password to the data file.[/color]

www.sitocomune.com
sezione tables
Riallegare tabelle. Funziona anche se il Backend e' protetto da password.
di Alessandro Baraldi

ciao
MAssimialino