Search results

Hi Leigh, Thanks for your answers to my questions. I will be far more cautious with ADP from now on. So far it has proven a huge benefit over DSN/DSN-less connections. I much prefer to work directly with MsSQL when it comes to data, and use Access for its user front-end (forms and reports.) Old...

Indeed local tables can be an ally however when you link a SQL table with millions of rows (my case) Access seriously struggles. ADP does not seem to compromise Access' performance to the same degree. Plus nothing stops me from adding native Access tables if I need. I do not understand this...

Hi darbid, This may not be what you want to hear, but I had similar problems with my Access 2K <-> MsSQL 2k linking. I posted something, see the thread http://www.access-programmers.co.uk/forums/showthread.php?t=164978 My solution: use the Project route if you can. There doesn't seem to be any...

Hi Hellgofi, Wild guess here: are the values you are submitting in the update/insert statement honouring the rules of the view? Choosing the option "Update using view rules" places additional rules on the data you are submitting. One such additional rule from your view: WHERE...

Hi All, Alright, so I didn't look well enough...:p Actually I didn't know about the 'Project' thingie in Access 2K so I was using the wrong keywords in my searches (this is my excuse:D). So I merrily started an Access project, connected to the MsSQL server, and voila! This project thing seems...

Hi all, I couldn't find any obvious answer to my question so here goes. Is it possible to programmatically (via a VBA module) to: create a connection to SQL (that I know is possible), then open tables in MsSQL as recordsets WITHOUT having to link them. Basically I'd like to bypass this...