[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

_________________________________________________________________
It’s tax season, make sure to follow these few simple tips 
http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.aspx?icid=HMMartagline