I am in the process of converting and access97 database
to 2000 or 2003.
Since I anticipate conversion problmes, does anyone have
suggestion on how best to go about this/ and or a

I have an Access 2000 database with the front end separate
from the data tables (Back end).  The front end is on the
clients machine, the back end is on the Win2000 server.
One client uses Win98 and Access 2000 and generates a

Does anyone know how to invert a string of data.
For example if the line of data says John Smith; I want it
to be processed so that it reads Smith John.
Any assistance would be greatly appreciated.

I designed a basic database in 97 which I have e-mailed to
my place of work.  It can be downloaded and opened on one
maching which is operating windows 2000 but not onmy
machine which is operatin windows 98.  I am getting the

I have a database application that is all in one mdb file
and is shared by several users on a network. It is
constantly corrupting several times a day. There is one
main form that has many subforms. If I split the data out

I have imported as Excel spreadsheet into Access.  In
Excel the field had a "time" format of hh:nn:ss
(37:30:55) which was useful for calculations greater than
24 hour time frames.  When I got it into Access it would

how can i concert a field of dates to a field of days of
week?  what syntax is to be used?  where is it t be typed?
eg, in design view? please state one or two examples in
layman's terms. thank yo

We have a share Access 97 database that we want Access 200
users to view but we do not want them to convert the
database to 2000. Does anyone know of a way to stop them
and allow both 97 and 2000 users to view the database?

HOW CAN I CONVERT DATES IN A FIELD TO DAYS OF WEEK?  I WANT
TO COUNT THE NUMBER OF OCCURRANCES ON EACH DAY OF THE WEEK.
PLEASE EXPLAIN IN LAYMAN'S TEDRMS.  THANK YOU.
ERUCH

Access 97 database...
Getting Undefined CNulls in expression error...
Query that opens form has this in the criteria
...Like "*" & CNulls([Forms]![Add_Students]![Last],"*")

I have a Excel database that I am converting to Access.
From there I am converting into Outlook. It all works
except my phone numbers are way off and incorrect. My
excel db is from a good source (database co.) and they

I have a Secure Access Database that I created in Access 2000, when I
installed
Office 2003 it no longer works and crahes Access.  
I've also tried converting the file using the convertion tool but I

Curently Jet are in version 4 will ms releceing JET 5 ?

Hi,
I've converted my database from Access 97 to Access 2000
(By importing 97objects into a new 2000DB). Apparently
not all the forms and tables are converted(I just took

Need VB Script informatio
H