Search results

I use Access to extract data from a very large Oracle database. Since I am just an end user, I have to make do with what the IT department has provided. The Oracle ODBC driver that comes with Windows XP Professional is more than adequate.

' try something like this Dim db_source, db_dest As ADODB.Connection Dim rs_source, rs_dest As ADODB.Recordset Dim strCnxn, strSQL, qrybuff As String Set db_source = New ADODB.Connection Set rs_source = New ADODB.Recordset Set db_dest = New ADODB.Connection Set rs_dest = New ADODB.Recordset...

You have been handed a real mess. Access does not scale. I found that it will work with 5 or 6 users and a modest size database. The port over to something that can do the job is going to be painful for you and all the users. The network problems are not yours. All I can suggest is when the...

As far a starting out as a whatever kind of developer, I started by volunteering. I wrote a database application for a swimming club. The applications tracked the times of swimmer's at their swim meets. I got my first paying job by going to the interview with a copy of what I had done. The...

As a contractor, I would make between $25 and $65 an hour. It would depend on the company and the length of the contract. The richer the company, the higher the rate. The longer the contract, the lower the rate. I did this for more than 20 years. Now I am a permanent employee in a hospital...

It takes so long to run because I am doing a group by on an un-indexed column. Nothing I can do about it. The design of the database is out of my hands. I have tried extracting the rows from the table with the un-indexed column and doing the group by locally. It still takes a very long time...

Currently. I am using Access to extract data from a large Oracle database. Some of the queries take days to run. I run the big ones after hours and the results are collected in an Access table. The data is then passed along to my users where they will further analyze it with Excel and/or SPSS...

My story was of a client that did everything possible, wrong. I use prefixes for everything except field names. Just a habit I got into a long time ago. I have a second prefix, eg. qryXXXsomequery, to keep related forms, queries and reports together. The vba code in the modules does not have the...

This post reminds me of a client that built their own Access database. It was a simple table holding resume information from prospective employees. The table contained field names like: "The data in this field contains the applicant's birthday" That was the actual field names. Plenty of...

I have an Access 97 application that has been running for years without compacting. It is split and whenever I perform any upgrade or changes, I email the frontend to the client. The backend remains uncompacted. I never found a robust way to automatically relink the tables so I have duplicated...

First of all, you don't comminicate with a database through an ftp server. Most databases will let you comminicate through a port. Also, if this you first go at a web application with a database backend, I would stay away from ASP and anthing else Microsoft. PHP is a much more popular and...

I hate the editor in Access VB. Intelisense gets in the way (reminds me of Mr. Paperclip). So, when I am writing a complicated "anything", I use Notepad++ and paste the resulting code back into the VB editor. Notepad++ has some nice features like colour-coded highlighting and regular expression...