DB Other & Misc. Topic Most Active Threads

We have hit problems using Access 97 as a front end to our contacts database. The limitations are in the functionality within the constructed interface, not an issue such as too many records (Although speed is also an issue here). We are therefore looking to other types of front-ends to replace Access. , Could anyone provide any relative Pros and Cons to using... , , Access 2000 , FoxPro , Oracle Forms , VB6 , HTML + ASP , C++ , J++ , Delphi , , .. to construct the front-end interface. Any pointers would be gratefully received! , , Thanks, , Paul

Hi, I am trying to send SQL queries to MS Access 97 using Java but I only seem to get any response if I have a simple query of the form SELECT * FROM CUSTOMERS., , If I want to send something just slightly more complicated then it doesn't work, for example SELECT SURNAME FROM CUSTOMERS., , The code that I am using is:, Statement stmt = dbCon.createStatement ();, ResultSet rs = stmt.executeQuery (sqlStatement); //error occurs here, ResultSetMetaData rsmd = rs.getMetaData();, , Is there a particular format that Access needs when sending a query or is this a problem with it?, , Thanks, Andrea

{Too Long!}

{Too Long!}

dear all, , i am trying to retrieve data from a progress 9 database via odbc (datadirect 4.0) but get the following message: driver's SQLSetConnectAttr failed, feature not implemented..., can anybody help me with this one?, , greetz, carl

Hi,, I am looking for the Paradox 7 ODBC driver., , Do you know the link to download the Paradox 7 ODBC driver?, , Thanks in advance, , Kubilay

Having a memory leak problem when creating and opening a table, going to first record, getting a field, closing and freeing the table on a 1 second timer endlessly. I appear to loose about 20K each iteration., I'm using BDE 5.01, Delphi V4, ODBC Access drivers 4.00.3711.08 and Access 97 (SR1). , Has anyone experienced this problem and does anyone have any solutions for it?

Hi., , How do I save a binary file or picture in other formats than BMP in a blob, field under paradox7 ??, , Help please, , thanks

There is data analysis and reporting software available now that runs inside your web browser eliminating the need to license software for every user. The software accesses a cube of of information from your existing database and allows the user to analyze it and develop reports. If you are interested, please contact me for more info. [EMAIL]mplosenski@databeacon.com[/EMAIL] [URL=http://www.databeacon.com]Databeacon[/URL]

I tried the SQL Board and didn't get any response so I am trying this one. I am at an new job, and they have just asked me to move the transaction logs to another drive. Ok here comes the stupid question: How do I do it, is there anything special to it. Please help me asap I am in desperate need.

Hi,, I would like to find out if I can highlight a record on a continous form when it has been selected by a search TxtBox. I want to do this by using vb, any ideas ? , Thanks , Michael

Hello,, I've got a database consisting of dt3/dta files. I've got no idea what DBMS it is... I need to convert the data into MySQL, or at least to be able to extract it., Does anyone have an idea how I can get it done?, , Thanks,, Kirill.

Hello everyone., , I would like to announce that we distribute weekly mail magazine dedicated to Oracle users via email. This mail magazine contains useful tips and techniques. We have covered some topics such as index, freeblock, locally managed tablespaces, sort etc. based on our own analysis. , , You can check a sample here. [URL=http://www.performance-insight.com/ora3.html]http://www.performance-insight.com/ora3.html[/URL] , , Thank you, , Best regards, , Yuka :)

{Too Long!}

What is the Best Metal Detector Made? Hi-pe multi-zone metal detector