Davisro
asked on
Connecting Access (365) to Sql Server Express
Gentlemen, we've been discussing moving our departmental Access database to a managed instance of Sql Server where my department would own the tables. I know some query SQL and am learning the language. I downloaded Sql Server Express to my PC at home.
1. Can you point me to a tutorial as to how to connect to my SQL server instance from Access?
2. I want to learn how to use SSMS and continue my path to learning the query language and how to create and manage sql databases. I've always learned from books but today people seem to like online resources. Ive been considering a subscription to Safari so I can just browse many books to find ones i like? What would you suggest? Thanks!
1. Can you point me to a tutorial as to how to connect to my SQL server instance from Access?
2. I want to learn how to use SSMS and continue my path to learning the query language and how to create and manage sql databases. I've always learned from books but today people seem to like online resources. Ive been considering a subscription to Safari so I can just browse many books to find ones i like? What would you suggest? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you gentlemen for the good advice and Happy New Year!
ASKER