Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-01-2019, 11:56 AM   #1
amir0914
Newly Registered User
 
Join Date: May 2018
Posts: 43
Thanks: 49
Thanked 0 Times in 0 Posts
amir0914 is on a distinguished road
Access app with sql server databse

hello everyone, I'm have been working with access for 5 years and I have written many programs with vba & sql commands in access, and now I need to create database by sql server in my new program and I have to connect access form with sql server database, but I have never worked with sql server programs, and I also don't know which version of sql server I should to install, and I don't know how to use and connect it to my access forms, I'm also very interested in learning sql server. can someone give me some information,tutorial, or sample file about that?

Thanks in advanced.

amir0914 is offline   Reply With Quote
Old 12-01-2019, 12:28 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,505
Thanks: 58
Thanked 1,422 Times in 1,403 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Access app with sql server databse

Hi. Getting a sample file may be difficult because you'll need to have a SQL Server to connect it to. If you're just starting out or your project is not too big, you might be able to use SQL Server Express for now. Good thing about it is it's free.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-01-2019, 12:38 PM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,272
Thanks: 115
Thanked 3,083 Times in 2,801 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Access app with sql server databse

First obtain a free copy of SQL Server Express. There are several versions. Recommend you get the SS Management Studio.
You can also download a sample sql server database called Adventure Works. Its the SS equivalent of Northwind in that its designed to show you many things that SS databases can do.

To connect Access to SS, you need to setup a file DSN (using the ODBC wizard) or DSN less connection then link the tables as you would link any Access database tables

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question URL for access databse sugar free General 0 10-21-2009 10:46 PM
connecting other Databse using access yogeshap Theory and practice of database design 1 05-26-2009 05:30 AM
oracle to access databse ranjansh Tables 1 06-22-2007 01:57 AM
how to creat databse for services in access Gjimi Forms 1 08-09-2004 02:51 AM
Opening a databse outside of Access Knight General 1 08-21-2002 06:45 AM




All times are GMT -8. The time now is 02:50 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World