OK...I admit it...I need help

  • Thread starter Thread starter Kevin3NF
  • Start date Start date
K

Kevin3NF

I've been putting together Access databases for 10 years. SQL Server since 1999.

So far, I've NEVER needed to use anything other than linked tables to get to my data.

That said....:-)

I have an Access FE, Access BE, and a SQL Server that has one table I need to link to. But...the SQL Server is at a web host. I can set up a System DSN and make a connection via IP address with the correct username and password. But, when I restart the db and access that table via the form, I am prompted for the username and password again. Using a trusted connection is out, as the user's Windows account is obviously not authorized at the ISP.

So...I need some way to create that connection without the user seeing it, and have it persist the entire time the database is open.

I've read various posts in the past that made mention of loading a form when the database is opened and having it connect to a one record table in the background, but I have no earthly idea how to do that.

Is that a legitimate method, or is there something better/easier that I am just not thinking of? This needs to be simple enough to explain to my friend, and then for him to explain to his client.

All resposes welcomed and appreciated. If you feel like emailing as well as posting back to the NG, that would be cool. My email address is easily enough determined from what I posted with.

Thanks!

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
I never tried to directly connection a DB hosted on the NET. Just wild guess:

You said you connect to the SQL Server via system DSN with user name and password supplied. So, username and password is for SQL Server login. Is it possible that the username and password asked, when your app tries to access the network where web host locates, is the username and password for network access? Usually, if you have private access to somewhere on the net, you are subject to certain authentication, it is hardly the case that you don't need login credential to access other network other than Internet anonymous access. Ask your ISP to verify.

I've been putting together Access databases for 10 years. SQL Server since 1999.

So far, I've NEVER needed to use anything other than linked tables to get to my data.

That said....:-)

I have an Access FE, Access BE, and a SQL Server that has one table I need to link to. But...the SQL Server is at a web host. I can set up a System DSN and make a connection via IP address with the correct username and password. But, when I restart the db and access that table via the form, I am prompted for the username and password again. Using a trusted connection is out, as the user's Windows account is obviously not authorized at the ISP.

So...I need some way to create that connection without the user seeing it, and have it persist the entire time the database is open.

I've read various posts in the past that made mention of loading a form when the database is opened and having it connect to a one record table in the background, but I have no earthly idea how to do that.

Is that a legitimate method, or is there something better/easier that I am just not thinking of? This needs to be simple enough to explain to my friend, and then for him to explain to his client.

All resposes welcomed and appreciated. If you feel like emailing as well as posting back to the NG, that would be cool. My email address is easily enough determined from what I posted with.

Thanks!

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Yes, the username and password I have is certainly a SQL Server login. What I am trying to avoid is the user having to know and type in the password when the one table is accessed. All the other tables are in an Access BE on the local LAN, so they are not an issue.

If the SQL Server were local, this would be a piece of cake.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

I never tried to directly connection a DB hosted on the NET. Just wild guess:

You said you connect to the SQL Server via system DSN with user name and password supplied. So, username and password is for SQL Server login. Is it possible that the username and password asked, when your app tries to access the network where web host locates, is the username and password for network access? Usually, if you have private access to somewhere on the net, you are subject to certain authentication, it is hardly the case that you don't need login credential to access other network other than Internet anonymous access. Ask your ISP to verify.

I've been putting together Access databases for 10 years. SQL Server since 1999.

So far, I've NEVER needed to use anything other than linked tables to get to my data.

That said....:-)

I have an Access FE, Access BE, and a SQL Server that has one table I need to link to. But...the SQL Server is at a web host. I can set up a System DSN and make a connection via IP address with the correct username and password. But, when I restart the db and access that table via the form, I am prompted for the username and password again. Using a trusted connection is out, as the user's Windows account is obviously not authorized at the ISP.

So...I need some way to create that connection without the user seeing it, and have it persist the entire time the database is open.

I've read various posts in the past that made mention of loading a form when the database is opened and having it connect to a one record table in the background, but I have no earthly idea how to do that.

Is that a legitimate method, or is there something better/easier that I am just not thinking of? This needs to be simple enough to explain to my friend, and then for him to explain to his client.

All resposes welcomed and appreciated. If you feel like emailing as well as posting back to the NG, that would be cool. My email address is easily enough determined from what I posted with.

Thanks!

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Hey Albert...would you come down to Texas and slap me? (I missed the save
password box that I have used so many times). I must be tired...:-)

Great link though, and I will be trying that as well.



--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Back
Top