When I delete a relationship in relationship view.  It seems to keep
reappearing in a query.  I've tried a "show all" in relationship view
and even emptied out the whole relationship view to insure NO
relationships exist.

My report width is stuck at 22". I can't make it smaller. There is
nothing that is interfearing with me decreasing the width...is it a bug
in access 2000?
Thanks

I am trying to add multiple subforms (or subtables?) on an existing
form.  The underlying table is a very detailed descriptive table for art
in a collection.  I am already using one subtable to manage the movement
in and out of inventory. When I look at the table in the datasheet ...

Im grabbing tables via VB code using visual foxpro ODBC drives.
The tables directory is in a mapped network drive. The code works fine
and does the job, however if the computer is idle for a while the
network drive apears to have a red X on the icon and the drive becomes

I have experimented with the routine to prevent access from closing using
the module authored by Dev Ashish to be found at "The Access web" site.
Whilst this seems to work, it is not exactly what I would like to do.
My database has an Exit&Backup routine called from the exit button ...

I am working on a cars investment tracking database and need some help
with structure
You have investors, who pass the money to company the money in turn
purchase cars, sell, and return profit plus capital to investorsy,

I've developed application in Access XP that has FE, BE configuration (BE
over 50 tables). New version of  the program has similar but different BE
structure.
Is there a way to export data from old BE and import to new version on a

I have newly acquired Ms Access 2003 after working for a number of years
with Access 97.  In that edition I used VBA quite extensively for updating
recordsets under DAO protocols.  Now I find that DAO formats don't work if I
construct them in this edition of Access.

Our database, an inventory/order system in ms access 2000, is working
just fine.
However, the other day, one of our employees suggested that it should
be possible to do some advanced work on the tblCustomer.

     I automatically shut down every PC that is logged into my Access
2000 database at a time that is set on a configuration screen (Around
02:00 AM) . I do this by checking Now() against the ShutDown time about
once per minute in the main menu.  This works fine unless an error

Is it possible to use a database developed in  Office 97, and upgraded to
Office XP on a machine running Office 2000
TIA
Stephen

I use this to test if a user has left a text field empty:
If Me.txtProductID = "" Or IsNull(Me.txtProductID) = True Then
 do something here
End If

I've read some posts indicating that having tons of GV's in
an Access app is a bad idea. Personally, I love GVs and I
use them (possibly abuse them) all the time for everything
imaginable - have been for years. If the machine has memory

I'm getting the error message "The data has been changed. Another user
edited this record and saved the changes before you attempted to save your
changes. Re-edit the record"
This is the code that is causing this on the Before Update event.

http://blogs.msdn.com/access/rss.aspx
is an RSS feed of this blog. It's quite handy to use it in an RSS
handling client such a Thunderbird or Firefox.
This morning there is new article. (Access Demos from the PDC)