Last week I suddenly could not open Access tables, queries, etc. in
either design or data entry view.  If I create a new db, with a new
table, everything seems okay.  However, once I try to open the table
then I receive a dialog box (having an explanation mark and "Microsoft

Is there a tool that I can use to create an MSI file to deploy an Access
database?  I did a few searches on MSI on the Microsoft Website, but I got a
lot of information that had to do with MSI files, but didn't answer any of
my questions.

I have a command button which has a macro running in it.
The macro on the click event, runs to ensure that certain values in a
form are valid, (e.g. the textboxes are not null)
and after the macro runs, an update query would run...

I have a one table of logged data, Time and Value  (two fields)
TIME                   VALUE
01/01/05   11:00:08    1.33763
01/01/05   11:00:16    1.33238

I'm sorry if I am appearing noobish, but I'm a C programmer that
inhereted access because I'm the only "computer guy" in the office. Now
I've found some problems that I fear maybe a corrupt database.... and I
haven't the faintest of clue where to start when it comes to fixing

I would like to create a summary report based on a "Type" field in my
table.  I would like to create the following report:
Type 1        Total Balance                    Type 4        Total
Balance

I am trying to create a access database that will allow a "user" to
login, and only view/change only the material they have entered.  Also
allowing a administrator to view all the data, and create reports from
them.  Any good ideas? I kinda of had an idea of creating a seperate

I have been given the assignment at my office to create a library for
various articles, mostly in .pdf format.  Storage is not the problem,
but I would like to create a database that would allow me (or perhaps
others) to search through the library by author, title, subject and

I have what I believe amounts to a Date Serial issue.  I have the following
columns in my table:
Hire-Date
Hire-Year

I have been comfortable debugging VBA modules using Access 97.  I recently
acquired Office XP and converted my applications to Access 2000. In general
they seem to run fine, but there's a bug in one (which may have been there
before conversion).

I have a simple database that is used to track experiemnts in a
research lab.
I make it compact and backup each night, but when users leave it open,
that fails.

we use Access 2000 with linked tables in SQL Server 2000.  I have a
form and a
datasheet subform based on a table.  This was not related to the parent
table before and I was changing nvarchars to varchars and removed

What is the best way to create a form that requires users to input
Username
Password
Then, it checks a table containing these values, verifying their

i am trying to calculate the efficieny of a work group
case 1
a group has 1 hour as available time
The group have a target of 100

I'm trying to create a database, thought I knew how I was going to do
it, and found it won't work.  Hoping some expert on here can steer me
along the right path.
I need to provide my users with a form for data entry.  My hierarchy