Its quite east to run a DTS package from Access

Const SQL_DTS_ERROR = -2147220440

Public Sub RunDTS(strServer, strDTSName)

    ' Routine to run a DTS package from VBA

    ' Process will halt if...

I do this every week, I use an Access project FE where I use ADO code to convert from columns to rows. Try not to refer to your columns directly...

Hi,

When you receive this message check the folder where the .mdb resides and check if there is the corresponding .ldb file.

Sometimes on networks when an access db closes or even...

Have you tried truncating the table instead of deleting the rows. If you try to delete a row without a primary key you may experience problems.

Hello,

I've just linked an SQL table with 49,000 records to an Access 2000 db, created a query, set up a form with a combo box using the query and I...

Hi,

One of the problems with total queries is displaying information that does not take part in the actual grouping. Use a two stage approach. use the query above  in another...

If you had to use Access, then you will require a table containing either the Date Last Extract or all the dates of extract (and a query the extract the...

I hate it as well, So I udge the window up a bit until it's gone and sideways if there is a an animated advert to the side of the...

I assume you are using Access 2000 projects as a front end if so then this technique works for me.

I use a VBA function with a static variable and increment...

I see age calculations using a simple datediff, however how many of you have tested it. For those people whose DOB is between today and 31th Dec the age will...

One other solution is to use an Access.mdb file for each table, so long as each table does not exceed 2gb. Then link them into one database for processing. But...

Hi Scott

An Access Project has all the reporting power you require. Either convert your ADO code to an SQL statement and use that as the recordSource for the report or...

Hi,

Enter the name of the paramete in the InputParameter property of the report.

Here is an example

Forms!frmReports!txtYearMonth

in the reportDatasource enter the name of the usp

when the report opens it evaluates the...

Hi jenni

If you used SQL and Access Projects you get the best of both worlds. The ease of development using Access and all your vba code can be re-used. Although...

I do this all the time, however as a programmer I link the tables to M$ Access 97/2000 and write a procedure to perform the conversion. - Far better than...