SSMS Access Database

I have SQL Server Management Studio installed (2008) on Windows 7.  There is no database services installed only SSMS compact edition.  My question is there a way to connect to a Microsoft Access database with this setup?
Thanks for any feedback.
LVL 3
fjkaykr11Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
Hi,
1. You should set up the relevant Sql server Instance on the server.
2. To connect to Access, you can directly use Access interface.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
SSMS is a tool for administering SQL Server databases.
For MS Access you should use MS Access.

You can even use SSMS to create a linked server to a MS Access database but that only allows you to work with tables and not with forms, reports or code.
0
fjkaykr11Author Commented:
thanks for the reply. I don't have the ability to setup any SQL Server instance in my environment, just curious.  @Vitor, with my current setup how would I be able to create a linked server to an MS Access database? I don't need to work with forms, reports or code.
0
Anthony PerkinsCommented:
@Vitor, with my current setup how would I be able to create a linked server to an MS Access database?
I am afraid you cannot do that.  You can only use SSMS if you have a SQL Server you can connect to.  You cannot create a linked server using SSMS alone.  The key word is "linked", in other words if you do not have a SQL Server you cannot link to anything.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fjkaykr11Author Commented:
thanks for verifying, I thought that was the case - just wanted to make sure in case there was another way.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.