Search results

The ADO connection String gives me Provider=MSDAORA.1;Password=aaaaa;User ID=aaaaa;Data Source=DBG2 Can I use that?

Yep　I tried that I wrote: Dim conn As ADODB.Connection Dim tdf As TableDef Set conn = New ADODB.Connection conn.Open restorConStr For Each tdf In CurrentDb.TableDefs If tdf.Name = "HKR_02_TKYOKUMD01" Then tdf.Connect = conn...

The system Im currently working on demands importing a lot of datas from an Oracle Server, and by 'a lot', I mean 50K to 100K volumes of data. Easily enough, I linked the necessary tables onto my mdb file and everything flew perfectly. Unfortunately my boss demanded that I use an UDL file so...

So, I accde-ed my file but then it cant seem to run codes no more... what gives? :(

This behavior occurs when you open two forms that update the same data source at the same time. The first form puts an edit lock on the record or records, and then the second form changes the record or records and saves the changes. When the first form tries to close and write back to the table...

Thanks! This solved everything. Almost anyway. Turns out the control source can be set to =[dblProfit] \ 1000 & "K" which solved the dilemma. Oh and sorry for my "binded textboxes" clusterf*ck, my english's broken more often that it should recently. :( Thanks again ;)

Im trying to format my textboxes that produces currency formatted values to "K" formats. Basically like 25,000 to 25K Can I achive this by just changing the format of the binded textboxes or do I need to code it manually, which ofcourse would mean the textboxes wont be binded anymore. But if I...

How do you import .cls files unto access again?

Database.tabledef("Tablename").Connect = ""

I coded a table linker for that, it checks the borken linked tables and reconnects it through a user interface, the code: Public Function tablesOK() As Boolean Dim tdf As TableDef Dim db As Database Dim quer As String Dim rst As Recordset Set db = CurrentDb...

Oh God!! Apparently, you can only use the Application.ImportXML for ACCESS Version 2002 and above, but Im using the relic, 2000. I guess Im back to square 1 :( If I set my recordset in a way that it acts like a table, like what I coded above. Can I make a clone of this in Access?.....

I cant thank you enough :D heheh thanks

Umm through ODBC right? Well, I dunno why but the customer's have a bad blood or something with ODBC, they dont like it, that been said.. I have to use ADODB :( Thats why I have no choice but to do old school and go individual on each records, ....making the process ridiculously slow :( I've...

Cool, except, umm how do I import the data? The power of Google points me to Menu based, can I do it programmatically? Thanks :D

I want to copy a table from Oracle through ADODB Connection. I did an early draft of of it but its runs so slow. I have 11 tables: Here's my code: Dim conn As ADODB.Connection Dim cmd As ADODB.Command Dim rst As ADODB.Recordset Dim tblNames(1 To 11) As String Dim newName, InsStr, strModifier...

How can I use it in Access? Please help :D

Yep, it worked, thanks so much sir hahaha, I got your point, that Access actually creates a compacted version then replaces the origianal too, hehehe that gave lots of ideas :D so I coded: Public Sub compactBackEnd() On Error GoTo doon Dim Fpath2, Bpath2 As String Dim dPath, dPath2 As String...

never mind I managed to do fix it yesterday :D

I have my tables database separated from my app mdb and I connected them through linking. As we all know, everytime you use the db, it bloats, so my Backend.mdb bloated upto 300+MB but then when I tried compacting it through the compact on close from Access, and it shrunk to 15MB! Nice So how...

I have my tables database separated from my app mdb and I connected them through linking. As we all know, everytime you use the db, it bloats, so my Backend.mdb bloated upto 300+MB but then when I tried compacting it through the compact on close from Access, and it shrunk to 15MB! Nice So how...