Password on BackEnd.Db

[Geir Baardsen]

Hi!
1. I wonder if there is a possibility to open a BackEnd.Db from the
opening form, the form e.g.: frmOrders, in the FrontEnd.Db, when the
BackEnd.Db is password protected?

2. Do I need to do this with all forms, or can I somehow have a
refreshing links function that at the same time pass the password to
the linked tables in the BackEnd.Db?

The password is set only for opening the database itself, no grouping
levels etc.

Me.Name

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You should link the table to the .mdb file where the form resides. When
you manually link the tables you will be prompted for the password.
Once the link is successful the password will be part of the tables'
Connection strings. See the Access Help article "Import or link data
and objects" for more info.

You can programmatically link a table using the TransferDatabase method
of the DoCmd object. One of the parameters of that method is the
connect string. You can include the password in the connect string like
this:

"PWD=password;Database=C:\Accounts\Accounts.md b"

See the Access VBA Help article "TransferDatabase Method" for more info.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkG1f4echKqOuFEgEQJkGgCgpw3EXA9/Z1wXWgeYrXTnixQiCtEAoPlT
sXEANBF4a7lByldKfhex5t4N
=8EEn
-----END PGP SIGNATURE-----
Geir Baardsen wrote:

Hi!
1. I wonder if there is a possibility to open a BackEnd.Db from the
opening form, the form e.g.: frmOrders, in the FrontEnd.Db, when the
BackEnd.Db is password protected?

2. Do I need to do this with all forms, or can I somehow have a
refreshing links function that at the same time pass the password to
the linked tables in the BackEnd.Db?

The password is set only for opening the database itself, no grouping
levels etc.

[Geir Baardsen]

I use only DAO. Would this make a difference?

Sorry, I have not really worked with this kind of techniques before,
so I'd appreciate if you would give me detailed example on how to code
this from the FrontEnd.Db, or point me to any article that covers
this.

Sorry the inconvenience...

Me.Name
MGFoster <[e-mail]> wrote in message news:<5A****************@newsread3.news.pas.earthl ink.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You should link the table to the .mdb file where the form resides. When
you manually link the tables you will be prompted for the password.
Once the link is successful the password will be part of the tables'
Connection strings. See the Access Help article "Import or link data
and objects" for more info.

You can programmatically link a table using the TransferDatabase method
of the DoCmd object. One of the parameters of that method is the
connect string. You can include the password in the connect string like
this:

"PWD=password;Database=C:\Accounts\Accounts.md b"

See the Access VBA Help article "TransferDatabase Method" for more info.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkG1f4echKqOuFEgEQJkGgCgpw3EXA9/Z1wXWgeYrXTnixQiCtEAoPlT
sXEANBF4a7lByldKfhex5t4N
=8EEn
-----END PGP SIGNATURE-----
Geir Baardsen wrote:

Hi!
1. I wonder if there is a possibility to open a BackEnd.Db from the
opening form, the form e.g.: frmOrders, in the FrontEnd.Db, when the
BackEnd.Db is password protected?

2. Do I need to do this with all forms, or can I somehow have a
refreshing links function that at the same time pass the password to
the linked tables in the BackEnd.Db?

The password is set only for opening the database itself, no grouping
levels etc.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Read the Access Help article "Import or link data and objects" and the
VBA Help article "TransferDatabase Method." Using the Access Help
Contents tab for the link article, the hierarchy is this:

Working with Data
External Data
Importing and Linking Data or Objects
Import or link data and objects

To get the TransferDatabase Method article: open the Debug window (Ctrl
G while in Access) and type in "transferdatabase" (without the quotes).
Make sure the cursor is in the word and hit the F1 key. The article
should appear in the Help window.

You could also go to Google.com and enter "TransferDatabase Method"
(include the quotes) as the search string. I got about 1,180 hits.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkRtA4echKqOuFEgEQJ3YQCghyQ/1+f/hoSwCWoHcfipkJkNOLMAoO7j
xdyIEC26HqGEBY13P+0bUpdY
=PdhJ
-----END PGP SIGNATURE-----
Geir Baardsen wrote:

I use only DAO. Would this make a difference?

Sorry, I have not really worked with this kind of techniques before,
so I'd appreciate if you would give me detailed example on how to code
this from the FrontEnd.Db, or point me to any article that covers
this.

Sorry the inconvenience...

Me.Name
MGFoster <[e-mail]> wrote in message news:<5A****************@newsread3.news.pas.earthl ink.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You should link the table to the .mdb file where the form resides. When
you manually link the tables you will be prompted for the password.
Once the link is successful the password will be part of the tables'
Connection strings. See the Access Help article "Import or link data
and objects" for more info.

You can programmatically link a table using the TransferDatabase method
of the DoCmd object. One of the parameters of that method is the
connect string. You can include the password in the connect string like
this:

"PWD=password;Database=C:\Accounts\Accounts.md b"

See the Access VBA Help article "TransferDatabase Method" for more info.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkG1f4echKqOuFEgEQJkGgCgpw3EXA9/Z1wXWgeYrXTnixQiCtEAoPlT
sXEANBF4a7lByldKfhex5t4N
=8EEn
-----END PGP SIGNATURE-----
Geir Baardsen wrote:

Hi!
1. I wonder if there is a possibility to open a BackEnd.Db from the
opening form, the form e.g.: frmOrders, in the FrontEnd.Db, when the
BackEnd.Db is password protected?

2. Do I need to do this with all forms, or can I somehow have a
refreshing links function that at the same time pass the password to
the linked tables in the BackEnd.Db?

The password is set only for opening the database itself, no grouping
levels etc.

[Geir Baardsen]

Thanks for the advice!

Happy programming..

Me.Name

MGFoster <[e-mail]> wrote in message news:<12*****************@newsread1.news.pas.earth link.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Read the Access Help article "Import or link data and objects" and the
VBA Help article "TransferDatabase Method." Using the Access Help
Contents tab for the link article, the hierarchy is this:

Working with Data
External Data
Importing and Linking Data or Objects
Import or link data and objects

To get the TransferDatabase Method article: open the Debug window (Ctrl
G while in Access) and type in "transferdatabase" (without the quotes).
Make sure the cursor is in the word and hit the F1 key. The article
should appear in the Help window.

You could also go to Google.com and enter "TransferDatabase Method"
(include the quotes) as the search string. I got about 1,180 hits.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkRtA4echKqOuFEgEQJ3YQCghyQ/1+f/hoSwCWoHcfipkJkNOLMAoO7j
xdyIEC26HqGEBY13P+0bUpdY
=PdhJ
-----END PGP SIGNATURE-----
Geir Baardsen wrote:

I use only DAO. Would this make a difference?

Sorry, I have not really worked with this kind of techniques before,
so I'd appreciate if you would give me detailed example on how to code
this from the FrontEnd.Db, or point me to any article that covers
this.

Sorry the inconvenience...

Me.Name
MGFoster <[e-mail]> wrote in message news:<5A****************@newsread3.news.pas.earthl ink.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You should link the table to the .mdb file where the form resides. When
you manually link the tables you will be prompted for the password.
Once the link is successful the password will be part of the tables'
Connection strings. See the Access Help article "Import or link data
and objects" for more info.

You can programmatically link a table using the TransferDatabase method
of the DoCmd object. One of the parameters of that method is the
connect string. You can include the password in the connect string like
this:

"PWD=password;Database=C:\Accounts\Accounts.md b"

See the Access VBA Help article "TransferDatabase Method" for more info.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkG1f4echKqOuFEgEQJkGgCgpw3EXA9/Z1wXWgeYrXTnixQiCtEAoPlT
sXEANBF4a7lByldKfhex5t4N
=8EEn
-----END PGP SIGNATURE-----
Geir Baardsen wrote:

Hi!
1. I wonder if there is a possibility to open a BackEnd.Db from the
opening form, the form e.g.: frmOrders, in the FrontEnd.Db, when the
BackEnd.Db is password protected?

2. Do I need to do this with all forms, or can I somehow have a
refreshing links function that at the same time pass the password to
the linked tables in the BackEnd.Db?

The password is set only for opening the database itself, no grouping
levels etc.