RefreshLink error - 3078

Hi,

I'm in the process of converting an Access 97 backend to SQL Server 2005;
I've tried the SSMA for Access with no avail. So, now I've gone through the
painstaking of hand converting the table structure, constraints, keys, etc;
and even got the data over into SQL using a complex SSIS package.

Now, I'm ready to link the backend data. For now, I'm trying the simplest
approach just to get a working copy..so I'll be using a DSN. I've read about
DSN-less and will try it out in future testing sessions.

I've created the DSN and started the linking process and get an error stating:
"Error: 3011 - The Microsoft Jet database engine could not find the
object 'MyTableName'. Make sure the object exists and that you spell its name
and the path name correctly....See Chapter 10 - Troubleshooting, Item 4 for
assistance."

For arguments sake I also upgraded the project to Access 2000 and got
essentially the same error message; just with error # 3078 instead.

I've checked the DSN connection and got successful connection test. I've
double checked the table names in Access file (originally named
dbo_MyTableName...but, I renamed to MyTableName).

I've read countless articles and newsgroups, browsed forums and MS support,
all of which have not once addressed this.

I'm not sure if there is something I am just not seeing or what? I've been
working on this for about a week now (the whole project for about 5 months).

Anyone have any ideas? I'd appreciate any help that you can give me or point
me to! Please help!

Thanks,
James R.
--
Knowledge is the first step towards success. Little knowledge creates big
ideas.
.

Relevant Pages

  • Re: Accessing an access database regionally
    ... for now I want to stay away from converting the backend to SQL server. ... You use Terminal server a lot and it works fine? ...
    (microsoft.public.access.setupconfig)
  • Re: Migrating away from MS-Access
    ... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... A dot-net front end with an MDB file back end is the worst of all worlds. ...
    (comp.databases.ms-access)
  • Re: Replication Suggestions
    ... Looking for a SQL Server replication book? ... >I have an application with a sql backend. ... > database on the webbox and an internal database for inter-company use. ...
    (microsoft.public.sqlserver.replication)
  • Re: Best Practices for Data Access
    ... This approach also means you would have N backup strategies, N management strategies, N sets of stored procedures that cannot leverage the features of the backend--assuming the backend even supported SPs. ... While Oracle and SQL Server both support SPs, ... I need to design an smart client application that can run on mulitple and plugable backend like MS SQL, Oracle or MySQL. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VB6 SQL Server
    ... >Our main problem, besides database size, is the SLOW process of inserting ... I don't see that converting to SQL Server would fix that. ... Check to see if your DAO is use fast, ...
    (microsoft.public.vb.database)