I was trying to write a conditional query in MS Access today, without success. Here's the problem.<BR><BR>I have a field (myField) that is a lookup to a table (myTable) in the query. myField stores ...

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...

Distributed queries query more than a single database in the same server, or query databases on multiple database servers. These queries could be Select, Insert, Update or delete queries. Microsoft ...

Hopefully someone has a little experience with this. <BR><BR>Here is the setup:<BR>I've got an old access database that stores purchasing information from a system we used for the past 10 years. There ...