Question about Microsoft SQL Server Standard Edition for PC

3 Answers

Viewing ms Sql Server database on Access

Hi I have recently started experimenting queries in Access and I have learned a lot of useful functions that improved my sql abilities. I have an MS Sql Server at work and I have heard that you can make queries using Access, which will make my life a lot easier. Does anyone have information on how to do that?

Posted by on

3 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has answered 200 questions.


    An expert whose answer got voted for 20 times.

  • Microsoft Expert
  • 401 Answers
Re: Viewing ms Sql Server database on Access

Work with sql databases with the help of fix .mdf


Posted on Sep 22, 2013

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert who has answered 200 questions.

  • Expert
  • 244 Answers
Re: Viewing ms Sql Server database on Access

Access has each own queries wizard enable you to make your own sql statement. for example:
Your table name is Customer

Customer table contains the ff fields:
1.) First Name
2.) Last Name

at the Queries statement: SELECT * FROM Customer
Meaning * stand for fields while Customer stand for table

Try to visit very resourceful website for the beginner's

Hope you will make my solution's helpful for you.

Best regards,


Posted on Nov 02, 2007

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that has over 10 points.


    An expert whose answer got voted for 2 times.

  • Contributor
  • 26 Answers
Re: Viewing ms Sql Server database on Access

Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Posted on Aug 23, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

3 Answers

Repair database without being attached SQL 2005

Use SQL Server Repair Kit. A convenient, reliable and ultimately efficient MS SQL database repair tool for system administrators, developers and database experts. Best in class performance and outstanding usability for users with and without experience.

Read more:

May 13, 2015 | Microsoft SQL Server 2005 Enterprise...

3 Answers

What is SQL?

It is a special purpose programing language. Computer language you will never use, unless you are into servers or programing type software

Jan 27, 2015 | Oracle 10g Database Standard (ODBSEONUPP0)

3 Answers

Is it good idea to repair sql file?

Bulk Logged will not help you in this situation. Your transaction log is growing because you are performing large transactions. In simple mode, the log is truncated after a checkpoint.
Check these site: & download demo Recovery Toolbox for SQL Server.
Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.
Read more:

Nov 06, 2014 | Microsoft SQL Server 2005 Standard Edition

8 Answers

How can i fix the problem by error message 262,level 14,state 1,line 1 CREATE DATABASE permission denied in database 'master' in sql server 2005

RecoveryFix for SQL server database recovery utility is a very powerful utilty to fastly short out your all problems to MS SQL database. By using this application, user can simply repair SQL database. Read more:
For more information read this post:

Jun 22, 2010 | Microsoft SQL Server 2005 Enterprise...

1 Answer

SQL Server 2000

An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.

1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.

If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)

That should move your stored procedures and user defined functions over.

You can use a similar process to move tables, views, users, and other objects over as well.

Jan 17, 2008 | Business & Productivity Software

2 Answers

What is a .sdf file? How to generate a .sdf file using ms access?

Regarding what is .SDF -- A file format that is compliant with the combination of SQL Server 2005 Compact Edition, SQL Server 2005 and Visual Studio 2005 to build, test, deploy, and manage applications for users. Databases of this type can be accessed directly as a datasource, e.g., from Visual Studio 2005, or from SQL Server Management Studio. As such, they can be passed around with programs or projects, although they are mainly used for embedded applications. The file includes all necessary code points to access the data, and so does not require an instance of SQL Server to be installed.

You can create a .SDF file with a software called PocketSYNC. (Although i have never tried it myself, a lot of people claim that this software works like charm. But it is not free)

Oct 17, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

SQL server won't work on my laptop

Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.

SQL Server runs on port 1433, so any firewall has to have it open.

Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.

Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.

Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.

Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...

4 Answers

Running SQL queries on Excel

Another way to do it is to use the SQL Drill freeware Excel addin (

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

Related Topics:

259 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides