I'm getting a strange error in one particular record.  Somehow, a duplicate
record was created, and I cannot delete the record.  I get the message "The
search key was not found in any record."  It's an error 3709.
What might be my issue?

I am creating a database for a friend that will keep track of issues and
questions.  I think it should be set-up similar to a family tree because
there should be a main question and then the ability to have follow-up
questions to those main questions.  Of course those follow-ups ...

does anyone have a databse for the above or one that could be adapted
thanks
marion

I've been using a tool called SQL Compare for a while now to update MS SQL
schemas. I found something called dbweigher that does something similar for
MS Access dbs but was wondering if anyone had any other suggestions I could
check out. dbweigher only handles table info. It does ...

I created a DB a year ago in which one of the tables holds input from a form.
Several of those table fields hold record numbers from other tables or
queries, HOWEVER the table field display substitutes the information in lieu
of the record number.

I have a third party event software that I want to use a linked table from my
database for its data, so I don't have to re-enter contact information.
The event software has a table that has name and contact information for
attendees.  Let's call it Event.Contacts

I have three tables: BusinessContacts, IndividualContacts, and Donations.
BusinessContacts has a one to many relationship with Donations (Donations
being the many side). IndividualContacts has a one to many relationship with
Donations (Donations being the many side).

I have a junction table that unites events and invitees. Plus other fields
like invited, present.. bla bla...
Now to save space I could only add the invitees that have been invited, but
the folks want the list of all invitees, and see who has been invited and who

I have recently been xferd from a 'Tech' unit to a 'Fraud' unit.
I know it can be done, and our IT people are 'unresponsive' to say the least.
Me - 15+ years in LE, an additional 5 in Comp Forensics, and now back into
Investigations.

Is there a keyboard shortcut to switch from design view to form, datasheet,
and print preview.  Was hoping there is one keyboard shortcut to "flip" back
and forth between these views.
Mahalo,

I wonder if anyone can help me with this. I have a table which has a form
attached to input data. I've just found out that I can't copy and paste this
table because I get a message saying "Record is deleted". But I am sure there
are no records were deleted.  Do I have a corrupted ...

I want to limit the number of rows in a table for demonstration purposes.  I
seem to recall that this can be done in the advanced properties of the table
in the validation Rule but I can't recall the syntax.  Can anybody share a
hint on how this is done?

i have requirement to synchronize few tables on different databases.
for that i'm doing below mentioned steps
(Note: i'm using .NET frameowork & trigger logic beacausei have to
perform few additional steps while synchronizing DBs which cant be

What is the best way to set up my database?  I have many projects that can
have many contacts; many contacts can be associated with multiple projects.  
My first attempt at relating was following this:
http://allenbrowne.com/AppHuman.html,

I'm working with a Insurance Sales Activity DB.  One piece is the entry of
the sales rep's daily sales by the type of contact (email, phone call,
meeting) by their Contact and the products discussed, etc.  They want to be
able to check off each insurance product that was discussed.  ...