I am making a password change form for my applications. I'm using the access
built in workspace users and groups for my user functionality. So far
everything has been working perfectly up until now. It probably a small error
but I cannot seem to find the problem.

I got Microsoft was Access unable to create an MDE database error.
It mentioned that it is usaully associated with compiling a large database.
All tables are links tables. There is no local tables in the MDB file.
There are 27 links tables

Do I need to refer to the outside dB twice or is this ok?
Thanks
DS
AllSQL = "INSERT INTO tblTransferDetails (IN '" & REDACT() & "'" & _

I have a database called "ProjectReport", it consist of project data.  Some
of the data is very old and needs to be archived.  I would like to be able to
select a record and use a button to send it to a database that was created to
house archived records called ...

I have a main table for EquipmentType, with a child table for EquipmentItem.
The equipment is identified in EquipmentType by department code and an
incremented number.  Equipment for the machining department is numbered
M-0001, M-0002, etc.  For welding, W-0001, etc.

I have successfully used Allen Browne's method to use a combo box to find a
record many times, it is excellent.   Thanks Allen.  But I was wondering if
anyone could help me with some code to do the same, but on a sub form.
Database structure: One program has many projects.

(Access 03)
I have a form with a page object. The page object has some  8 pages. Each
page has a sub form. I've linked some of the textboxes on the first page to
be able to have consolidated information as the first of the 8 pages.

How do I set a form to automatically copy the data from a physical address
field to a mailing address field on a form when I enter the physical address
information if the mailing address information is currently blank?

I hope I didn't post this twice.  If I did just ignore, I received a strange
error that the other one didn't go through.
I'm getting a syntax error here, any help appreciated.
Thanks

Can't find the Error!!
CurrentDb.Execute "UPDATE
[;DATABASE=C:\ProServ\Utility\DataSafe.mdb;].tblEmps, " & _
           "SET tblEmps.EmpFirstName = " & Chr(34) &

I have a table that contains student data each with a parent mailing addresses.
One of the fields in this table identifies a house-hold (can group multiple
students)
The data across a household is maintained in a mainframe system and this

I need to create a macro that will allow me to move old information
from my current up-to-date information into another table.  I need
help can anyone help me program my database to automaticly move old
information?

This might be so simple that I am completely missing it. I have a form with  
a list box. I have populated this list box with the shop floor resources
using a query. I have it set to display one resource at a time and the user
can only select one resource at a time. This is ...

I would like to display my result on a dynamic SQL query not in Access rather
directly in Microsoft Excel. However I do not like to safe the file or ask
the user where to store it. When I run the query and display it the simple
solution now is to click the "Export to Microsoft ...

I'm working in a form, container filtered data from a table.
I have collected data from the clipboard and want to go a new recordset to
insert the data from the clipboard.
Is there a way to reach the new recordset and then insert like