William,

You've become my avatar in this thread - I thank you for all your efforts.

So, you were able to get a different installation of SQL Server 2005 to read an...

William,

That's nearly the same script I tried, and I'm getting errors too.

EXEC sp_addlinkedserver

@server = N'Data97',

@provider = N'Microsoft.Jet.OLEDB.4.0',

...

Well, that's what I did before (made the C:\MyApps folder readable and writeable by everyone in Explorer), but just to double check, I did it again. Still getting error 7303.

PW,

Calling OpenDataSource() may require that the service account for the SQL instance needs to have access to the folder containing the MDB files. Make the folder accessible to everyone, and...

Ah... I need to make a clarification. I have SQL Server 2005 installed locally for testing purposes. Once I get all the pieces figured out for my eventual stored procedure(s)...

PW:

Well, the owners are listed as me and Administrators. I changed the options for me to "Allow" for all permissions, and then tried the import again. Still no luck...

Matt Miller:

Yes,...

Good question - I've seen FTP mangle some files in the past.

I just checked it out - yeah, I can get into the DB in Access 97 and open the...