A
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
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