For a network database and only that database - It would seem simply
to allow only a few users to be able to modify objects or enter data.
All other users would be read only. However, I can not seem to get the
settings correct. I have read, multiple times, the FAQ's on Security

Does Microsoft intend ending support of Access 2000 in future?

I am trying to integrate data from several sites into 1 (new) table. In
order to distinguish the data from each site in the new table I have a field
(InstID) which holds the Instution number of the site. The fields from the
old site tables and the new table are identical except ...

This is my first time posting so I hope I make sense.  I have a table where
I need to change from row into one line column.  
This is what I have:
Patient ID Code    Code

I have a form where I need a Yes/No field to dictate which of the two
following fields have focus.
If field 123 is yes then field abc is enabled and xyz is disabled If field
123 is no, then abd is disabled and xyz is enabled.

If I have an attachment field holding pdf files in Access 2007, what happens
to this field type/data if I upsize to SQL Server Express?

I have a MS-Access database that has 20 tables.  Each table has several
indexes.
Is there away to rebuild like SQL Server?
Please help me with this task.

I have a client that needs to allow Team Leads (as well as other resources)
the ability to update, create and modify project plans.  What would be the
best way to handle this? Set up a new group or to select the appropriate
permissions? Thanks.

I'm using Acc 03 on a Citrix farm and Mr. Lebans excellent ReportToPDF.  With
the database window visible the PDF gets created fine: with it hidden it
fails with Error 2046
"The command or action '|' isn't available now.@* You may be in a read-only

I have a table that contains transactions amounts, transaction codes, and
dates.  I have created a Cross Tab query that that has the Transaction Code
and the Row Heading, the Date as the Column heading, and the Transaction
Amount as the value (summed).  My goal is a to produce a ...

I have created a database to keep a track of orders.
In the stock table I have a field called amount in stock.
In order table I have a field called order quantity.
I have created an update query to update amount in stock to [amount in

 I have one Access application linked with SQL Server. There are few
forms loaded with lots of subforms and comboboxes. It takes 1 minute
or more to completely load one form. Is there any way I can optimize
these forms? There are some comboboxes which contains the same

I need help with a cmd button. I have three forms. Form 1 is to enter
information for documents. I have a subform on form1 that shows revision
status. For example on form1 i have docID, Doc Num, Desc. etc. The subform is
related to the docID. The subform shows effective date, rev ...

I know just enough to be dangerous.
We have our business system set up to pull database queries out of the
system, say for example, raw material part numbers, description and average
cost or last cost as well as avg usage.

I have a field,   named [Type].
In a report, what is the expression to count this field “[Type]” where
Type=Truck
??? =Count([Type]) where type = “Truck”