Problem with form after upsizing to SQL Server 2005

Dmitriy

Registered User.
Local time
Yesterday, 18:19
Joined
May 16, 2008
Messages
11
Hi everyone,

I currently have a database in Access 2007 that I want to convert to SQL Server 2005, but I want to keep Access as the front-end so that I can continue to use the forms. The tables and queries will be in SQL Server.

The form I'm having trouble with has a drop-down menu with a list of codes. It has a subform which displays records matching the code selected. The information comes from a query that selects certain records from a table (based on other criteria). This is all designed using link master fields and link child fields. The problem is that when I upsize to SQL Server, this feature doesn't work anymore. Nothing happens when I select a code from the drop-down menu. I know the query works, and the form does get records from it, but changing the code doesn't do anything. I'm guessing that the problem is with link master fields and link child fields. Is there any way to make the linking work?

Thanks
 
First of all, are you using the correct ODBC driver? If you are not on Vista, you need to be using the SQL Native Client driver to attach to SQL Server 2005, instead of the ODBC driver just named SQL Server.
 
First of all, are you using the correct ODBC driver? If you are not on Vista, you need to be using the SQL Native Client driver to attach to SQL Server 2005, instead of the ODBC driver just named SQL Server.
How would I find this out? I just found the SQL Native Client on Microsoft's web site and installed it, but I don't really know what to do with it..
I'm using XP, by the way.
 
How are you connecting your Access to the SQL Server? I'm assuming you are using the Linked Table Manager. If so, when you first link the tables you are prompted to select, or create, an ODBC connection. Delete all of your current linked tables from your frontend and then you link back again using the External Data Tab.
 
I haven't used the Linked Table Manager. I used the upsize wizard to convert everything to SQL Server, and the wizard created an .adp file which is connected to the server. I didn't actually link anything.
 
That is still probably the problem. The conversion wouldn't know to use the right ODBC connection.
 
So what can I do? Is there a way to change the connection type?
Once Access has created an .adp file, I can't use the Linked Table Manager, and the upsizing wizard doesn't ask me to pick a connection type.
The only thing I can think of is making a new .accdb file and linking everything to it, but that's not what I want to do.

Thanks for the help so far
 
Frankly I'm not sure as I don't use ADP's. I doubt I will so perhaps you should try a separate post in the SQL Server section.
 
I renamed your other thread because it is not the form you are necessarily having trouble with, it is the ADP.
 

Users who are viewing this thread

Back
Top Bottom