What is the advantage of converting from MSaccess 2000 database to Msaccess
2003 database?

Hey all.
I'm trying to get hold of a database of books, preferably in sql,
access or something easily convertable to those.
The database should be like a library's, with records containing title,

I need to run a saved query and just need to know if there are any records
returned. Not interested in actual records. What is the easiest way to do
this?
Thanks

I need to validate a field in after update but only if it is a new record
and not an exiting record. How can I check for a new record in after update
event of a field?
Thanks

Is it a advantage to convert a database from Access 2000 to Access 2003?

I m trying to make a login page via Microsoft access. This is my table
.
Table name : tblLogin
PK : loginID(Auto number)

I  have a client table. User provides four keywords and I need to select
clients whose names contain any two of the given keywords. How do I go about
doing this selection?
Thanks

I have a variable dim'd as an Access.Application.  I have a routine that
adds a few lines of code in a module to another database.  But when I open
the module from the app variable, that code window is visible!  I've used
the app.visible = false, but that doesn't work.  The app ...

A2k2 with user-level security and all preventive measures, vis a vis,
Security FAQ enabled or enacted.
I've got three DBs, which due to size constraints can't, or rather,
probably shouldn't be combined. All have front-end on C: drive,

I've got application A, with a hidden form, whose unload event is
cancelled unless you use an 'exit' button (so I can do special
processing)
this works fine when using just application A and it prevents me from

My application deals with building information. Users may want to view
autocad drawings for a particular building.  The problem is that the central
server is so slow for some users that it could take five to ten minutes to
open an AutoCad drawing.

I am having alot of trouble reading in a date values from a text file
which is exported from another application.
My program is pretty basic, I read in values from a plain text file
which had comma seperated values.  I use the input statement to read

Hi I want to write a procedure which takes in a string of names
seperated by a whitespace and puts commas at each whitespace the last
name however, should have "and" before it.
Let me explain that with the help of an example:

I have been through every trick I know, or has been suggested.
I have a one to two million line fixed field database in text format.
I want to bring it into Access 97.
When I use the external data import, the list of files to import does

sorry i must update the data to a db with a combobox on  the forms, but
only when the combo is full of date. I write this on the criteria:
=IIF(IsNull([Forms]![FORM01 -  Input]![Combo_Excel]),[Forms]![FORM01 -
Input]![Txt_Exc],[Forms]![FORM01 -  Input]![Combo_Excel])