I'm storing some fairly long filenames/paths in a table (they easily exceed
the 255 character limit for Text fields).  Does using a Memo field
unnecessarily increase database size?  Is there a better alternative?
Thanks for your advice,

I am using access 97.
Is there a way to export a table or query from access into a .csv file in
another directory on my "C" drive?
Thanks.

Hi there,
I received some good advice relating to having an alphanumeric reference
number, which I have been able to create and it works well in a query. Thanks
to those who took the time to give me the advice. However, the data that I am

Hi all, I'll try and explain this as best I can to make it easy on you. My
database is for keeping track of documents, drawings and action items all
relating to tasks and employees.
Tables:

I'm quite new to this so any help will be very much appreciated!
I have a 'master' table that holds the core data on pupils (Each pupil has a
unique idetnifying number). I want to use this data to form the basis of
further sub tables.  The sub tables will need to have additional ...

Will the websites created using Sharepoint portal server 2003 will be secure?
Or do i need to have a third party software for doing the security job?.

Found a problem I can not fix (back only recently to coding in Access so I
am very rusty!)...
I am importing a database from a legacy HR system, and it comes in two
formats, one with employee details, anotehr with the same details and the

I am using a normal SQL script for creating a table :
CREATE TABLE sample (
   id               int              NOT NULL,
   value1        int              NOT NULL DEFAULT 0,

OK, this is what I have so far from John V.:
Movies
 MovieID Autonumber Primary Key ' links tables together
 Title

I'm creating a database that has ~500 records in several different tables,
each record having a PDF document attached to it as an OLE Object. The
database is nearly 2 gB and will most likely be around 6gB when finished. I
know the max .mdb file size is around 2gB so I am getting ...

I am using Access 2003 and want a list box under the heading Division for a
personnel database.  Each employee will be either in Painting, Environmental,
Access services etc.  When I create a box now with the different headings
stored when I change the division from the list box ...

Does anyone know if it is possible to open up a datasheet from the
Switchboard?  I seem only to be able to create buttons for forms on the
switchboard...
Many thanks

I need to set up one table of basic information for our physicians that can
be the start of several other tables.  However, I will need all the other
tables that are formed from this basic table to update whenever a new
provider is added to the initial basic information table.

I want to import data to an existing table.  I want to overwrite the data for
existing primary key records and append new records for those that do not
already exist.  The standard import wizrd won't let me do this?  Do I need to
write a macro to accomplish this?

I am designing a database to manage product returns.  I'm after an
experienced persons opinion regarding set up.  Can someone please help and/or
make suggestions?
I have 2 tables - one for contact details and one for products. Primary key