I need some help with the design of tables structure and their
relationships.
The following is a generic outline of the tables and some example data:
***************************************************

I need to convert my existing MS Access database to online web page.  This will allow the user to enter information through web page format but still allows me to maitaint the database in MS Access
Any information suggested  books or web site for me to read about how to do it ...

I have a Text field name Company ID in Table 1, where you
can enter values as 20,30,201, - each value separated by
commas represent Company A., Company B., Company C.  I
want to lookup those value in another table (Table 2) and

I have a table that we import data into from a text
file.  Our dates in the text file are in a format like
20010101, etc.
Is there a way to make Access read and treat this as a

I was just thinking if all of my tables really need
autonumbers for PKs or not.
For instance, do the following really need autonumbers?  
Could I just have them be long integers and I manually

I have a date/time field that is set with a custom format
of mmm-yy.  If I enter a date in the past, say Apr-01,
Access will display the date as the current year--Apr-04.  
Does anyone know what I can do to fix this?

Is Ms Access capable of handling the load of over 900 html
pages to run a database to update a website?
Thanks for sharing your knowledge.
Need2Know

I have two tables linking through a unique identifier
(id).  
info and pinfo.  I want to delete certain records from
both where info.date < 01/01/2003 and info.type = "Vr1"

I've developed an application in Access XP with custom Help Files, Menu and Tool Bars. I've also applied an ActiveLock (nslock15vb6) 30-day clock for registration purposes. I have then used Office XP Developer Wizard to make a Runtime Application. I know that, if I try and open ...

I was wondering if anybody could provide some "heads-up" assistance before I proceed on some DB development
I am attempting to create a DB that allows a user to rent a piece of inventory for an alloted time period. Basically, I have 2 tables created, 1 each for the Inventory and ...

i am trying to create a db for teachers.  Each teacher has three main
catagories: location, age, cert.  Each teacher can work in multiple
location.  Each teacher can have multiple certs.  Each teacher works

I have a date field where I know that the day is always required to be the first of the month. Is there a way to default just the day or to validate that the day is always the 1st
Much thanks
Lynndyhop

Any idea why my autonumber field suddenly jumps from 40
to
1081187930 ? All tables have the same problem. Even a
previously made backup (copy to file *.bak) has the same.

Ok, I have tables with 2 - 3 columns, and from 40 - 600
rows, imported from a text file, created by ArcCatalog.  
I need to turn the rows into columns, and vice versa.  
There is nothing to total so a crosstab query is out.  Do

GirlFriend 1.0 - Software Helpline Excpert
I'm currently running the latest version of GirlFriend and I've been having some problems lately. I've been running the same version of DrinkingBuddies 1.0 forever as my primary application, and all the GirlFriend releases I've tried ...