What kind of recovery modell do you use? If full (as set in options) the

transaction log will grow and can be huge. Choose simple and then shrink the database...

Why use DTS or Access at all.

I do a lot of extractions to text files from different data sources with ADO and SQL and VB. There you can open a...

I am not so familiar with VBscript but have made something similar in VB 6.

The script can read a text file with a user defined field and row delimiter

and print...

Having about the same problem this might help:

select substring(Firstname,2,len(Firstname)) from dbo.sellers

The first character can be anything.

Hi,

I used a similar approch as above:

1. Create a Execute SQL Task connection SQL server and a global variable like Maxdate.

2 SQL looks like select max(date) from etc

3 Execute this...

May be this can help:

If your Access database is on another server, you will need to ensure that Jet 4.0 is installed on the remote server, and that you know...

Hi,

There is another way to solve the need. The formula can then be in its original form =A3+B3  in column 3.

You can run an Excel makro...

Hi,

I had the same problem and one way to solve it is like:

Dim cnx As ADODB.Connection

Set cnx = New ADODB.Connection

Dim cmd As ADODB.Command

Set cmd = New ADODB.Command

cnx.Provider = "sqloledb"

cnx.Properties("Network Library").Value...

Hi,

I don’t have a template or an application created sole in Access. What I have is an application which use...

Yes I did (by misstake)

The default recovery is full and switching to simple is good in

this case. Now I could shrink the database and will use simple.