Comments by Liefie2000

Liefie2000 15-May-14 14:29pm View

It says I don't have rights to addlinkedserver.

Liefie2000 14-May-14 12:23pm View

Not real sure how to set that up in my query. Can you give me an example?

Liefie2000 13-May-14 16:55pm View

Yes

Liefie2000 13-May-14 16:31pm View

Our Server administrator says that we have Jet version 4.0.9755.0 on our server.

Liefie2000 13-May-14 16:02pm View

I will talk to my Server guy.

Liefie2000 13-May-14 15:57pm View

I added that script above my SELECT and I still get the same error.

Liefie2000 13-May-14 15:43pm View

But I use the same 'Microsoft.Jet.OLEDB.4.0' when connecting to a Access table in my ASP.NET program just fine.

Liefie2000 13-May-14 15:37pm View

I get the same thing.

Liefie2000 13-May-14 15:30pm View

I tried:
DECLARE @DT DATE = GETDATE()
SELECT * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Location of .mdb';'admin';'password', NameOfTable)
WHERE REVOKE_DT <= @DT AND MEDIA_STATUS='PENDREVO'
And I get the same error.

Liefie2000 13-May-14 15:25pm View

No I have not tried a SELECT yet.

Liefie2000 13-May-14 15:23pm View

No. All I'm doing is creating a stored proceedure in SQL Server that will run on a daily basis. This stored proceedure will connect to an Access database and table and update the status of a device from PendRevo to Revo once the date RevoDate on the Access table has been met.

Liefie2000 13-May-14 15:06pm View

It's a 32bit machine.

Liefie2000 2-May-14 10:50am View

So how do you add the login creditials to the config file for this to work?

Comments by Liefie2000 (Top 13 by date)