How to create a connection to Access Database

Hi guys,

I want to create a report from Access Database. Can anybody tell me how to connect and create a data source from Access data source. A step by step guide is preferable. I am more concerned on the connection string.

Thanks.

There are two standard data providers that may be used to connect to Access databases:The JET 4.0 .NET OLE DB provider and Access ODBC driver. The former is newer and generally more efficient than the latter.

In the "Connection Properties" dialog,

1) pick "OLE DB" under "Data Source"

2) pick "Microsoft JET 4.0 OLE DB Provider"

3) enter the full path of Access file under "Server or File Name"

4) the connection string would be like

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb"

5) in the "Credentials", use "Admin" as user name and leave password blank

One thing to be aware of is that RS must have the necessary security access to open the Access DB file. Make sure that the account running RS has the privileges to open the Access database file and its containing folder.

HTH,

|||

Thanks buddy, I really appreciate your help.

How to Copy Job

Hi
I have 2 similar instances in sql server 2005
in instance A i have some jobs.
I want them to copy to second instance B
Please guide me step by step.
Muralidaran rHave you tried to Googled (http://www.google.co.uk/search?hl=en&q=copy+jobs+in+sql+server&meta=) this?
There are a handful of articles out there that explain it step by step!|||created script of jobs in instance A

executed in instance b using sql server enterprise management studio.

thanks

muralidaran r