Run-time error '3349'

[wpppat]

code DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Import", strFileName, True, ""



Import stopped working when I split the database.
This willbe a multi user application but sohould some tables be with the forms? Is this even customizable?

[pbaldy]

What is the text of the error? I have that type of code working with split databases, so I don't think it's that.

[rzw0wr]

Error 3349:

You cannot record your changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again.

http://www.fmsinc.com/microsoftacces...ption2007.html

I am not sure and just making a guess.
Splitting the db removes the actual tables from the db and puts them in another database.
Looks like the code is trying to put the spreadsheet into table "Import".
Try making an empty table named Import.
If this works then you will have to give the above code the path and name of the BE where the tables are.

Dale