Invalid Argument Different for FE/BE

[tighe]

I know there are a lot of questions about invalid arguments but i cant quite
find anything like this.

in my BE i imported and created a table from A tab delimited text file. i
then linked that table in my frontend. if i import the file to the front end
into the lined table, files a re released about every two weeks, i get an
"invalid argument" pop-up but as far as i can tell all information is
imported. if i import the file into the back to the table i recieve no
pop-up but if i try to save the import i recieve " property not found."
earlier i think i got an index error on trying to save the import to the back
end.

can anyone explain/suggest what i can do to correct this?

AC 2007/XP.
on a similar note i have this table/import functioning in a mdb DB.
intially i copied its table over to the newer Db but with all the errors i
started over but now with a newly created table etc., i recieve the same
issues.

not sure what other information to give.

thanks in advance.

 

[Gina Whipp]

tighe,

See if any of this applies to you... http://support.microsoft.com/kb/826763

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[tighe]

Gina,

thanks for the reply. some of the data had "&" but after removing it, it
still returns "invalid argument" in the FE, the BE has not error. the same
data works in the 2003 mdb file i used to use for this operation.

 

[Gina Whipp]

tighe,

Next thing I would check for is Reserved Words, Access 2007 is alot more
picker then previous versions...
http://allenbrowne.com/AppIssueBadWord.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[tighe]

Gina,
thank you for your continued efforts, with everything you suggest, the
anomalies i see, change, and still get the error but the data imports, i
guess i just want to supress the error, any suggestions? do think i shoul
post a new question in programming?

 

[Gina Whipp]

Tighe,

Actually, you can crosspost... I fixed that so it now also show up there.
HOWEVER, I wouldn't want to supress an error until I know why and what is
causing the error. Are ou getting a Error table that nets any valuable
information? ANd which error are you getting now?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[tighe]

the error is always "invalid argument" on the fe only, after the table is
created, no matter what changes i have tried to data or table design. there
is no error table created.

 

[Gina Whipp]

Tighe,

Can you type here a few lines of sample data... I need to attempt to test
this.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[tighe]

thanks for staying with this, hope the tab format comes through ok, i just
copied and pasted
tracking_number business_name dba_name number number_type incorporated street city state zip country phone
114049 BLUE GEAR 3225 BERGENLINE AVENUE UNION CITY NJ USA
114049 MASTER CLOTHING 1149 BROADWAY NEW YORK NY 10016 USA
114049 SAMAR CLOTHING 215 WEST 18TH STREET SUITE 1F NEW YORK NY 10016 USA
114049 Y & K MERCHANDISE CORP 8 WEST 28TH STREET NEW YORK NY 10001 USA

 

[Gina Whipp]

Tighe,

I see there are still some Reserved Words used as Coulmn Names... *number*
is one. Try prefexing everything with an x or something. I didn't have any
problems but one never knows. Also, make sure Name Auto Correct is ticked
off.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[tighe]

I tried "numbertest" and still "invalid," at this point i think i am going to
have to just put up with it since it imports anyway even though it tells me
it doesn't, o rjust open the BE to import with no error even though i cant
save the import.
could i write code to have it import to the BE, started from the FE, it
imports there with no issue. i did a quick search but didn't see anything.

for the Name Auto Correct, as long as you are referring to the current DB
Options, i don't have "log" checked, Track and perform are checked.

 

[Gina Whipp]

Tighe,

Track should be unchecked... and I wish it made sense. Yes, you could write
code to import to the back-end and append to a table then have that table
linked in the front end. When you say you did a search, were you looking
for code to import or a way to run that code from the front end?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[tighe]

Gina,

i think we are al set, created Transfertext for each file type and no
issues, thanks for your continuing efforts.

 

[Gina Whipp]

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm