I ahve a tiny little Access 2000 project that I worked on years ago for
someone and he recently asked me to make a couple of minor changes. I
noticed that the tables still have subdatasheet set to Auto and I went to
change them to None but they won't stay. When I save the tables ...

Good Afternoon,
Is there a way of changing the path that the front end of a database uses to
locate the back end? Basically I am having trouble because on some PC's the
path to the backend is different due to naff network mapping......

I recently split my DB into a FE and BE. When I distributed the FE to the
users ....there was a complaint that they can't see the links between tables.
They were used to going directly to the table Entering the data and then
clicking the linked table and entering data into that ...

I recently created a set of replicated tables to store financial planning
information.
According to good database design I created one table with this schema
mID, mCaseBranchID, mLineID, iYear, sValue

Access 2000 w/ jet backend.
This client of mine runs the app in a pretty harsh environment. Long cables
(and poor quality ones at that), no boosters, very hot temperatures (the
air, not the employees, LOL) and impatient operators. Some time ago I

I am hoping someone can help me with my junction table issue.  I have two
tables and a junction table already set up, and now I need to figure out the
best way to enter the information in a form/subform.
I have a "supplier" table and a "product" table.  I have a "supplier_rates"

Since i am new to all this access stuff i have been tending to create new
queries everywhere i need them instead of just creating stand alone queries
(in the database window) and referring back to them...
For example every form that uses a employee name combobox will have its own

I’m using Access via XP Access Pro running in XP Pro with SP3.  Please note
that this question was posted in both the Database design and Form coding
forums (if I did it right).
I am donating my services to a homeless charity.  They have about 80 homes

I have 2 tables (Registrations and Courses), where each table has a Primary
Key with a data type of Autonumber (RegID and CourseID). At some point within
my DB, I need to add the PK from the Courses table to the Registration table
which causes problems (only 1 Autonumber per ...

This may take a little to explain, but I hope I can get you to understand my
setup.
I have a sub form which shows a list of records assigned to a user. This list
is filtered by selecting a person from a combo box on the main page. I used a

I am making a timesheet database for our non-profit organization with the
tremendous help of MS Access MVP's-THANK YOU!
Employee's are allowed to bank overtime hours, but they must be used within
a calendar year, and consequently, when banked hours are taken out of the

Is it possible within a DB to only allow certain buttons to be visble or
active for certain users?
I'm assuming this would all have to be Username and Password related.
Thanks.

Hi
I have a lookup field where I want to select any field from another table.  
currently I can display each field but only select from one.  Ultimately what
I want to do is create a form where I select from a catagory which links to

is there a method, in the back-end file, to log that a value (any value) in a
record was changed? - - adding a new field to the table just for this purpose
is ok.
I can easily see a method if one can put vba in the front-end form that the

I have an application (currently 1300kb file size), built from Access2000.
Whenever I add New record, the last (added) ones will be 'gone' (missing from
table).
Anyone had similar experience ?