linking to password protected b/e & relationshis

  • Thread starter Thread starter wphx
  • Start date Start date
W

wphx

Hi,

I have a FE/BE application. It is running fine. However, I tried password
protecting the backend, and since doing that the tables of the BE *but not*
the relationships are displayed in the FE relationships. Also I am not able
to create relationships between tables in the FE and those in the BE which
apear in the relationships.

Does anyone know anything about this behaviour?

Thanks
 
You have to include the password in the connect string for all your tables.
The easiest way is to delete the table in the front end. This will not
actually delete the table, but only deletes the connection. Then relink the
table and supply the password when you do the link. Or, you can manually
modify the connect sting.

For example, a connect string without a password:
;DATABASE=\\ServerName\FolderName\MyMdb.mdb

And With a password:

MS Access;PWD=Froggy;DATABASE=\\ServerName\FolderName\MyMdb.mdb
 
I thought had been doing this programatically

i.e.
read thru tabledefs of exisitng links & tables
where table is a connected table, create a new connection string including
the password ;database= ...;pwd=....

seems to work OK and the data is available - but not the relationships (not
visible at least in the relationships window).

The FE is not password protected.
 
seems to work OK and the data is available - but not the relationships
(not visible at least in the relationships window).

The FE is not password protected.
Click to expand...


The relationships should show in the front end. However, it really not
necessary much, since all relational settings need to be done in the back
end...the front end has NOTHING to do with this issue.

(for example, what would happen if you had two different front ends with
different relational settings for the back end tables....which one would
take precedence? how could this work if you don't even launch one of the
*different* front ends with different relational settings?

All relationship settings are ALWAYS set in the actual file where the data
is...in this case, the back end....(front end settings are ignored...and
completely irrelevant).

You *should* be able to display the relations in the front end..but, the
existence of a password has ABSOLUTE NO change in the behaves..or what your
see in the front end...
 
Back
Top