I know this has been posted before, but I'm damned if I can find it, and
searching for "custom properties" and such on the Internet is like searching
for a specific type of hay in a haystack.  Can someone please re-post the
code to remove Access' custom properties, such as Column ...

I want to create my own SQL Server 2005 Express backend server with Access as
the front end.
I have a three computer network behind a firewall router.  Two machines are
XP pro with the Access front end, and I added a third machine that is W2K pro

I want want to create Form and write code to connect to SQL Server by
myself. I don't want to use built-in login form.
Thanks,

I have an Access DB that prints an Report using data in a table, then have
an image (.TIFF) that is printed behind it using the location on our server.
(i.e. C:\Images\Invoices\Week12\12345.TIF)
Let's say 12345.tiff is a 5 page document, but I only want to print page 2,

I'm new to SQL/ADP and have been having a hard time getting an UPDATE sproc
to work.  Here's the scenario: I have a form (frm_EncounterCreation) that a
nurse fills out with patient info.  There's a command button at the end that
produces a fax (using WinFax) for the referring ...

I have an ADP database connected to a SQL Server database.
I need to export/import data from a table to Excel.
I use the following code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,

I am trying to create an Access Project using Access 2003.  I downloaded and
installed SQL Express.  I opened a new .adp, but cannot seem to get a
database started.  When asked what SQL server to use, I enter “(local)”, but
I get the error message “SQL server does not exist or ...

I often update the .ade file (connected to MSsql) in a file sharing server
so that the users can download a copy. The updated file always has a new
name (ex. V.20061120).
I was wondering if there's a way to notify a user when a new version is out.

I need to use Access and ODBC to insert text into a linked SQLServer
2000 table
Currently I'm using an unbound
form control and an append query("insert into ....").

I would like to start a new application which should be used more or less by
250 users simultaneously.
Should I try adp's with some version of sql 2005 or  should I put all on asp
application?

I've noticed this problem a few times. I'm using SQL 2000, with an ADP
report based on a view. One of the report text boxes will display incorrect
data.
For example, yesterday  the BuildingHeight was on the report was 10. When I

I am a student in desperate need of help with a project for school. I need
help running some queries using SQL server 2005. I understand some
fundamentals of SQL but am still struggling getting a better feel for it. I
am learning disabled and it is difficult for me to learn as ...

The last days, I was thinking about how to implement Security for my
ADP application.
I was searching this group a bit for best practices regarding security,
but unfortunately didn't find very much. The most interesting threads

In an mdb, if I wanted to report by dates, I would do the following
stCriteria = "BETWEEN #" & Amer_Date(me.txtStartDate) & "# AND #" &
Amer_Date(me.txtFinishDate) & "#"
Amer_Date is just a function that changes the date to an American format.

Greetins all.  Suppose I have a table with two columns 'A' and 'B', where A
is a job# and B is a product.  Is there a way to query against the table and
show all products in column B on a single line with the job# in column A
listed only once.