TransferSpreadsheet 2003 and 2007

[ahabrendan]

I am going to try and explain this in detail.
I have a database I created in access 2003.
This database pulls in text files and then reformats the files and
splits them.
It splits them by creating queries via vba code for export.
The query is exatcly the same fields for each of the pieces of data
it
needs to export.
Althought the criteria is a little different for each piece.
I then execute the statement docmd.transferspreadsheet qdf.name
It does this for all of the files that I need to export.
Although it stops with one of the queries and I get a parameter popup
window.
If I debug and try to run that line of code I get an error 3207
reserved error.

Now this worked for over 2 years in 2003.
We recently upgraded all of the users of this database except me to
2007.
This also worked for a few months before I started getting this
problem three days ago.
Now this database is setup as follows:
I have a front end and a backend.
I have left the backend database in 2003, and the frontend is located
on the server as a 2003 database.
The user of the database runs a batch file that will always copy of
the database from the server and then starts it.
So basically the user is running a 2003 database from 2007.
Like I said this all worked up until three days ago. (from 2003 and
2007)


Any help would be greatly apreciated. TIA

 

[fez]

Is the parameter popup window asking for a column name?  You may have
misspelled it in the code, or applied the wrong table name to the column name,
like customers.lastname instead of employees.lastname.

You can get error 3207 when

1 - cannot update: database or object is read only
2 - the file name extension is non-standard
3 - the export spec is wrong (doesn't apply to transferspreadsheet, only
transfertext)

Does that help?

Chris

I double checked everything.
Everything was working up until 10 days ago and I did not change
anything.

I did find a solution to this that works.
I put an If statement where the DoCmd.TransferSpreadsheet was.
If the Application.Version = 12 then
DoCmd.OutputTo ...
ElseIf Application.Version = 11 Then
DoCmd.TransferSpreadsheet...
End If

I checked that in both versions and it seems to work.