Hell All,
My database has 3 tables Client, Devices and Job
Client and Device has One-to-Many Relationship
Client and Job has One-to-Many Relationship

To scan through a table and edit values I can use OpenRecordset with:
1. Dim rst As Object etc., or
2. Dim rst As DAO.Recordset etc.
Is there a performance difference between the two or are there reasons why I

I just installed MS Access 2007.  Is there any way to turn off the
confirmation of action queries in 2007 ?

I am looking to replace the navigation buttons at the bottom of a
subform with tabs.
I want the tab control to automatically create a tab for each year for
which a record exists.

Am having a problem usink AK2 exporting a report to an RTF file. The Access
report has most fields and sections set to CanShrink and CanGrow. The report
looks fine, but the ends of a number of fields get cropped. Can export to a
PDF file OK, but I can't edit a PDF file.

I have a report that I have been working on.  It depends upon a query,
which depends upon two other queries.  Everything was working fine, I
verified the report worked, saved my work and exited.  I later came
back, and now I can not even open up the report in Design View.  Any

I have an Access 2000 database split front back end, what I want to do
is have some kind of web based front end so users can logon via the
internet and:
1. Enter new records, edit records in the database

I need a recommendation when to add a record to a junction table that
complements a many to many relationship.  There will be a Contacts
form, and an Interests subform with the parent/child field being the
ContactID.

I'm developing a tool that creates a spreadsheet, writes data from
several Access queries to ranges in the spreadsheet.
That part works.
What I need to do now is format the ranges, so that I can set

Back in August I posted the following:
I'm seeing the following problem in a database running under Access
2007 regardless of if it is Access 2003 format or converted to 2007
format.

Is there someway to tell who has the *.DB open on a network?

Note: I'm not sure if the subject line of this post uses the correct
terminology, so apologies if the subject line turns out to be
misleading.
I think it's probably easier to provide a trivial example to

I have downloaded a great pop up calendar (that doesn't use ActiveX
Controls) from http://allenbrowne.com/ser-51.html.  Actually it
onvolves downloading a sample database and then following the
instructions:

Is it possible or feasible to load one version of Access (2003) and the new
version (2007)  on the same hard drive and run appliecations on each one
separately ? If you can, how do you load the new version (2007) on your hard
drive?

Good afternoon everyone,
I have created a very robust front end for my backend database that is
essentially an all-round office database used for nearly all non-
accounting transactions. I have decided to keep my front end database