how do I debug access script?

[Guest]

I have a database that someone else created for me and then went on
vacation...When I attempt to upload data from a selected file, i get runtime
error 2391 Field F2 does not exist in destination table. When i pull the
table and do a find, there are no results...

 

[Guest]

The name of the field can be mispelled in the code.
Open the table and see if you find any field named F2.

Rocco

 

[Guest]

Tried that, no luck.

The name of the field can be mispelled in the code.
Open the table and see if you find any field named F2.

Rocco

 

[Guest]

If you meant you didn't find any field named F2 well the trouble is that!
The code is trying to pull data in some place that doesn't exist.
If you know which kind of data the field will receive (ie. date, currency,
number, string...) you can try to add the field yourself by opening the table
in design view (righclick on the table and choose design view).
Rocco