trying to get some old stuff off an old  database.
installed access 97,yes access 97. on a W2K, update4 machine with 500mg ram.
ALL other programs run great.
i get: 'out of memory' "A system error occured., or there isnt enough

I have a database, front and data backend, I have written in Access 97
and it has been chugging along for the last 6 years all with constant
updates except for the last year with almost no wupdates. Anyhow, the
database backend that stores all the data is now 225Mb in size and needs

I have an Access 97 database to record the current location and status
of files in our office.
Each file has a record one field of which is it's current location.
On the form for each record is a 'limit to list' combobox from which

ADO is a large subject and most likely a person will not fully use all
of the features in Access.  What is a good source (book?, web page?) to
learn the core features of ADO commonly used in Access?

I have a Table1 with ID, FirstName, Surname, Address1, Address2, PostCode,
Suburb, Purchase.
The table list all purchases made by all customers.
A customer can have multiple purchases and there will be multiple records

The story is that I have bought an application that comes with an MS
access mdb. Every time the application runs it will open the Access
exclusively. Is there any way I can open the mdb for read only when
this application is accessing the mdb?

Hi
Very novice sorry. Trying to add a simple query to a textbox...I am
getting Enter Parameter Value
I have a Form called (frm_tbl_RR_Datacapture). With a series of

I was wondering if there is a way to format row colors
in forms in Data Sheet views individually like you can in Excel?
I'm using Office XP Pro.
Thanks!

I know this is probably an easy question, but I could not find/figure it
out.
Basically, I am printing mailing labels with a "Sorting/Grouping" section
that groups the label types together. Also, I am using a "Report Header" to

I have two tables, they contain:
Table1: ID1, Name1, Address1, Purchase1
Table2: ID2, Name2, Address2, Purchase2
I need a query which creates Table3 with content from Table1 and Table2.

I am using Access 97 (if this makes any difference to any answers).
On a form I have a combobox and I want it such that when a user
selects an item from the list, this executes an 'INSERT INTO' action
query to be executed that adds the item and time and date into a

I am attempting to set global variable (bad practice, will replace
with class later, just exploring an idea) with the following code in
an startup module
from globaldec.bas...

Is it possible to make command buttons (in forms) have a background
color?  Or is there a means to simulate a command button and make it
have a background color and able to kickoff a 'click' event?
Thanks.

 Could anyone point me in the direction of a document that describes the
difference between JET and Access? I can't seem to find anything.
 Another question i have is i have this application (.net) that writes to a
databaase every 10 milliseconds(purely for testing). While it's ...

This may seem hard to believe, but my company still develops in MS
Access 97... it's very frustrating, especially having used 2000 and
2004 and knowing how useful the updates are!
Anyway, whilst on a course recently I devloped some code in MS Access