Re: Connecting to SQL from Access
- From: "scott.seely@xxxxxxxxxx" <scott.seely@xxxxxxxxxx>
- Date: 26 Jan 2006 17:55:56 -0800
Access works pretty well. We've used access project files (.adp) to
allow users to query databases. .adp files utilize OLE DB connections.
You can also appropriately permission the login that the Access .adp
uses to access the sql server database. Let me know if you need more
specific guidance, I'd be happy to help out.
.
- References:
- Connecting to SQL from Access
- From: dew
- Connecting to SQL from Access
- Prev by Date: Re: Denial of Service: BINARY_CHECKSUM of TEXT column hangs CPU: SQL 2K SP4
- Next by Date: Re: Connecting to SQL from Access
- Previous by thread: Connecting to SQL from Access
- Next by thread: Re: Connecting to SQL from Access
- Index(es):