Search results

Thanks for all of the advice. Much appreciated.

It maybe that I can't find the Access disks so I might be forced to buy the latest edition.

Thanks. If I decide to upgrade Access, what's the latest version suitable for my requirements?

Hi About 5 years ago I had a bit of an I.T. breakdown and gave up I.T. following a 27 year career as a database programmer. I changed career to become an ecologist, which is where my passions really lie. In the past 5 years I have done all I can to actively avoid anything I.T. related, because...

Hi, I'm having a speed issue with a form, and wondered if anybody can help me. I'm using Access 2007 as a front end to a SQL server 2005 database. The record source for my form is an ODBC linked SQL view, called vwStock, which itself is built from three other views. Two fields in vwStock are...

Hi, my application has a MS Access 2007 front end and a SQL Server 2005 back end. I also get data from sage line 50 using sage data objects. What I want to do is populate a temporary, local table in Access with data from a sage table. I could do it by reading the sage table a row at a time...

Thanks, that works great.

Hi, Can you help me?? I'm using Access 2007. I have a query which uses a number of sub queries in order to build up its data. A couple of the sub queries use a control on a form as to get their parameter (i.e. the year). Everything works fine, except that now as well as displaying the data on...

Why not just use ODBC to link Access to Oracle? Then you can just create Access queries and update forms in the usual way. That's what we do with SQL server and Access 2007, and it works pretty well. Colin