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 4 2675
-----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 programmaticall y link a table using the TransferDatabas e 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;D atabase=C:\Acco unts\Accounts.m db"
See the Access VBA Help article "TransferDataba se Method" for more info.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQkG1f4echKq OuFEgEQJkGgCgpw 3EXA9/Z1wXWgeYrXTnixQ iCtEAoPlT
sXEANBF4a7lByld Kfhex5t4N
=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.
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 <me@privacy.com > wrote in message news:<5A******* *********@newsr ead3.news.pas.e arthlink.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 programmaticall y link a table using the TransferDatabas e 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;D atabase=C:\Acco unts\Accounts.m db"
See the Access VBA Help article "TransferDataba se Method" for more info.
-- MGFoster:::mgf0 0 <at> earthlink <decimal-point> net Oakland, CA (USA)
-----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv
iQA/AwUBQkG1f4echKq OuFEgEQJkGgCgpw 3EXA9/Z1wXWgeYrXTnixQ iCtEAoPlT sXEANBF4a7lByld Kfhex5t4N =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.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Read the Access Help article "Import or link data and objects" and the
VBA Help article "TransferDataba se 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 TransferDatabas e Method article: open the Debug window (Ctrl
G while in Access) and type in "transferdataba se" (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 "TransferDataba se Method"
(include the quotes) as the search string. I got about 1,180 hits.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQkRtA4echKq OuFEgEQJ3YQCghy Q/1+f/hoSwCWoHcfipkJk NOLMAoO7j
xdyIEC26HqGEBY1 3P+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 <me@privacy.com > wrote in message news:<5A******* *********@newsr ead3.news.pas.e arthlink.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 programmaticall y link a table using the TransferDatabas e 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;D atabase=C:\Acco unts\Accounts.m db"
See the Access VBA Help article "TransferDataba se Method" for more info.
-- MGFoster:::mg f00 <at> earthlink <decimal-point> net Oakland, CA (USA)
-----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv
iQA/AwUBQkG1f4echKq OuFEgEQJkGgCgpw 3EXA9/Z1wXWgeYrXTnixQ iCtEAoPlT sXEANBF4a7lBy ldKfhex5t4N =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.
Thanks for the advice!
Happy programming..
Me.Name
MGFoster <me@privacy.com > wrote in message news:<12******* **********@news read1.news.pas. earthlink.net>. .. -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Read the Access Help article "Import or link data and objects" and the VBA Help article "TransferDataba se 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 TransferDatabas e Method article: open the Debug window (Ctrl G while in Access) and type in "transferdataba se" (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 "TransferDataba se Method" (include the quotes) as the search string. I got about 1,180 hits.
-- MGFoster:::mgf0 0 <at> earthlink <decimal-point> net Oakland, CA (USA)
-----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv
iQA/AwUBQkRtA4echKq OuFEgEQJ3YQCghy Q/1+f/hoSwCWoHcfipkJk NOLMAoO7j xdyIEC26HqGEBY1 3P+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 <me@privacy.com > wrote in message news:<5A******* *********@newsr ead3.news.pas.e arthlink.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 programmaticall y link a table using the TransferDatabas e 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;D atabase=C:\Acco unts\Accounts.m db"
See the Access VBA Help article "TransferDataba se Method" for more info.
-- MGFoster:::mg f00 <at> earthlink <decimal-point> net Oakland, CA (USA)
-----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv
iQA/AwUBQkG1f4echKq OuFEgEQJkGgCgpw 3EXA9/Z1wXWgeYrXTnixQ iCtEAoPlT sXEANBF4a7lBy ldKfhex5t4N =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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sigurd Bruteig |
last post by:
Hi!
I have a passwordprotected backend. I just realised that you can download a
cracking application that can crack a password with up to 18 signs. I have
tryed it and it works. My question is: is there any other software capable
to crack password with more than 18 signs, and how long can a password be in
Access.
Sigurd
|
by: Chris |
last post by:
I have a frontend that has some tables which are linked to a backend.
Now I want to make the backend password protected and when I try to
run it password protected I can't open it. In the first form that
opens in the front end, I added the following to the form_open event:
Dim cnn As ADODB.connection
Set cnn = New ADODB.connection
cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.Properties("Data Source") = "C:\backend.mdb"
|
by: Chris |
last post by:
I have a frontend that has some tables which are linked to a backend.
Now I want to make the backend password protected and when I try to
run it password protected I can't open it. In the first form that
opens in the front end, I added the following to the form_open event:
Dim cnn As ADODB.connection
Set cnn = New ADODB.connection
cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.Properties("Data Source") = "C:\backend.mdb"
|
by: Chris |
last post by:
I have a frontend that has some tables which are linked to a backend.
Now I want to make the backend password protected and when I try to
run it password protected I can't open it. In the first form that
opens in the front end, I added the following to the form_open event:
Dim cnn As ADODB.connection
Set cnn = New ADODB.connection
cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.Properties("Data Source") = "C:\backend.mdb"
|
by: Tony |
last post by:
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
| |
by: Geir Baardsen |
last post by:
Hi!
I wonder if anybody can help with the following:
I need to password-protect tables in MyBackEnd.DB, which is placed in
the same folder as the MyFrontEnd.DB
Now I've tried the KB_209953 article in the microsoft knowledge-base,
and I also looked
up the module example in the developer 2000 edition.
|
by: Mike |
last post by:
I have developed a program that has the backend on a server and
multiple users have the front end at their individual computers.
I know how to set a password on the backend. How can I implement the
requirement for entry of this password for each user as they sign in on
the front end?
Thank you for the help in advance
Mike
|
by: Matthew |
last post by:
I have a backend on the server, each user has a front end on their Local
drives. I am about to give the backend a database password. I do not have
MS security on the database and at the moment anyone can open the backend
and see/edit all the tables. Is a database password recommended? Are there
any speed issues when the FE connects?
The other thing is the only way I can see to relink the tables once I have
put a password on the BE, is...
|
by: Frank L |
last post by:
I have some accounting and tax receipting type applications, developed
for charitable and non profit groups, that are exhibiting strange
behaviour on a few of the 30 or 40 user machines.
When some users (about 3 or 4 it seems) close the frontend db the Access
database password prompt appears. Users can just Cancel the pw prompt
(or enter the correct password) and the db will then close.
On the MS Office forum I found a post that...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |