How are all doing? Hope all is "Acce-xellent".
I am going to split my Access file to FE and BE and convert the FE to
MDE format.If I have 5 users using the program, do I make 5 copies of
the MDE for each of the 5 users to run from their own directory? Or

I'm new to mde.  The previous coder made a mde front end with a backend of
tables.  Now I have to put a drop-down on one of the forms.  I have the clean
version of the mdb.  I added the drop-down to the form and added the table
change to the backend table.

Does anyone have any access functions for quickbooks integration, or have a
link with access examples for some basic importing / exporting?
Many Thanks,

I'm using Access 2000. I have a raher simple database of my CD collection, with
just three fields, Artist, Album Title and Type of Music. While going to update
it today with a couple new CD's, I noticed that if I sort alphabetically by
Artist it have 387 records but if I sort by ...

I would like to setup a validation rule for a database in microsoft
access that restricts data entry so that a certain field can only be
filled in if another field has a specific answer (that is selected via
a drop down list).

Hi,
Have you checked your database? Maybe you need to replace your mdb file
with a backup. If there is no backup, try to compact and repair it or
try some tools such as Advanced Access Repair. I have used that tool to

Doesn't look like Access 2003 has many date functions or a character
to date function.
Any ideas?
Thanks,

My query successfully returns every 10th record between a beginning
date and an ending date.
How do I remove the "Enter Parameter Value" dialogue boxes when I run
my query?

Can anyone offer me any insight on the following problem?
I have an Access database on a company shared drive.  I'm the designer and
the only user (so far).  Suddenly, any time I try to open a table, Access
crashes... but if I look at that same data by *querying* the table (SELECT *

Does the worksheet have to be exported to a CSV file first or can
Access import directly from an Excel workbook (.xls)?
Thanks,
-paulw

Re: Access 2003
Is there a way to list via text (or set via VBA) the items in the
Tools/Startup (App title, App Icon, Display Form Page, Show DB Window,
etc.)  as well as items in the Tools/Options Tabs: (Advanced, View,

I have a query that calculates the average  for the year
i group the data by month
i have 2 values for April and may
April = 1908

How would I get these values in Access 2003 from
"cashregister05012008.xls":
cashregister
05012008

I'm using the following Visual Basic code to open a report and set the
value of an unbound text box in its page header.  It works... but only on
pages other than the first one.
  DoCmd.OpenReport strReportName, acViewPreview, , strWhere

For AccessXP when importing objects from one database into another
databse if the object exists the import will create a copy of that
object and stix a 1 or the next available nbr at the end instead of
overwriting the existing object.