[AccessD] SQL Newbie Questions

Charlotte Foust cfoust at infostatsystems.com
Fri Mar 16 12:58:11 CDT 2007


What version of SQL Server are you using?  Enterprise Manager was the
admin tool for SQL Server prior to 2005.  Now you need the SQL Server
Management Studio instead, which also works against the prior version of
SQL Server.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Friday, March 16, 2007 10:52 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Newbie Questions

Mark:

It's a file that resides on my machine.  But I don't know what the
enterprise manager is. To make that link to you set up a new DNS.  And,
if so is it file source or machine source?

TIA

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Friday, March 16, 2007 10:43 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL Newbie Questions

Rocky,

I regularly link an Access db to SQL running locally without issues.   
Question:  is the database file you trying to link to, in the list on
enterprise manager?  or is it just a file that resides on your machine?

Thanks,

Mark A. Matte


>From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] SQL Newbie Questions
>Date: Fri, 16 Mar 2007 10:32:37 -0700
>
>More:
>
>I changed the server to \\HAL9005\MSMLBIZ because that's what come up 
>when I hover over the icon in the lower right corner.
>
>Now I get two different errors: 11004 - Connection failed and 6 - 
>Specified SQL Server not found.
>
>I also was using File Data Source.  Tried it with Machine Data Source 
>with the same result.  Which one should I be using?
>
>TIA
>
>Rocky
>
>
>
>
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin

>at Beach Access Software
>Sent: Friday, March 16, 2007 10:21 AM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] SQL Newbie Questions
>
>Eric:
>
>Thanks for the lead.  My wizard failed (or I failed I guess) with two
>errors: Error 2: Connection Failed, and Error 17: SQL Server does not 
>exist or access denied.
>
>I'm running locally.  The SQL server icon is in the lower right corner.
>It's running.
>
>Any ideas what I did wrong?
>
>Thanks and regards,
>
>Rocky
>
>
>
>
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro
>Sent: Thursday, March 15, 2007 10:50 PM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] SQL Newbie Questions
>
>Create a DSN using SQL server driver and then test and see if the 
>connection is able to connect to the database file. It looks like the 
>.db file is the data file and the .lg file is the transaction log file.
>
>You can then use the DSN to link the tables to your Access project or 
>use ADO to query the database.
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin

>at Beach Access Software
>Sent: Thursday, March 15, 2007 10:11 PM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] SQL Newbie Questions
>
>Dear List:
>
>I have a need to interface an Access app to either or both of Microsoft

>Small Business Accounting 2007 and Microsoft Small Business Financials 
>packages.  Their tech support tells me that they both have SQL back
ends.
>
>What I would like to do is push shipping and receiving transactions 
>from the Access app into the accounting package to trigger invoices and

>payables, and extract customer order detail from the accounting system 
>into the Access app.
>
>I have ordered the 60 day trial of SBF with the SDK (which they told me

>is mostly a data dictionary, but that's OK).
>
>I have the SBA 2007 and in a folder there is a file named 
>sampleproductcompany.db which I think they said is the database.
>There's also one named sampleproductcompany.lg.
>
>  Is this a SQL database file?  Can I connect to this SQL back end and 
>if so how?
>
>MMTIA,
>
>Rocky
>
>
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.446 / Virus Database: 268.18.11/722 - Release Date: 
>3/14/2007
>3:38 PM
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 
>3/15/2007
>11:27 AM
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 
>3/15/2007
>11:27 AM
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Its tax season, make sure to follow these few simple tips
http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTi
ps.a
spx?icid=HMMartagline


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date:
3/15/2007
11:27 AM
 
  

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list