RE: System DSN with .mdw workgroup file

Almost there I think.

Sussed out that when adding the DSN in DW, I needed to enter the username of
one of the members of the .mdw file, not a username created in the ODBC
settings.

So at least now the connection is working in DW.

So I tried a quick test page, but its bringing up this error in the browser :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
/roadstest.asp, line 8

where line 8 is :

Recordset1.ActiveConnection = MM_connRoads_STRING

Any ideas?

Iain
.

Relevant Pages

  • Re: Security not clicking
    ... I'm not sure what you mean by 'functioning'. ... the username will be filled in with the last username that used ... Or it's possible that you aren't using the correct mdw file - try one of the ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Security not clicking
    ... I'm not sure what you mean by 'functioning'. ... the username will be filled in with the last username that used ... Or it's possible that you aren't using the correct mdw file - try one of the ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Retrieving Data from Excel by using ASP
    ... Hi Ray I know am making it much harder but be patient with me please. ... Well everything is going ok except when I type the username and password ... Error Type: ...
    (microsoft.public.inetserver.asp.general)
  • Re: Migrating Access app
    ... When you say "database password", do you mean the password that you enter ... together with a username, or the password that you enter on its own (without ... > I have an Access app which is secured (custom mdw file, ... > old file unless I am in the custom mdw file. ...
    (microsoft.public.access.security)
  • Re: Single Db Security
    ... You need to create a separate mdw file. ... > username and password only for a single database. ... > database I want to access will require me to login with a ...
    (microsoft.public.access.security)