1. Do any versions of Access have a NEWID() function like MS SQL?
2. Are there any comparable functions _besides_  rnd()?
Janet

I have a basic/general question about data storage, to make sure I am
backingup all the data.  When you create a database and start loading data
into it is are all the data files stored within the main database file.  So
you only have one file to backup?  I can only find the one ...

In the past, I have used two really good references for Access programing
info.   These refs were available on the net from MS, I think.  However, I
have moved and no longer have the refs.  I think the best was something like
"building applications in Access", and not the ...

Access 2003
I am trying to find a way to print membership cards... I have a database
that has a yearly membership with some 1000+ members... I need to print out
cards only for those members that I have selected... then update a field

I'm relatively new to access and Im using access 2003.  I created a
small database in an effort to track how much my friends owe me (just
as a learning experience).  I have two tables. 'Debts' and 'Debtors'
The primary key in 'debtors' is used in 'debts' as the refference.

I do a lot of mail merging with msword.   I would like to keep the whole
process within Access.   Can I use the Report section some how (embedding the
mail merg word in report)?  Any ideas would be appreciated.   Thanks.

I have a table for vehicles and a table for trip details. Every day, the
vehicle gets used, and the user must enter the odometer reading before the
route, and the odometer reading when the vehicle is brought back. The next
day, the process is repeated. A lot of times, the user ...

When I edit a table with a unique primary key, that is composed of more than
one field, and enter duplicate values (ie. duplicate key) I can't leave the
record (which is OK) but Access 2002 doesn't tell me that I entered
duplicate key (which is NOT OK). Is that just a mis-feature ...

I currently have Office Pro. Ed. 2003 installed on my current PC.  I will be
getting a newer PC in a few days.  How do I "DE-activate" Office Pro. on my
old PC and install it on my newer PC and activate it on the new PC.

I learnt at some point that it s more secure to set the queries rights at
owners level rather than grant rights to the table itself.  and i have been
doing that, but quite blindly.
could someone clarify as to what is the exact benefit of doing this?  what i

I am working on a database that was desisned in access 97. The database
itself is still in access 97 however the user front end had to be updated to
access 2003 to all for a new active x script. When a user login i to the
datbase they have to transfer data from and hp3000 ...

Is there any way you can add email addresses in a data base to say the
contacts folder in MS Outlook?
Thanks for any help

My Access 07 navigation pane includes the name of the object (Query, Table)
and also the date created and last modified. How can I get it to just show
the name and not show the dates?
By the way, even after I modify a query it doesn't seem to change the 'last

       Sorry for posting in the general group.  I posted this in the ActiveX
group, but it looks like that group is all but extict.  I thought I'd try
my luck.
       I've used the MouseWheel control in the past without problem, but now

I'm looking to download a pre-designed template for Microsoft Access.  This
database will allow for inputing student records and transcript printing.
THANKS!
- Matt B