Great !

hopefully now you can determine what control sources to use...and dispense with the wizard (it has its uses but I used to abhor it :-P)

kind regards

I am assuming that you can see the tables from Access (accdb or adp?)

just an idea....what happens if you use the form wizard to create a form based on...

Welsh Corgi (1/7/2012)

---

J Livingston SQL (1/7/2012)

---

from readme.html....default install path...C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data

""In the left hand tree control of the Enterprise Manager SQL Server application, expand all nodes until you...

As I have said earlier...and for the record

I haven't had any issues before now...and this occurrence ONLY materialized on a memory compromised PC....it has never occurred on our servers.

The reason...

from readme.html....default install path...C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data

""In the left hand tree control of the Enterprise Manager SQL Server application, expand all nodes until you come to the Databases folder...

Welsh Corgi (1/7/2012)

---

Yes, thank you very much. I sort of thought that but I wanted to make sure.:cool:

What if you create a report...

does this shed any light...

http://jessicammoss.blogspot.com/2008/07/where-is-my-data-tab.html

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4385

Have you got a "Tally" table....its then very easy

http://www.sqlservercentral.com/articles/T-SQL/62867/

SELECT TOP 100

Row_ID = IDENTITY(INT, 1, 1),

Row_value...

can you please provide more info

Access version...03/07.10

mdb/adp/mde etc

assuming you are "pushing" data to SQL?

how are you connecting to SQL?

the VBA code you are using

any start up parameters in Access?

take a look here...this may help

http://technet.microsoft.com/en-us/library/ms166552.aspx

SQL Kiwi (1/6/2012)

---

J Livingston SQL (1/4/2012)

---

SO...until we have a budget that allows migration to 2012...I will continue with "quirky" for the tasks I use it for...feeling safe in the fact...

I am aware of the OVER( [RANGE | ROWS] ..) sub-clause...

Jeff Moden (1/2/2012)

---

J Livingston SQL (1/2/2012)

---

Hi Jeff

I am not surprised that you cannot replicate....I have used quirky update on several db's , all without errors...and the purpose behind this was...

Hi Jeff

I am not surprised that you cannot replicate....I have used quirky update on several db's , all without errors...and the purpose behind this was to build a testrig for...