I would like to keep in each record of table in access project the Windows
User and Compauter Name that has created the record or modified the record.
I will write the code in form properties on an event.
Thanks in advance

I'm facing troubles refreshing my databaseconnection.
I'm performing an import routine, part of the routine is dropping a table
and next recreate the table with some other fields. This is simply done by
pushing a button executing a procedure.

After installing Service Pack 3 for Microsoft Office 2003, a database we use
begins crashing for no reason when we attempt to open some reports. After
uninstalling, and reinstalling without Service Pack 3, the database's reports
work as they always have.

I'm reasonably proficient in writing my Access queries in SQL (in a .mdb
file), and obviously I'm aware of the 'quirks' in Access SQL syntax.
Now I'm beginning to explore an .adp to the sql server at work I'm aware
that I need to use different sql syntax to that used in an .mdb

Can anyone help me.  Let's say I have an Alias field (resulting from a
calculation) in a stored procedure, how do I reference that alias again in
the same procedure?, assuming I want to use it in another calculation.
Any help greatly appreciated.....Rgds, Jason

I have a potential customer who I demonstrated my software to that seems
interested in buying. But, my software is using SQL 2005 Express and this
client already has a full version of SQL Server 2000 installed and would
rather use that than 2005. I told them I was 99.9% sure ...

I have a working stored proc that returns alpha list properly when given
first character.  I want to use it as row source for a combo box.  This code
doesn't return anything.  Where am I off?
Private Sub txt_FirstLetter_KeyUp(KeyCode As Integer, Shift As Integer)

I just demonstrated our MS Access XP (ADP) software that connects to SQL
Server 2005 software the other day to a potential customer.
They happen to run a Macintosh environment and then run Windows Terminal
Servcies so they can run Windows applications on these machines.

Access 2003 adp project, SQL 2000 backend. When I click on certain
tables to view their data, I get the message "The stored procedure
executed successfully but did not return any records".  Subsequent
clicking results in nothing at all, not even the message.  The tables

Hi - I have a MS Access front-end with linked tables to SQL back-end.  The
link is working properly, but every day when I login again I get an error
that says "ODBC--connection to SQL Server' failed.  This only happens after
about 12 consecutive hours without having Access open ...

With some great help, I am getting my upsized adp working.  Now here is what
I need next.
The adp is named PM.  Another mdb named RP needs to append data from 6
tables in it's linked mdb database to the PM SQL database.  It is also

I have an ADP Access frontend (to a SQL backend) that only seems to allow 1
user in at a time for the purposes of adding or editing queries, reports,
etc.  In an Access MDB I know that under Tools-Options-Advanced, I can
specify Default Open Mode (shared or exclusive), but I ...

123

I know what I'm about to post is probably outside the scope of what this site
is intended for, but I have no idea where to turn at this point. I have an MS
Access 2002/XP ADP application that connects to a SQL Server Express 2005
database. I have over 1/2 dozen customers who I ...

The combobox in a form triggers a report (bound to a stored procedure) and
the option File -> Export allows the report information be sent to an Excel
datasheet. In my ade application, the export option is disable so I'd like
to obtain the same function as the adp file via a ...