Re: Access & DLL


I'm sorry, maybe I didn't explain correctly. Let's say for example, I have an access project file. In a function that's called in autoexec macro, I check the ip address of the pc running the app. Depending on the ip address, I have code that connects the adp to the correct sql server.

The code needed to connect to the appropriate server has to contain the server's ip, user and password.

I'm trying to find a way to hide that sensitive info. Anyone that logs into the database could look in the module and see it.



"Sylvain Lafontaine" <sylvainlafontaine2009@xxxxxxxx> wrote in message news:%23q6aRgb%23JHA.5064@xxxxxxxxxxxxxxxxxxxxxxx
Whenever possible, your best option would be to use Integrated Security. This way, the passwords are not even travelling the wire.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server (French)


"Scott" <sbailey@xxxxxxxxxxxxxxx> wrote in message news:u2mGLQZ%23JHA.3768@xxxxxxxxxxxxxxxxxxxxxxx
I have several access databases with code that contain user names and passwords to sql servers. I was just looking for some advice on my options to protect the sensitive data.

Would it be a decent plan to create a dll and have the username/password sensitive data inside the dll and have access get the user/password info from the dll?

I'm not that into .Net, but do own visual studio 2008. I realize this is an access forum, but I was wondering if you can create something simple like a dll with a little sentive data as described using regular vb script with VS or does VS force a programmer to use only .Net code?

Any guidance would be appreciated.





.

Relevant Pages

  • Re: Access & DLL
    ... the passwords are not even travelling the wire. ... Sylvain Lafontaine, ing. ... Would it be a decent plan to create a dll and have the username/password ... sensitive data inside the dll and have access get the user/password info ...
    (microsoft.public.access.formscoding)
  • Re: Access & DLL
    ... Sylvain Lafontaine, ing. ... Independent consultant and remote programming for Access and SQL-Server ... Would it be a decent plan to create a dll and have the username/password ... sensitive data inside the dll and have access get the user/password info ...
    (microsoft.public.access.formscoding)
  • Re: Access & DLL
    ... Sylvain answered your question. ... the passwords are not even travelling the wire. ... Would it be a decent plan to create a dll and have the username/password ... sensitive data inside the dll and have access get the user/password info ...
    (microsoft.public.access.formscoding)
  • RE: Passwords
    ... You are right that in NT 4.0 the dll FPNWCLNT is in default included in the ... > I think that Novell ... > into the notification packages portion of the ... > Subject: Passwords ...
    (Focus-Microsoft)
  • Re: Access & DLL
    ... Sylvain Lafontaine, ing. ... Independent consultant and remote programming for Access and SQL-Server ... Would it be a decent plan to create a dll and have the ...
    (microsoft.public.access.formscoding)
Loading