You are on the right path -- to the point on initial login Jet might try
to login to server database with its username and password (Admin and
blank or whatever you are using with Access) unless you change this
behavior. The trick is to manage the registry key called JetTryAuth (on
the Access client machines).
You can use regedit to get to your version of Jet (3.5 or 4.0)
HKEY_LOCAL_MACHINE\Sofware\Microsoft\Jet\4.0\Engines\ODBC
If you find JetTryAuth as 1, modify it to be 0.
If you have multiple machines to set, you may want to use an INF file,
or set it in an install.
Using the MySysConf as a table on the server database is a completely
optional performance tuning thing.
Michelle Murrain wrote:
>
> On Mon, 2003-10-20 at 15:39, Mike Mascari wrote:
> > Access is first trying to connect using the Access user id whose
> > default is Admin.
>
> Is there a way to turn this behavior off?
>
> > Access can be optimized a bit if you create a table on the server
> > called MSysConf. It is attempting to determine your server settings:
> >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/achowmsysconftableattachedsqldatabasess.asp
>
> It looks like it might include some useful tweaks, but...
>
> Any advice on using this table - is it worth it? Does it create any
> problems I should be aware of? Do you use it?
>
> Thanks!
> --
> .Michelle
> ---------------------------
> Michelle Murrain
> mmurrain@dbdes.com
> Database Designs Associates, Inc.
> Boston 617.889.0929
> Amherst 413.253.2874
> Cell 413.222.6350
> www.dbdes.com
>
> AIM:pearlbear0 ICQ:129250575
>
> "Our capacity to make peace with another person and with the world
> depends very much on our capacity to make peace with ourselves." -- Thich Nhat Hanh
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org