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