MSysconf

[Guest]

We are using a Postgres database, which we front end with Access. The
Postgres logs report that Access can not find the MSysconf table, which is ok
since I have not built it yet. While I have found information on the MS
web site as to how to build that table, and what to put in it, the
instructions do not say exactly where the table should be built. Can
anyone post someplace an example, or perhaps a screen shot showing the
placement of the table within a Postgres database? Thank you!

 

[storrboy]

We are using a Postgres database, which we front end with Access. The
Postgres logs report that Access can not find the MSysconf table, which is ok
since I have not built it yet. While I have found information on the MS
web site as to how to build that table, and what to put in it, the
instructions do not say exactly where the table should be built. Can
anyone post someplace an example, or perhaps a screen shot showing the
placement of the table within a Postgres database? Thank you!

An excerpt from an archived article relating to A97. Not sure how much
it applies to newer versions, or your case in particular.

"If your external data is particularly sensitive, you may not want
users to be able to save their passwords. To change this behavior, you
must create the MSysConf table in your external database to prohibit
local storage of logon IDs and passwords. ODBC will automatically
prompt users for any missing authentication information when they
attempt to open the external database."

Link to article
http://msdn.microsoft.com/archive/d...e97/html/establishingaccesstoexternaldata.asp

 

[storrboy]

On Mar 2, 11:49 pm, Frank Brown <[email protected]>
wrote:

After hitting the send button, I realized you were asking where in the
database to put it. Sorry, my reply may be worth anything.

 

[Tony Toews [MVP]]

After hitting the send button, I realized you were asking where in the
database to put it. Sorry, my reply may be worth anything.

Actually that was quite interesting. I never knew about that table.
Thanks for posting.

That's two things I've learned about Access this year.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[storrboy]

Actually that was quite interesting. I never knew about that table.
Thanks for posting.

That's two things I've learned about Access this year.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm

Been a long time since I read into that one. Wish I could find my
notes on it's structure and stuff.