Numeric overflow

[slimjen]

Hi all, using access 2003. I put my database on a shared drive. Split database and using front end. I have an import form to import excel spreadsheets into my database periodically. Worked fine when it was on my c: drive. Now that its on the shared drive; I get an error: Numeric Overflow!. This is an important function in my database. Please help me resolve this issue! Thanks

[orange]

If you're using 2003, why does your profile say 2007?

Do you get this error on the ImportErrors table?

[slimjen]

I created the database for users that only have access to 2003. I don't have an importerrors table.?? I just ran the same form in a copy that is not split and it ran fine. Why does this make a difference??

[orange]

Many people use the Import Wizard to import data. It creates a Table (ImportErrors) and identifies the row, column,error etc.

Do you have some error handling logic in the code? Perhaps you can adjust the code topick out which record(s) is failing.

My guess is that a field is defined differently, eg Integer with a large value giving Overflow.

Can you verify that the table columns are defined exactly the same on both databases?

[slimjen]

i will double check. I do have error handling in my code. I have 4 numeric fields set to currency. Should I change them to long instead of currency?

[orange]

I have acc2003, can you provide a sample mdb? And the file to be imported.
Remove anything confidential.

[slimjen]

If you want but it only happens on the shared drive. I can run it on my c: drive all day long without errors. I just put a copy of the whole database on the sharedrive; not splite or mde and it ran fine! It doesn't like the be and fe being split???

[orange]

I think you have rediscovered an old error. I did some research , you can see for yourself.
http://tinyurl.com/6885rfa

[slimjen]

I'd say you're correct again Now; do I make the temp table I'm using to import my excel files local and then hope that it won't error when I append from my local to the permenate linked table?
Thanks

[orange]

I can't answer that with certainty. The posters in the link did not report back that I could see. That's the approach I'd try.

[slimjen]

Ok. I will try this and report back tomorrow. Thanks so much!