Connect Access to MS-Small business accounting - need further help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

http://office.microsoft.com/en-us/help/HP011737241033.aspx
-- The above link is a direct quote from the help section on linking MS-SBA
to Access. I understand how to do the ODBC thing, but I am lost on how to
recognize the data source (which I assume is a data file from MS-SBA.) See
below - this is step six:

In the Select Data Source dialog box, do one of the following:

* Select an existing DSN data source. The DSN you select must point to
the Microsoft SQL Server 2005 Express Edition instance and the appropriate
Company database.
* In the DSN name box, type a name for the data source, and then click
New. In the Create New Data Source dialog box, select a driver for which you
want to set up a data source, and then click Next.

How do I know what driver to use?

Thanks, Saragrace

Onward through the Fog!
 
Okay, I know which driver to use, but it keeps asking me for network
authentication when I am just connecting to same (local) computer. It has a
name in the userid space, but as far as I know we never set up any password.

Thanks

Sg
 
oh wait a second.

Microsoft Small Business Accounting uses SQL Server?

Why woudln't they use MDB?
 
--
Onward through the Fog!


Sg said:
Okay, I know which driver to use, but it keeps asking me for network
authentication when I am just connecting to same (local) computer. It has a
name in the userid space, but as far as I know we never set up any password.

Thanks

Sg
Click to expand...
 
Got me!? Who knows why they do anything they do. I finally got it to work.
It has Every, and I mean Every table MS-SBA has in it. What a pain in the
pooper. I've gone back to QB. It is horrible, but this isn't much better
from a reporting stand point.
 
Back
Top