Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Mar 16 12:51:56 CDT 2007
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/PreparationTips.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