I have created a searchable database catalog using MS Access 2002. I would like to put this on a CD, but my customers apparently will have to have MS Access in order to use it? Is there a so...
Hello Experts,
I currently have an Access 2003 FE/BE application that is deployed over our corporate network. ~ 70 users with maybe 15 concurrent. In talking to my IT group they are suggest...
I want to make a form can relink the table when it startup, if the data source is change or can not find then pop up the open dialog to find the data source and reconnect the table! How to do...
Dear Experts:
I have an Access file that automatically run the routine to populate the tables in another database file once I open it. There is one form, two macros and some VBA functio...
Hi
I have a table with a subdatasheet. It looks as though I'm going to have to import records into it on an ongoing basis from Excel. I can import into the main part of the table no probl...
The relationship between two tables in one of my APPEND queries disappeared for some unknown reason. When the query executed, it added several hundred thousand records to a table that has 2,5...
Hi there,
I have a database with a table. I reached the limit of 255 columns. I attached a new table with a one-to-one relationship. If I use this in a form, I get the message: exceeded 255 d...
Hello,
I would like to know if it is OK to have 1 table instead of many. I am early in db design now. I have tblBorrower, tblApplicant, tblGuarantor. The fields are basically the same for...
I have created an Access table for contracts that has two fields identifying the (contract) start date and the (contract) end date. I thought I could have a validation in the table design for...
Database-A and Database-B are set up identically (they keep data for two different branches that operate identically, except with a different client list). We have been given a Microsoft Acce...
What is the best way to go about cleaning up my database at http://www.dropio.com/tasksdb ?
I have been told I have duplicate information across two tables. I know I have some dependencies...
I am tryiing to design an access database to track all of our estimates and the data that pertains to that job. Well the problem I am running in to is that I am a Novice or very green develop...
I have been working on this database for a long time, and there have been several different versions of it. So far, my data is ultimately still in good shape, and I'm constantly adding new inf...
I have contacts of within the company (4 to 8) and outside the company (will be unlimited) should I combine them in one table?
Let's say I run a query in Access and get a table back with 100 results and then I send those people a mailing. Several months later I have added new names to my database, some of which fit t...
Hi Again,
The saga continues...
I began the development of this database in Access 2003, which is the lowest version of the user base. The company upgraded to Office 2007.
My question...
I have an access 2003 table that lists unique Sites. There is one row for each Year a site was visited, and columns showing number of Visits made that year, and number of Points surveyed that...
I have a table in access which looks like:
ID FundNo Partner Company Sector Stage Total Cost of Investment Amount Realized.......
1 1 Partner1 ...
