http://www.utteraccess.com/forum/Beginning-Sql-Server-Deve-t1732935.html

It is lengthy, but it covers the subject well. This should cover 95% of how to make it work the most efficient way.

Access 2007 has some great advantages...

Thank you! I changed it to FinderFile20 at each location.

This is the error received. Was the non standard port number needed?

OLE DB provider "ORAOLEDB.Oracle" for linked server "FinderFile20" returned message...

My Access apps use DSNLess connections using SQL Native Client 10.0 that are code / table driven. So, users don't have the exposure of using ODBC. The Access Application...

Really appreciate the article, hope SQL Server Central will consider many more articles like this one.

Could SQL Server Central please create a major category for SQL / Excel with the...

Sorry about the cross up in terms. In Access code, we can Execute a query (of a SQL View).

I figured it out with some trial and error, heavily weighted on...

http://support.microsoft.com/kb/2513216

Got to love Microsoft SQL Server Support

After dozens of people asking how to solve this - Microsoft referenced this article.

It sure shows the problem. But,...

Image of what the discussion is about.

Steps to limit a user to choose only the Views they have permission for:

1. In Databases, Security, Logins - New Logins

Login Name: GISviewer (password)...

1. In Databases, Security, Logins - New Logins

Login Name: GISviewer (password) turn off password enforce policy

Default DB - RegDB User Mapping - RegDB

2. run tsql on the view GISWell ...

On the MS Access UK site, another suggestion was this.

It provided the exact same results as my solution above.

Did not see any difference in the time for 100,000 records.

It uses...

Slugged through it and came up with this.

SELECT ID_Wells, Req_Fin_Priority AS MinPriority, ID_SHLBHL, Req_Fin, SHLBHL

FROM dbo.Sub_1

WHERE ...

Solved: Just wanted to followup

In SQL Server Management Studio - right click on the Wells_Sundry_Description - choose Object Dependencies

This exposed a table that did indeed contain a FK to the...

Hired as a QA Manager for a VB 4.0 system with 28 developers / testers.

Found out quickly that it was necessary to learn MS Access right away. It turns...

Searched for a solution Monday. My post is all over the other web sites, with out an answer.

Here is my solution that works. Would not mind someone telling me there...

Got everything working and tested, reset schedule for tonight.

My script owner is sa. Tried to change the script from saving to path "C:\Backup\" (this works perfectlly)

to a...

Thanks again, I got sidetracked with the SQL Server Agent failing to start and displaying many errors.

While my DBA contact was out for training, another IT person changed the virtual...