Where to find sample access DBs using odbc

[surfside1]

Does anyone know of where I can find a sample DB that using odbc to access a sql server .mdf file?
Thanks!

 

[dhookom]

You generally create ODBC datasources on local machines to access data on your network. Any MDB that I could provide to you would link to database servers that you could never connect to from outside of our network.

If you have a SQL Database that you want to connect to from Access, walk through the creation of a DSN. You can then connect to it from Access.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[marks416]

Hi,

May I use ODBC directly to connect SQL server without local DSN setting.

I can not set DNS because I do not have terminal access to the system but I can access the mdb file through network.

Thanks

M

 

[gwinn7]

You can access directly through an ODBC connection string. Why not use the ODBC Administrator to create a linked table by DSN first, then use that connection string from that connection in your code to build your linked tables directly?

Gary
gwinn7

 

[dhookom]

Doug Steele has a page Using DSN-Less Connections at

http://www.accessmvp.com/djsteele/DSNLessLinks.html

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]