Is it possible to lock a table so that new records can be added but existing ones can not be deleted?

I have a split Access Database on a network. I need to add a new table to the database. Do I export it to both the front end and the back-end or do I run a...

Is there a way to do the following? The scenario: The “Animals� database contains the “AnimalsInfo� table. tblAnimalInfo contains the “AnimalType�...

I have two fields and I wish to validate one to depend on the other This what I would like to happen if field1 = text1 or text2 or text3 field2 must be...

I have a database that I want to share over my network (total of 9 computers on network). I split the database to have a FE and a BE. However, once split,...

Hi there, hopefully somebody will be able to offer me some words of advice. I am creating a database for a firm that deals with property insurance claims....

i have a form with a subform and on the main form i have a toggle button that locks the subform.. with this code !!.Locked = bLock this worked fine until i...

I have a table with a Gross Sales field and a Total Costs field, there is a third field called Net Sales. How can I create a function to take Gross Sales...

I have 3 fields for Name. LastNm, FirstNm, and Middle Initial. How do I ensure the full name, i.e., "LastNm, FirstNm, MiddleInitial" combined are unique...

Hi, I am trying to locate the expressions: IIF, Count, Sum, in the Expression Builder window opened through Validation Rule in TableDesign. (Access 2002...

Things like on the forms (beside each label), how can i include a question mark symbol that, when the mouse hovers over it, shows the format needed for the...

Hi, What if you have two organizations and you plan to design a database to do the same task but within that task, the defined tables will vary because of...

Using Access 2003. I have a tblFamilies and a tblFamilyMembers. What do I do when I have a "family" where the Dad lives at a different address and is...

I have to either frequently spend hours preparing an archaic report by hand in excel for change resistant paper people or figure out how to display the data I...

I use a crosstab query in a database as a first step in recalling multiple monetary transactions made on the same day that, when added together, exceed...

Hi i want to change a filed called salary range property settings so that the currency does not show £ or $ in my reports but a local currency which will ...

I haven't use the attachement data type before. I set up a field in my BE tables as an attachment data type. I placed this field in my FE form, but when I...

When I update a feild in MS Word, Access opens up to get the proper information, but does not close when it is finished. Essentially, every time I update a...

Is it still 1Gb for the latest version of Access?

I need to design a database that will track the supplies ordered from a supplier as well as track these supplies when they a shipped to investigator sites. I...