I have found one indication of a problem when I run this application.

On the server that has the SQL2008 DB that I'm writting to, I notice that there is a...

This can be done fairly easily in Access as well. I am including an Access db with a single query to do this.

I agree with glen.wass that the easiest way is to do what he suggested and you may need to include a check to see if it is week 52 of...

SKYBVI (6/10/2011)

---

Don Urquhart (6/10/2011)

---

SKYBVI (6/10/2011)

---

Don Urquhart (6/10/2011)

---

It looks to me like you are inserting only the ITEMNUMBER field, with no values for the key fields (tcsFLST_AttribGroup,[tcsFLST_ItemAtrib) which can not be...

SKYBVI (6/10/2011)

---

Don Urquhart (6/10/2011)

---

It looks to me like you are inserting only the ITEMNUMBER field, with no values for the key fields (tcsFLST_AttribGroup,[tcsFLST_ItemAtrib) which can not be NULL. You need...

It looks to me like you are inserting only the ITEMNUMBER field, with no values for the key fields (tcsFLST_AttribGroup,[tcsFLST_ItemAtrib) which can not be NULL. You need to have some...

From the file name, I'm assuming you are using JD Edwards, which we use.

In our setup we have to journal the file that we are uploading to in order...

I think it is because you are specifying a provider string but have not indicated the driver type. For instance if it is a SQL linked server you might try:

SELECT...

Thanks,

I will definitely remove the TOP 100.

The reference to the temp. table I modified to match the uploaded data table name. The real table is in the actual view, with...

Hi Jo,

I am attaching a small sample of the data (100 of 10 million+).

I'm not sure what query you are requesting but in Access it is just a simple...

Yes the query is good. I have tried rebuilding it, building it on a different machine and database, relinked the table, and deleted it and recreated it all from scratch.

As...

Thanks Sergiy

I agree it is not the smart thing to do to make the user a sysadmin, especially in this case, and we have found a way around the problem...

I can't believe no one can solve this for me as I thought this was the best site.

I really need to resolve this issue for an upcoming project. Any help...

Found the problem. The regional date settings were in conflict in that one of the long/short formats had m/d/y order and the other had d/m/y. Guess it just struggled to...

If you set the Enabled for the page to NO you could do something like this, assuming 2 pages:

Private Sub tabControlRiskForm_Change()

If TabControlRiskForm.Value = 1 Then 'value...