oos! I got an "invalid authorization specification" when testing my connection to Access. What's g

microsoft.public.dotnet.framework.adonet

31 May 2006 4:13 AM

Hexman

I've been working on this app for some time now. Been developing with vs 2005 vb.net and an Access database. Something happened and I can't figure
out what caused it or how to correct it.

I drop a OleDBAdapter on the form and the data adapter configuration wizard appears. I then click on "New Connection" to choose an Access db other
than the one being displayed. The "Add Connection" window appears and the data source box shows "Microsoft Access Database File (OLE DB)". Good so
far. I click on browse and select the Access db I want to use. The new file name appears in the database file box. I click on "Test Connection" and
the "invalid authorization specification" error pops up and prohibits me from setting up the new coonection.

There are no passwords on this db.

What did I do to cause this???

Thanks,

Hexman

P.S. In the Provider property is "SQLNCLI.1", which I can't change.