[AccessD] SQL Newbie Questions

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Fri Mar 16 13:44:15 CDT 2007


Charlotte:

When I right click  the icon in the tray and click about it says:

Microsoft SQL Server Service Manager
Version 8.00.2039

Tell you anything?

Rocky





 	
	

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

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
--
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
 




More information about the AccessD mailing list