connection to access file fails

  • Thread starter Thread starter fanor
  • Start date Start date
F

fanor

Hi guys,

I added to a form an oldbconnection to connect to an Access file (access
2000), using the wizard I select the MDB file but when i test it i got an
error "Invalid authorization specification".
The user name is the default Admin, and no password.
What am I missing??
the data source is "Microsoft Access Database File (OLE DB)"

TIA
 
¤ Hi guys,
¤
¤ I added to a form an oldbconnection to connect to an Access file (access
¤ 2000), using the wizard I select the MDB file but when i test it i got an
¤ error "Invalid authorization specification".
¤ The user name is the default Admin, and no password.
¤ What am I missing??
¤ the data source is "Microsoft Access Database File (OLE DB)"

This doesn't look like a Jet/Access error. It looks more like an error from the SQL Server provider.

When using the wizard did you select the correct Data Source on the Add Connection dialog. It
defaults to Microsoft SQL Server Database File. You need to click on the Change button to select
Microsoft Access Database file.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top