[AccessD] SQL Newbie Questions

Rocky,

sampleproductcompany.db smells like a non-SQL server table.....  

Don't go through creating a DSN, just do a linked table with a dBase or
Paradox driver.


HTH,
 
Liz
 
 
 



Liz  Doering
612.667.2447 

"This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose, or take any action based on
this message or any information herein. If you have received this
message in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation"

 
 

-----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 12:21 PM
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