I had a Paradox database called Rolodex that I imported into Access. When I did this it asked me if I wanted to create a Primary Key field and I said yes. ...

i keep questions in a table, each question has a different answer type. eg answer could be a number then there will be limits for the answer or it could be...

I would like to have the Link tables manager to pop up apon starting a database for the first time. But I cannot figure out how to do this. Can any body...

I posted this before and I am hoping someone can help or lead me in the right direction.. I am about to redesign my departments Database structure. Basically...

Hi, I am trying to establish relationships between tables by using the ID numbers as the foreign key. For example using the ActivityID as a foreign in the...

Hi I am trying to use the Input Mask Wizard but I keep getting a Memory Overflow error coming up??? Can anyone explain what this is and how to stop it so...

Our schools database is often shared across 2 computers. Even when only one computer is being used our users often get a write conflict notice. If they choose...

Hi, Hope some one can help. I have been racking my brains for ages and can not think of a solution. I must point out that I used to be quite good at Access...

My database will record and report production information from a manufacturing operation. I need to lookup product information per machine and store the...

Hi, Does anybody know what the different types of Databases that you can design in Visio Pro are? The list includes types like Crowfoot, Bachman, IDEF1X,...

I'm going to split a database that is currently used by approx 75 users. I understand that the FE needs to be on the users hard drive. Question is: what is the...

I'm building a database to track articles for a newsletter. The articles deal with various court cases and fall into one of four major categories. These...

Does anybody know if it is possible to create a search facility abit like the ones you get on the Internet on MS Access?... I need to create a search facility...

I have a table that I delete all records from/then append records to on a daily basis. I modified the table by adding another field. My Append query now...

I'm trying to find out how I can do the following???? I have a product table that references a lookup to get the ProductParentID,but then I want the database...

We currently hold our Foreign and UK mailimg database in Access. When I send out a mailing to our Foreign database which has about 12000 contacts I get 2500...

Is there a way of linking a table relatively? I want to distribute a FE/BE DB, but I don't know exactly where the folder is going to be put. What I want to...

My database will store and report daily production values from a manufacturing operation. The operation has multiple machines and each machine has multiple...

Brief background: I have a very large 3rd party dbms (30+Gb) from which I need to extract selected data using an odbc link. Among that data is a table which...

Hello, I have created a table with a field called "Time". The Format is Medium Time with an Input Mask of 09:00\ LL;0;_ I have created the following records...