Search results for query: *

Thank you both for your ideas. I think I am going to have to lean towards adding an InvoicePendingID column to my images table. Here's the situation. I work for a construction company and I write enhancements to our current accounting and job cost tracking software. I do so with the good...

I have three tables that contain information for an invoicing system. One table, InvoiceImage, contains image information with multiple records for each invoice and the other two tables, InvoicePending and Invoices, are for pending and approved invoices. As it occurs now I have to create the...

You might want to also insert some code that excludes "." and ".." from the returned values. These values refer to the current and encompassing directories. Including something like: IF MyFile <> "." And MyFile <> ".." Then inside the While statement will preclude them from being inserted...

Because Access uses the JET database engine and all of the data manipulation/calculations are done by the clients, any modification of the server on which the files reside should have no effect. One of the biggest complaints about Access and JET is it's record locking capabilities. The ldb...

Which would be a more efficient way of creating a medium size (40-60 user) client server application using SQL Server? 1. Access Project using ODBC linked tables to view local Access data. or 2. Access .mdb database with linked tables for SQL server data. I would like to use local data for...