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...

That was my first thought too but I actually went as far as to make ASPNET part of the Administrators group with no luck. Actually my co-worker rebooted the server yesterday evening and now everything seems fine... I should have seen that one... Thanks anyhow...

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...

D'oh! I figured it out. It is the scope of the app variable that is screwing it up. The link below is where I found the answer if any one has a similar problem. http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/accessdev/html/ODC_NewandEnhancedMicrosoftAccessObjects.asp

Nope. I can see all of that functioning, but at the end the access window still disappears.

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...

The repaint method worked great!

junior1554, I just tried a test of the repaint (never heard of that one before) and it seems to do the trick. I'll try it out for real at work tomorrow (hopefully) and if it works I'll give you another star :)

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 am trying to overwrite (not update) an existing table. Is there away around this? It's strange because this is an old process here. I'm not aware of there ever being a problem before the last few months or so. I am only seeing the problem with spreadsheets with rows over that 16383 number...

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...

D'oh! Didn't know that. These table doesn't have a PK at all... Thanks...

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...

D'oh! Thanks alot. It wasn't documented in the help files and that's all I'm working with (and Tek-Tips too...) Thanks!

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...

Fudge... I was afraid of that... Thanks...

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...

Whoa Yeah! That worked perfectly Pezamystik. You couldn't point me towards a good reference to this msysobjects (table?). It looks like there might be several useful things you could do with that...

No such luck... Anyone else?