Anywhere I can find a listing of differences/comparisons between the various access versions and the way they handle data? Anything that details limitations such as A97's 1GB limit or details on different JET versions and if certain versions of access require certain version of ...

Please be very patient with me. I need help with this
small but important project.
The db mentioned below can be downloaded to help me
better ( http://www.geocities.com/nextelito/db1.mdb )and

I'm getting a "Compile Error" "Syntax Error" on the last line of the
subroutine:
CopySourceFiles(strDailyPath,strDailyName,strlocalpath)
As you can see the last argument is not being acccepted as it is all lower

How do I change a field in my table from text to memo?  
THe table already has records on it.

In Access 2000.  Would like to create a Journal database,
such that I can "archive" (move) data older than 30 days,
either to an "archive" db or to CD.  Table would include
auto date and time fields.

Hope someone of your clever folks can help
I have an InfoPath form (on a tablet PC) bound to an Access 2003 database
table
I want to store an ink signature (created using a InfoPath Ink Picture

I have a little problem that I can't resolve.
History:
   I have built an interface on Access 2002 that is link
too a database on SQL 2000. I have a 2 copies of the same

I'll simplify this from the actual situation that I have, but it will show
my problem.
I inherited this table so don't blame me  :-)
TABLE1

in Access 2000.  Would like to creat a Journal database,
such that the text in the details field could not be
edited once the form is saved.

I am slowly learning my way around access 97
Can anyone point me in the direction to some reading materieal on instructions/steps to creating report menus such as that in the Northwind Sample Database

I have the following situation:
A product is made and data is collected:
ProductID
DateMade

the database to work like i need it too. I have a music studio and need to catalog my hard drives. I want to be able to enter the drive serial number as the identifier and the drive size then list the artists who have material on the drive. the song name, which pre-masters CD's a ...

I need to be able to generate an autoID that would be
unique to a particular database, but also unique to about
5 other similar databases.  If I use the normal
autonumber, I could potentially get a, say #23, in each of

Hey all
I want to store the dates of when each state became a state. So a lot of the dates were back in the 1800's, what would be the best way to handle this
thanks in advance
ari

Hello.  I am in the process of designing a database where
the backend resides on a server.  The tables are linked to
a frontend which resides on my hard drive.  I have one
table that must reside in the front end for security