🚀 go-pugleaf

I have two problems

PROBLEM 1

I have a field in an Access database which stores dates.

In Arcview I would like to query a theme on the date field
to find only entries before or after a certain date.

When I use Theme - Properties - Query.
I try to query using the (date field) > the date I enter, but it is not
accepted.

Should the Access field be a date field, and it what format?
Should the Arcview field be a date or text type field and how can I change
it if necessary?

PROBLEM 2

My Access database is connected using SQL Connect. I connected some tables
early in the duration, and then went to connect another table. Now when I
Open my project
Iam asked which database to connect to not once, but when the first reqest
is processed 
Arcview will ask for the second database which is the same as the first.

Is there a way using scripts to automate this? If so could someone give me
a
hand.

Regards

Grant
 
gsbaker@ozemail.com.au