.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
SQLServer Database in access?
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-oledb' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Gavan Brown
-- Moved from [aspngdata] to [ngfx-oledb] by Marcie Jones <Click here to reveal e-mail address> --

Is it possible to open a SQL Server database in Microsoft Access? I find the
design tools are far superior to those of SQL Server... Anyone know how to
do this?

THANX!

Gavan Brown
Reply to this message...
 
    
Marcie Jones (VIP)
It is very easy to *link* to SQL Server tables in Access, is this what =
you're referring to?

Marcie

----- Original Message -----
From: "Gavan Brown" <Click here to reveal e-mail address>
To: Click here to reveal e-mail address
Sent: Tue, 12 Mar 2002 11:19:39 -0700
Subject: SQLServer Database in access?

-- Moved from [aspngdata] to [ngfx-oledb] by Marcie Jones =
<Click here to reveal e-mail address> --

Is it possible to open a SQL Server database in Microsoft Access? I find =
the
design tools are far superior to those of SQL Server... Anyone know how =
to
do this?

THANX!

Gavan Brown
Reply to this message...
 
    
Gavan Brown
Actually all i want to do in access is create and manage the relationships
of the database... thats all. I hate the SQL server GUI for data diagrams.
It is WRETCHED. Are you able to edit relationships of a SQL server database
in access?
Gavan

----- Original Message -----
From: "Marcie Jones" <Click here to reveal e-mail address>
To: "ngfx-oledb" <Click here to reveal e-mail address>
Sent: Tuesday, March 12, 2002 3:17 PM
Subject: [ngfx-oledb] Re: SQLServer Database in access?

It is very easy to *link* to SQL Server tables in Access, is this what
you're referring to?

Marcie

----- Original Message -----
From: "Gavan Brown" <Click here to reveal e-mail address>
To: Click here to reveal e-mail address
Sent: Tue, 12 Mar 2002 11:19:39 -0700
Subject: SQLServer Database in access?

-- Moved from [aspngdata] to [ngfx-oledb] by Marcie Jones
<Click here to reveal e-mail address> --

Is it possible to open a SQL Server database in Microsoft Access? I find the
design tools are far superior to those of SQL Server... Anyone know how to
do this?

THANX!

Gavan Brown

| [ngfx-oledb] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-oledb.asp = JOIN/QUIT
Reply to this message...
 
    
Marcie Jones (VIP)
I'm fairly sure that you cannot. Sorry :(

If you don't like the GUI, I'm sure you can do
whatever it that you're trying to do programmatically
if that's of any consolation to you.

Marcie

--- Gavan Brown <Click here to reveal e-mail address> wrote:
[Original message clipped]

__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
Reply to this message...
 
    
Daniel Reyes
If you have Access2000 or XP you can create a project. This will then
connect to a SQL server database. You can then design stored procedures,
create diagrams etc.

Look for Project (Existing data) under File->New.

-----Original Message-----
From: Gavan Brown [mailto:Click here to reveal e-mail address]
Sent: Wednesday, 13 March 2002 5:20 AM
To: ngfx-oledb
Subject: [ngfx-oledb] SQLServer Database in access?

-- Moved from [aspngdata] to [ngfx-oledb] by Marcie Jones
<Click here to reveal e-mail address> --

Is it possible to open a SQL Server database in Microsoft Access? I find
the
design tools are far superior to those of SQL Server... Anyone know how
to
do this?

THANX!

Gavan Brown

| [ngfx-oledb] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-oledb.asp = JOIN/QUIT
Reply to this message...
 
 




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification