I'm setting up an Access DB (v2003) for use as the backend of
a web application.  As the db grows I see the potential of upsizing
the db to SQL Server.
So I'm wondering...

I am fairly new to designing db's and I did one db for my company for fun and they liked it so much they want another one.  Problem is I am having trouble getting the idea down on paper so I can start.  Here is the situation:
This department issues their product to our other ...

I have recently been aproached with questions about
Document management / Relational Databases for managing
business. I also recently attended a presentation by an
IKon rep in which they tried to sell an mdse based

Is there a way to use the countif function to count cells
in a range with 1) a red background and 2) that contain
letter "A".  Something like the following.  
=COUNTIF($E112:$K163,Font.Color($P$150))

how do you centre text in an access datasheet

We have an old database where one field has gone missing.
If you check under design the field name is listed. But when you open the
table the field is missing.
Any ideas.

I have been working on a course consultants database for a while and I can't seem to get my head round the relationships and so need an 'outside' opinion.
One table contains the course consultants information - department, faculty, email, phone number
Another table contains the ...

Hello comrads,
I am in need of some help.
Access2K.
I have table A and B.

After splitting my shared database, the front-end (stored
locally) is running very slowly.  What sort of things can
I do to improve performance and speed up connections?
Thanks for your help!

Here is my situation.  I already have a database with a list of all the parts our facility manufactures:  PartID, PartName, PartNumber, etc.
I need to create a seperate database for data collection.  Each part will be collected on a daily basis.  Each collection will also contain ...

this is a bit complicated but I will try to be clear.
I am linking to four tables in anther table. I have set up
forms and subforms based on queries using a mixture of
fields from various linked tables. I get back the data I

I hope this makes sense.  I have three tables (X, Y, Z).  The info in table
X is input from a form.  I would like to be able to automatically populate Y
and Z with the ID from X.  Is there a way to do this without manually
populating Y and Z.  Any help will be appreciated.

when i opened my 2000 data base in 2003 the little arro
next to the table entries that linked the table to entries
in the main table have disappeared.  the main table works
fine finding all the smaller ones but not the other

I have the following code:
   Dim db As Database
   Dim rs As Recordset
   Dim Qd As QueryDef

Using Access 2003. Have a utilty db with a lot of small
tables (2 or 3 columns, 10 or 20 rows). Each time I open
the table in datasheet view, I'd like it to open in the
same size & position it did last time so I can view