I have a microsoft access Database that I upsized to SQL server 2005 now all of the tables in the access front end are linked tables through ODBC. When the user opens up a form thats connected to one of these linked tables, it promps the user for the SQL Server password, What I would like to do is, make it so that the user never has to enter the password. I would like the password to be entered in the background when the database loads. How can I do that I need as much detail as possible.
Ms Access to SQL server Through ODBC
Hot Topic
- Assign an array to .values and .Xvalues in an excel chart
- Exporting variables
- Creating an Array of Labels
- If... GoTo
- How Do I Set RecordSource in VBA to a Predefined Query?
- Macro to Delete Rows
- Sum of hours using select statement & VBA
- Password protecting to a command button in Excel?
- ms access
- Searching a directory for last two day's documents, return partial filename to bookmarks
Microsoft ISV
- personalized command bar disappears when minimizing excel
- Adding data to the same workbook
- VBA Userform Control of multiple userform controls
- creating hyperlink through vba
- Can you tell me why Int(1.4 * 100) = 139
- Office 2003 and 2007 Primary Interop Assemblies (PIAs)
- MS Access & Windows Media Player
- How to execute MS Query inside Excel VBA?
- LCS complience with IMS / SIP standards ?
- Count and display in cell
Ms Access to SQL server Through ODBC