• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

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.
0
fjkaykr11
Asked:
fjkaykr11
3 Solutions
 
HuaMin ChenSystem AnalystCommented:
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
 
fjkaykr11Author Commented:
thanks for verifying, I thought that was the case - just wanted to make sure in case there was another way.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now