Search results

“Run-time error '3078': The Microsoft Jet database engine can't find the input table or query TableName” After linking to a table in an external db, I am attempting to open a recordset using the simple code shown below: Set rst = currentdb.openrecordset(“SELECT * FROM TableName”) When...

Hi All, I have a problem linking to tables in an external Access database. I have to run through a loop potentially 1000’s of times, and each time my code needs to link to an external table (depending on certain criteria), extract the data and manipulate it. Then my loop deletes the link and...

Hi All, As I am manipulating huge volumes of data using VBA and SQL, the Access database I’m using (the master database) becomes prone to exceeding it’s 2gb limit. In order to solve this problem, I am trying to do most of the manipulations/calculations in an external (secondary) database, and...

Hi All, I am trying to run a query that joins 2 tables, however, the joins will be different depending on certain criteria. I have 2 tables as follows: TblMonth Month MonthlyTotal Dec-08 Jan-09 Feb-09 Mar-09 etc TblSeason Season SeasonalValue Winter09 200 Summer09 100 Winter10 212 Summer10...

Hi, Is it possible to use the UNPIVOT function in Access SQL? I have a table with 5 columns (Type, Category, Profit, Revenue, Cost) as shown below: Type Category Profit Revenue Cost A Small £150 £200 £50 A Medium etc A Large B Small B Medium B Large C Small Etc What I want to be able to...

Hi all, I am having problems using the filelen function to determine the size of a database while the code is running. I have an Access database that is performing numerous calculations 1000’s of times with tables/temporary tables etc. The problem is that eventually Access exceeds it’s 2gb...