July 12, 2012 at 11:50 am
There are about 10 users need to connect to SQL database using Access.
How to run a script to do it? (user account: sqluser, password:user123)
After running, user can connect SQL using "Get external data" from Access.
July 12, 2012 at 12:14 pm
Your question is very unclear. You have 10 users that want to connect to SQL Server from Access? Do they all need a different username/password? If you can explain clearly what it is you are trying to accomplish we can help you with a solution.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 12, 2012 at 12:18 pm
All users use the same account and password.
user account: sqluser,
password:user123
July 12, 2012 at 12:24 pm
OK so you have a single sql account. How do you want them to connect? My crystal ball is out for repair at the moment so you are going to have to explain what it is you are looking for.
Machine DSN maybe?
Are you trying to create a Link table in Access?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 12, 2012 at 12:35 pm
Machine DSN
Link table in Access
SQL name: Order
Database: OrderYear
July 12, 2012 at 12:42 pm
I wouldn't even bother trying to script this for 10 machines. It would take longer to figure out the scripts then it will to just set them up.
Honestly I wouldn't even know where to begin scripting this. You have two components to deal with. The first is setting up the DSN and the second is setting up the link table in Access. You would to write a .bat to setup the DSN and an application to open Access using VBA and establish the link table. That would take me at least a day to figure out.
I would just go to each machine and create a DSN. Then open the Access file and Get External Data, pick the table(s), view(s) etc and click ok. Should take all of about 2-3 minutes per machine. Including walking time / remote access time plus bathroom breaks this is less than an hour total.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply