March 20, 2013 at 2:27 pm
Hi all,
I am trying to develop a small database for our company. Although I come from a computing background I an not a database expert. After looking at some options I decided to try access ADP. By way of learning both Access and SQL Server I started going through tutorials on accessallinone.com site. First as regular Access database, then as an ADP. :-)) I use Access 2010 and SQL Server 2008 express. Well, I got stomped right off the bat. In "09 – Select Queries (Criteria)" tutorial a value from a text field on a form is passed to a query. It works fine in Access-stand-alone, of coarse; but not in ADP. Here is the query as seen in ADP (the last line is my attempt to re-create what I see in stand-alone version as the query builder does not prompt for the Forms):
SELECT StudentID, LastName, FirstName
FROM dbo.tblStudents
WHERE (LastName = Forms!FrmLastName!TxtLastName)
Any insights into how to achieve this will be greatly appreciated!
March 20, 2013 at 3:09 pm
I see what look like you were doing VBA on MS Access. I have not heard of database application name ADP, what is it?
March 20, 2013 at 3:21 pm
Microsoft Access can create a database with tables located on SQL Server. This option is called ADP. Basically, Access as client and SQL Server as server. At least that's the theory :-))
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy