Search results for query: *

I'm developing an app that uses the MS Oracle Data provider. I've noticed that if you open the application in a browser everything runs fine. However, if there is no activity for about 5 minutes or so the database connections generate errors (error's that don't happen if at least one data...

I have Oracle 9i client install on web server. I have also given the asp.net,IUSR, and IWAM accounts full permissions on the oracle/ora92/bin folders. But when I try to use the oracle data provider in a asp.net page I get the "Unable to load oci.dll: error message. I have used the this...

Hello all, Why does the following code not keep the access database opened visible when the button is clicked (it flashes for a second then goes away)? Private Sub Command1_Click() Dim App As New Access.Application App.Visible = True...

Hello all... Can anyone tell me how to import data from an ODBC data source using criteria in a local table? What I am looking to do is move records from the ODBC data source (remote Oracle server) to our local SQL server based using a list of SSN we have on our local SQL server. Our list...

Hello, I have an application that runs about 34 queries in sequence and each one would take quite a while to run to run when done individually. I'm try to provide a progress bar or any kind of display for the user to be able to see the progress of the program, but the screen will not update...

I'm trying to pull in data from an Excel spreadsheet to an Access table with the File->Get External Data->Import menu bar option. These are large spreadsheets (40,000+ rows) and it seems that Access97 will only import the first 16,383 rows. No error message is returned. Is this a bug or...

Hello all, I have a Access97 database with links to tables in an SQL Server database through a DSN. I have permissions to be able to do whatever I want to this table, but if I open up the Access link and try to change data in the table I get an 'Recordset is not updateable' message. I can't...

I'm trying to have reports in Access 97 be exported as snapshots when a button is clicked. My code is: DoCmd.OutputTo acOutputReport, "rpt_BackUp_FT", acFormatSNP, strDirAdd & "_FT.snp" but the acFormatSNP option doesn't work. I have to take it out and select the file...

Hello all, I am currently working on a project in Access that runs several slight variations on a query that has it's SQL statement altered through code before it is run. Something like changing: SELECT * FROM Table WHERE X > 1 to SELECT * FROM Table WHERE X < 1 AND X >-2 There is a...

Hello all, I've been trying to loop through all the forms (open and closed) in my database. I've read the help about using the documents collection of the container object, but I can't figure it out. My code (forgive the variable names): Dim dbs As DAO.Database Dim a As Container Dim b As...

Hello all, I'm working on a project that requires I be able to print out letters and memos with dynamic pieces (like date of letter, who it was sent to, etc.) I was wondering what our thoughts are on how to do this. Would it be best to try and do the letters in Access as a report or maybe try...

If I have a linked table in a backend (say about 30,000 records with at least 50 fields). Queries run against this table are pretty slow. I believe (and corrrect me if I am wrong) that Access has to pull the entire table from the network to the local machine before any queries can be run (hence...

In the near future I am going to need to access data from a &quot;PeopleSoft Database&quot;. Knowing nothing about PeopleSoft I am wondering if the &quot;PeopleSoft Database&quot; is a propriatary database with PeopleSoft or is it a different database package (SQL Sever, Oracle, etc.) that is...

I'm trying to return the number of records in a recordset that is from a stored procedure (an Access Query) that is passed parameters. I understand that the RecordCount method doesn't work in this situation. Does anyone have a solution?

I was having a debate with a co-worker about the value of frames in HTML pages. I kind of like them because the make a web site more structured. He seems to think that hardly anyone uses frames, so they must not be worth it. What do you guys think? Do you all design pages with frames or not...

I am trying to create a form that when submited directs the user to one of five other forms based on their input. What I doing on the user input form <FORM method=post action=redirect.asp> then on redirect.asp they are sent to another page with the Response.Redirect method The problem I am...

I'm trying to help build a database driven website. We have an Access database that we can connect to and read data from, but we get the 'Operation must use an updateable query' error message when we try to write data to the database. I've been to MSDN support and the folks who have the...

I'm trying to write a little VB program that will run the DoCmd object in an Access database to export a report in HTML format. However, I keep getting this error 2282 (formats for HTML are missing from the Windows Registry). My code is: Dim objAcc as object set objAcc =...

I'm in the process of helping to build an intranet website around an Access databasewith FrontPage 2000. However, the server doesn't support ASP, PHP, or anything except Front Page server extensions. What I'm looking to do is: 1)read data from a web form and store it in the database...

This is probably a really stupid question, but how do you loop through the items in a list box? Any help??