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
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 ADP link with SQL Server 2005
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 06/19/2013 :  01:58:54  Show Profile  Reply with Quote
G'day everyone.

I hope this is in the right section so here goes.

We have a number of MS Access 2003 database applications at work that we are considering migrating to other technologies.

So at the moment, I am in the process of testing migration options for one of the smaller Access 2003 Database to ADP-SQL Server 2005 setup. The ADP file is - as a number of you will know - a MS Office 2010 file type that holds the forms and reports (all front end elements) and the SQL Server 2005 holds the tables and views (or queries).

The conversion went okay with help of the Upsizing Wizard. When I open the ADP file, I can't see any of the subforms within the main form. So I looked up the data source of one of the subforms and it had an incomplete SQL query. So I copy this from the original .mdb file and paste it in - not expecting it to work the first time, rather trying to see the behaviour when you do this. When I try to run the form again, it throws up the following error:

"The multi-part identifier "frmMainForm.form.txtFromDate.value" could not be found"

Now I tried to look up other posts in this forum to see if I can find anything useful to solve this, but didn't have much luck. I even checked some other forums before I entered the post here without much luck.

Any help would be 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