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