Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MS Access get SQL Server data ???
Name: canman Date: June 23, 2009 at 07:49:29 Pacific OS: Windows XP CPU/Ram: 1024 Subcategory: Microsoft Office
Comment:
I have a MS ACCESS database with one table that has three columns. AgNumber, AgName, AgState. I want to have it when the user enters the AgNumber the AgName and AgState fields are populated automatically. Getting that information from a SQL Server database. Is this possible??? if so, how can i do this?
Summary: I have created a 'Library' database using MS Access 2000 and have fronted it with forms created with VB 6 however I have come unstuck when it comes to how to code a particular query, basically I don't...
Summary: I'm trying to do a minus / except query in MS Access 97 using SQL commands. Here's the SQL code: (SELECT DISTINCT * FROM table1) MINUS (SELECT DISTINCT table1.* FROM table1, table2 WHERE table1.col1 =...
Summary: Steve, I am not aware that you need to convert ACCess to asp. compatible. First, I believe you can complete develop your site in asp (vb, c#, or whatever) and then simply use the connectors and setup...
