I'm trying to check for and add a field to a table to a back end database
through code.  The problem I've been faced with is changing permissions,
because I have to use administer permissions to change the design, then
remove the delete permissions when the design has been ...

Does anyone know if it is possible to make .mde with the runtime
version of Access XP, and if so, how?
Thank you!

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If LaborCost > 0 Then Me!LaborCost.Visible = True
    If MatlsCost > 0 Then Me!MatlsCost.Visible = True
    If OtherCost > 0 Then Me!OtherCost.Visible = True

I am distributing an access database to systems that all have office
installed on them.  Is there any way to force this database to run in
runtime mode - other than the /runtime switch?  Are there any security
advantages to doing this?

Access 2000.
I am trying to compare the value of a text box control (bound to a field in
a query) to the value of an unbound text box into which the user enters a
search string on the same form.

380  If Not IsNull(Me!MatlsList) And (Me!MatlsCost = 0 Or
IsNull(Me!MatlsCost)) Then
390     MyMsg = "You entered something in the field entitled
'Materials List' but no charges in the 'Materials' cost field. "

I have an access database replicated over a network. Recently and more
often, after I fill one record into the database, and then try to
replicate it, I get this message "scaling of decimal values resulted in
data truncation".

What are the best ways to implement security for Access databases (i.e.
.MDB files)?
I ask the question from a general perspective. Why? Well I had written
a prototype database which I split. So I thought that I'd implement

I set up a password protected Access Database and would like to now
completely remove the password and any security functions. How do I do
this?
Any help will be greatly appreciated.

I'm in desperate need of your help..
I need to build an access database and have NO idea how to do this..
Not even where to start..
It IS for school, and am not asking anyone to do my homework for me.. I

I am a beginner of MS Access 2003.  Could you recommend any good book
for it?  Thank you in advance.
David

I use the Microsoft Access Calendar (ActiveX) to pass dates into queries
and reports.
I have recently come across the Microsoft Access DatePicker developed by
Brendan Kidwell and I now use this to input dates into various text boxxes

Does anyone know how to setup a parameter query, which allows the user
to choose from a combo box? TIA

     gemachtable
     Dates
    CheckNumber
    Name

Hi everyone, I've got a simple problem to fix, but I'm not familiar
with MS Access.
I have two tables, Students and Course Registration. Students was part
of the original design of the database, but Course Registration was