Suppose that there is a table where field names are A, B and C.
A-B-C variations never to be same. I mean such dublication should be
prevented:
A-B-C

I have 2 Access Databases that I run on the same machine.
Before I run Access DB2 I want to check if Access DB1 is running.
If DB1 is running I want DB2 to Abort, not open.
How would I do that?

Can anyone direct me to an example code page which will help me do the
following:
After getting a path and filename from the user, I want to create a
new .mdb file, create tables in the new file without leaving the .mdb

I have a question.  My database is split.  I want a backup copy of my
tables in another database on a different machine.  Should I use
transferdatabase to get the info into the backup copy or should I link
the backup copy tables to the original database?  What happens if the

I have a report that I would like to email as a pdf attachment. I have "free pdf" installed that will create pdf files.
It is possible of course to print the report to the "pdf printer", and save/send the pdf from within the free pdf application.
Anybody who can drop a hint how i ...

I'm trying to kill a file bt I know my code isn't right and I can't
figure out the syntax,  any help is appreciated.
Thanks
DS

How do you set or change the path for a linked table.
The Server will always be called backoffice and the other terminals will
be named Term1, Term2 etc.  I will be doing installs of my database on
difeerent systems and I need to be able to change the linking.

For subforms implementing the Access navigation buttons, the Record
Count (which appears to the right of the buttons
('Record:' ...buttons .... 'of 32') takes several seconds to appear
after the subform is loaded.

Can I requery a subform on a parent form from a different subform?
What I have now that isn't working is:
   Me.Parent.frmBrPrognote.Form.Requery
Where frmBrPrognote is the subform I wish to requery.

I am trapping the 2501 Error after someone closes an email without sending
it.  So in the ErrorRoutine, I am asking them to send it.  If they click
okay, then it runs SendObject again.  However if they close it without
sending it again, the END/DEBUG dialog box with RUNTIME ERROR ...

I have a field on a form, that for the purpose of my test, contains the value
"HSN".    I have the following code in the OnOpen event of a completely
different form:
Dim stLinkCriteria As String

can we configure outlook to save the attachements to windows folder
automatically?

I'm using Access 2003.
I have a form with a tab control on it.  I was having problems with labels
flashing and I followed the suggesting from Allen Browne -
http://allenbrowne.com/ser-46.html.

Hello again and thanks in advance...
I assume this a probably a very simple one, but help files, google and
previous posts don't seem to hold an answer for me.
I've got a control for a filter (ctlSF) and want to set the Change event to

MS Access 2K, Windows XP
====================
Hi,
I'd like to send an email to people selected from a form using a list.  I've