accesss error run time error '3078' (1 Viewer)

[murray83]

this is driving me crazy

i have no table called import or any query's

please help

 

[murray83]

feel like a right idiot

the import was from my dlookup how ever i have changed it to look at the table called main now gives following

Run-time error 3464

data type mismatch in criteria expression

 

[NauticalGent]

Is you DB split and if so, are the BE tables on a shore drive or sharepoint server? Mine are and I get this error when I drop connectivity...

 

[NauticalGent]

feel like a right idiot

the import was from my dlookup how ever i have changed it to look at the table called main now gives following

Run-time error 3464

data type mismatch in criteria expression

Check the field types.

 

[moke123]

also check your delimiters for text,dates, etc.