Why not just do what you need to with MS SQLServer?
Create the table MSysConf
*** this is mssql code so you will need to tweak it. ***
CREATE TABLE [dbo].[MSysConf] (
[Config] [smallint] NOT NULL ,
[chValue] [varchar] (255) NULL ,
[nValue] [int] NULL ,
[Comments] [varchar] (255) NULL
) ON [PRIMARY]
and then add the data entries that magically seem to make Access behave;
101 NULL 1 NULL
102 NULL 2 NULL
103 NULL 1000 NULL
I have not attempted this in sapdb (and it may very well not work) but this
would be the first thing I would try if I wanted to do what you are
attempting.
Let me know how it goes.
-----Original Message-----
From: Chad Seidel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 12:15 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: AW: How do I write my connection string to avoid ODBC
connection
Peter,
I think I'm trying to accomplish the same thing you describe. Basically, I
just want my Access DB to remember the MaxDB ODBC login user/pw so
non-Access proficient users don't get annoyed every time they open the
database to review data. Is there a simple setting within the MaxDB ODBC
driver that can remember the login info? I also think your login form idea
is pretty good. Would you mind sharing the details with that (VBA code
specifically for making the database connection and looping through the
tables)?
Thanks,
Chad
