Recent content by Dmitriy

I called Microsoft Support about this (half a year ago) and they confirmed that it is a bug in Access 2007. I doubt they've fixed it though. I was told they'd let me know if there are any updates, but I haven't heard from them since.

You were right, it's a known bug with Access 2007 and SQL Server. Stored procedures work fine with Access 2003 though.

I have a form in an .adp file in Access 2007, and the project is connected to SQL Server 2005. The form uses a stored procedure to display records. The stored procedure does a JOIN of 2 tables, and has parameters which are passed in through the form's Input Parameters property. It compares the...

I figured it out. I was using the name of the subform instead of the name of its control (the 2 names were different). The Refresh method actually didn't work anyway, I had to do this: Me.PETechSub.Requery (where PETechSub is the name of the container holding the subform).

That didn't work either. Now it apparently can't find the subform: "Run-time error '2450': PE Database can't find the form 'PE_subform' referred to in a macro expression or Visual Basic code."

I'm working on an Access project (an .adp file) which is connected to SQL Server 2005. I have a form and a subform, and the subform gets records from a stored procedure called PETech. PETech takes in a parameter @act (a code) and returns all records where a certain column matches that parameter...

I've already posted this in the MS Access forum, but I might get more responses here.. 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...

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...

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.

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.

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...