System DSN with .mdw workgroup file

Hi there,

Have been developing an intranet site at my work, and have got as far as
getting it all working with a new database - so no problems there.

However, I now need to roll it out to other existing databases that have
security attached to them.

So, for example, a database may be :

i:\gbinfo\access databases\gb roads.mdb

But because of the associated security workgroup file (.mdw), the desktop
shortcut has to point to :

"i:\gbinfo\access databases\gb roads.mdb" /WRKGRP "i:\gbinfo\acess
databases\secured.mdw"

So the problem seems to be how to incorporate this when setting up the
System DSN. Just pointing the DSN to the database file runs into permission
problems. And whatever variation (with or without the "s) of the longer path
I enter in the ODBC MS Access Setup screen is just met with a message saying
"The above file name is invalid".

I hope that this makes sense, and someone here has run into this before and
can point me in the right direction.

The structure of the site is all set up, and should be quite quick to finish
off once I can get these DNS connections set up.

Many thanks,
Iain

.

Relevant Pages

  • Error: #50070: Unable to connect to the database STS_Config
    ... Check the database connection information ... Framework 1.1 and Share Point Portal Services 2.0 the intranet site ... event log everytime when I try to access the http://companyweb ... I have another server with the same setup and it works just fine. ...
    (microsoft.public.windows.server.sbs)
  • Re: located outside intranet or an untrusted site. Can not open due t.
    ... This is outside my area of expertise, but see if these links help: ... You receive an error message when you try to open an Access 2002 database from a Web Server: ... Intranet site is identified as an Internet site when you use an FQDN or an IP address: ...
    (microsoft.public.access.security)
  • Re: show a wait box
    ... You did *not* state that this is an intranet site up front. ... If you need a busy box then your database query is not tuned. ...
    (comp.lang.javascript)
  • Re: Cant open Access database
    ... These links do not relate to opening a database on a local harddrive. ... > Hi Steve, ... > You receive an error message when you try to open an Access ... > Intranet site is identified as an Internet site when you use an ...
    (microsoft.public.access.security)
  • Re: Linking to a database on the server drive
    ... This is outside my area of expertise, but see if these links help: ... You receive an error message when you try to open an Access 2002 database from a Web Server: ... Intranet site is identified as an Internet site when you use an FQDN or an IP address: ...
    (microsoft.public.access.security)
Loading