Search results for query: *

Yeah I've done that. I just am having difficulty in thinking about how it all hangs together. I think my real difficulty is understanding how the query will look for the right computer: where is that info entered and how do I phrase the query to look for that info? I have made queries that...

I am new to query structure in access although familiar with SQL. I am not even sure if my query will answer my problem. I am building a form that will enter the data for a computer. Each computer will have multiple components and multiple kinds of software installed on it. I will be able to...

Remember maintainability: Comment your code. Document what you have done and provide complete technical documentation with the app. You could get hit by a bus tomorrow and someone else will have to figure out what you have been doing; without comments and documentation maintenance becomes...

I have converted my tables to SQL Server and am now building two front ends to links to those tables. This is a conversion of an old 95/97 app that is being upgraded to use in xp and to convert to a more stable client server configuration. The tables in SQL Server and the same tables that were...

I am trying to overcome some issues of multiple users with multiple versions of Access, by converting to client/server configuration, using SQL Server, with multiple front ends. This works great with xp! However when I use Access97 to link to these external tables, I get complaints about the...

THANKS!!

I am embarassed to ask this because it must be so simple but somehow it has escaped me... How do I make a form appear when the database is opened. In other words, I don't want the user to see the tables, queries etc but only the forms in form view.

When converting an Access database application from stand alone to client/server with SQL Server, is it necessary to modify the SQL code in queries to conform with SQL-Transact syntax rules if the queries live with the front end? I am not clear on how to move the queries to the back end. If I...

Thanks! That is wonderfully useful information!

I am moving some Access applications to a client/server configuration using SQL Server. Some of the tables (and not all) are not allowing adds or deletes. Others allow. The one s that do not generate the error message "Can't go to specified record", in other words the table will not...

I am converting some Access applications from stand alone to client/server using SQL Server. The tables have all been moved to SQL Server, and are accessible. However only some allow adds or deletes, and others generate the error message "can't go to specified record" when I try to...

Thanks for the input. I have more or less resolved the DAO problem by copying the newer DAO files to the older version of Access and referencing them. However when I try to convert using the access utilities I still get errors generated about a missing ActiveX library. I have copied it in the...

I have many small but vital apps that have been created in Access 97 and need to convert to xp. Some run okay but others are generating errors related to things like old DAO files. When I try to open them in xp I cannot access the references in the Visual Basic Editor to update the libraries (it...