January 21, 2003 at 1:58 pm
I like to link MSAccess97 database through SQL Server 2000. MSAccess97 database is password protected, means that workgroup file is already attached there.
My problem is when I setup the path in SQL Server 2000 Datasource, I setup only the location of the mdb file not the workgroup file. I don't know how to attached workgroup file with the database so that I link Access97 database through SQL Server 2000.
Appreciated if you could help me.
January 21, 2003 at 2:47 pm
Check KB 246255.
http://support.microsoft.com/default.aspx?scid=kb;en-us;246255
January 23, 2003 at 2:11 pm
I tried according to the article and getting follwing message.
Error 7399 OLE DB PROVIDER 'Microsoft.jet.OLEDB.4.0 reported an error
Thanks for your help.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply