i'm building a database in access and i want to restrict permissions.
from the access i can just limit the posiblity to unhide an hidden
table and in this way i can preventing the users from looking in un-
relevant data

Hello...
After many years of programing with access, I decided to automate the
creation of the vba coding behind a form.
Basically, I have a form where I select all the settings for any given

I couldn't think of a good subject line for this one. I'll try to make
things succinct.
I have a "Quick Search" feature I've implemented that searches for
types of objects (Customers, Sales, etc) and returns a group of those

I'm a newbie in doing MS Access Forms.
I would like to create a form that will input data to a table.
In order to get the PropertyName, I have a query that gets that joins
the PropertyId to a different table to extract the PropertyName.

I have a DB form that gathers all my information for my database.  It's quite
simple and straight forward.  but I collect some redunant information in some
of the fields.
I was wondering if there was a way that access (in the FORM) can

It's been over 10 years that I don't look at Access. I've been working
in asp.net for the last 5 developing intranet sites.
Just got a project where we are trying to avoid building an
application by virtue of reusing something already in place at another

I want create a report based on the crosstab query which normally
returns about 50 - 60 columns. The columns have names of the counties
and they keep changing for every session. Is there a way to program a
dynamic multi-page crosstab report?

I would like to compute the great circle distance between 2
destinations with the lat and long information provided.
Any ideas on the formula to be used as an expression, and if an
analysis add-in is needed.

I am developing a db and i have 3 rate levels. the subcontractor
begins at level1 (1-19 hours). when she performs 20-29 hours they fall
into level 2 and 30+ falls into level 3. I have the payrates in a
table attached to the client because of fluctuation of pay rates

I want to change a field data type from Text to Memo.The reason is I
need to type more text in that field.
when I was saving the change I got error message "The width of a
Unicode text column must be an even number of bytes."  Could some one

I need to install an ODBC driver for a database, but our system-
administrator does not allow me to install it on the VPN-server. Is
there a way to install an ODBC driver for a separate user. The client
using the driver is an ms-access database. The server is windows 2000

Hi wondering if someone could give me a example of how a hospital can
be setup in a n-tier environment? Thanks

I'm trying to recover data from a corrupted .mde file. It's the
backend of my split database, and I cannot for the life of me figure
out how to get in there and open it.
Symptoms: Users reported around noon that they were unable to re-open

Hello....
I have a subform with a header, detail and form footer.
The form Header contains labels identifying the fields in the detail
row.

I have 2 tables
tblReports  primary key UPN, plus numeric fields Effort, Attain,  etc
tblComments numeric primary key ID & textfield Text
In the Query I select each record from tblReports using UPN and for