I have established an ODBC connection to a remote database (SQL), via a vpn
connection.
Using this ODBC driver, I have been trying to link tables from this
database.  In doing so, the links work OK (the tables are linked, and the

When I added holidays to my calendar, the dates on the holidays were from
1998 thru 2002.  I would like to add current holiday dates for the year 2007
and beyond to my calendar.
Thanks for your help.

I have a delimited file w/o column headers organized as follows:
123456789 2006/10/16 09:37 PtSSN 123-45-6789
123456789 2006/10/16 09:37 PtAge 61
123456789 2006/10/16 09:37 PtDOB 01/01/1990

I issued the following command.  The query extracts data from a table with
58,000 rows:
DoCmd.OutputTo acOutputQuery, "qryTT_tblTT_DataExt",  acFormatXLS, “C:\
TT_Data.xls", False

I have a tab delimited text file that is organized without column headers as
follows:
123456789    2006/10/16    09:37    PtSSN    123-45-6789
123456789    2006/10/16    09:37    PtAge    61

I have already set up tables in access and want to import specific named
ranges into specific tables. The "show named ranges" option doesn't show the
named ranges I created and the ones it does show, the Microsoft jet database
engine can't find. It says to make sure the object ...

In Access, Everytime I try to open this dbf it says "microsoft jet engine can
not find object." However, i know nothing wrong because i can open it in
excel. But the file has too many records (>65k) so I bought Access to solve
the problem... but now I cant open it.. Help?

I am using MS Access 2002.
MS Access tools/documentor for tables should allow the option of printing
not only eachfield's name, type, and size, but also the description from the
design view.

When I import an Excel list to Access database through the Import wizard, I
can see the Data type combo in the Import wizard. However I can't change it.
Can I change the data type when importing an Excel list to Access database?

Why won't my email send with an attachment 12mb?

i must be going cross eyed after looking at this for so long...  given the
source xml doc:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<root>

I am setting up a database from scratch and importing from an excel
spreadsheet.  I have set up tables in access and want to import named ranges
into specific tables. The first hitch is that I don't have a way in the
import wizard to specify the named ranges, even though that ...

I have a user that is trying to import spreadsheets created in Excel 2003 to
Access XP (2002) SP3.
On the forth page of the import wizard you can change your column headings.  
When trying to import these spreadsheets she can only change the heading on

To save the cost of coloured ink, I asked a friend to "turn off" the colour,
and only print in black ink. I now want to turn the coloured ink cartridge
back on. How do I do it? I would really appreciate any help.

i want to have a master table that links to several other tables in my
database. i can have this table from another database (link tables), or
directly from the txt file (since the table is updated regularly by importing
the data in the other database) by the link tables option ...