[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

Sql code from acess


How do I run and sql script from access?
0
robrodp
Asked:
robrodp
  • 3
  • 2
1 Solution
 
nmcdermaidCommented:
You use a 'pass through query' type in Microsoft Access. It passes the SQL directly to SQL Server (or whatever database server you're using)
0
 
robrodpAuthor Commented:
My question is, when I open a database in the access environment.... I know some clicks take ther I just do not remember which
0
 
nmcdermaidCommented:
hmmm can you rephrase that question?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
robrodpAuthor Commented:
I open the XP access application.

I open a database

I want to make sql statements from the environment
0
 
nmcdermaidCommented:
You want to design SQL Queries in Access XP?

-Go to the Queries Tab
-Double Click 'Create Query In Design View'
-Once you've made your query you Press View then SQL View to view it as SQL

The MS Access Query builders are not recommended for developing queries. You're better off using Query Analyzer and Enterprise Manager.

0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Best way to do what you are asking is to create an adp (access project) connectoing to a specific sql server database.  You can then directly create views and stored procedures with the look and feel of traditional Access queries.  Hope this helped....

Racimo
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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