encrypting connection string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating some pages in Access for reporting purposes. I am using Access
to connect to a SQL database on another server. My problem is when I create
pages and post them to my website the view source shows a connection string
with ID and Password information as well as IP address of the server. Is
there any way to encrpt the connection string information inside of access
before creating the htm page.
 
Hi, Andy.
Is
there any way to encrpt the connection string information inside of access
before creating the htm page.
Click to expand...

Sorry. No. If you need to secure the data, don't use Access, even as the
middleman to SQL Server or any other client/server database -- unless the
user provides the information needed to authenticate and connect: user ID,
password, database name, path, driver, et cetera (to build the connection
string dynamically on the client side) _and_ this information is encrypted
when it's sent to the database server. Otherwise, you'll just give hackers a
written invitation to come see your data -- with the map of how to get there.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top