Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Other Forums
 MS Access
 Using Upsizing Wizard with MS Access 2003
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

83 Posts

Posted - 03/12/2013 :  11:51:34  Show Profile  Reply with Quote

I am using the Upsizing Wizard to convert an MS Access 2003 Database to an SQL Server 2005 Database. The current Access DB has a Front-End (FE) and a Back-End (BE). The FE currently has linked tables to the BE. I am not touching the FE, but using the Upsizing Wizard to convert the BE DB to an SQL Server 2005 DB. The goal is to have the FE still write to the BE, which will then update the SQL Server DB as well.

I am exporting a single table at a time until I figure this out. The Upsizing process completes fine. But, when I launch the FE I receive the following error:

Run-time error '3078'

The Microsoft Jef database engine cannot find the input table or query 'maintenance'. Make sure it exists and that its name is spelled correctly.

I have several questions:
1. With the FE and SQL Server DB, will we still need BE DB at all?
2. Once the BE is upsized to SQL Server, do we need to relink the FE to SQL Server and forget about the BE all together?
3. I'm not even sure if you can have the FE talk to the BE which would then talk to SQL Server.

Obviously, I am new to this Upsizing Wizard so some guidance would be much appreciated!

Thank you!
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000