I am looking for input on modifying a design to improve performance. Version 2003 - All property split and linked. Mde on all front ends. Using DAO. Each...

I'm working with a Insurance Sales Activity DB. One piece is the entry of the sales rep's daily sales by the type of contact (email, phone call, meeting) by...

I want to limit the number of rows in a table for demonstration purposes. I seem to recall that this can be done in the advanced properties of the table in...

Hi all, I'm hoping that my tables are normalized properly, but I'm stumped on a particular layout and design structure. I hav a table with faculty, which...

Hi, I would like to know if Runtime can be used with a split database. If not then which one would be the better choice in the following network setup. The...

I have a client who wishes to place several hundred documents into a database. Then attach values to specific statements in the document. So far so good....

I currently have an application that I developed about 4 years ago using Access 2000/VB6 on Windows 98. I now use Windows XP. I am a beginning programmer. I...

I know the work around is to use the IIF(,"Yes","No") statement, but is this going to be fixed or is there a need to have it this way from now on?

I have inherited 9 stand alone databases that need to be merged into one package. The problem is the auto number it is the primary key and unique Identifier...

Is this valid? Three tables (call them A, B & C), each with a junction table between (call them a, b & c). Six tables total, in a related in a circle? Is...

Hello, everyone. I have a database that has been in use for about a year and has around 2000 records in its main table, "tblThreads". In this table, we had...

Hello, I have a field that is specific for numbers only .. here is the problem I am having .. for example if I put in 15.5 .. it rounds it out to 16 .. 17.5...

Hello, I have a relational database well written if I do say so myself :) About 75,000 records in one table, linked to an examinations table with details of...

"Robin Donald" wrote: Thanks for jumping in and, yes - I forgot that bit. Each user (4 max) had an mdb front end which he runs from a local copy on ...

I have the onerous task of querying horribly denormalized databases. I'm trying to convince the boss that normalization is their friend... The databases at...

I am trying to design a database and I haven't worked with them very much, but have a fairly good knowledge of database design. I have been trying to...

I have access 2003 and have a table that I would track history - I'd like it to go as follows: On the table there is a list of stores and store managers The...

I am tracking data by date that may have up to 20 seperate cominations and all using a drop down list. Would I need 20 different data fields or is their...

I have a Staff table, where a staff memeber can work on one or many Projects. I am not sure how to construct a table to show the weeks worked (example:...

Hi, I am fairly new to access but want to set up a field in a table that, using the date(in UK format of dd/mm/yyyy) from another field in the sane table,...