Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gnt

  1. gnt

    MDB Recovery

    Thanks- That's what I thought. And it was deleted too long ago to recover. I can copy everything but the forms into a new database, but of course that's where all my code is. And there is no way to access the vb code behind the forms? I suppose that would defeat the purpose of the mde...
  2. gnt

    MDB Recovery

    Hi- I think I may be dreaming here, but is there any way to recover an mdb file from the mde? It was accidently deleted. Thanks!
  3. gnt

    Apostrophe Problems.

    Ahhh, yes. Thanks for the foresight!
  4. gnt

    Apostrophe Problems.

    Thanks!
  5. gnt

    Apostrophe Problems.

    Hello- I am trying to pull data from the database on our server using a SQL Select statement. The criteria is a string value that is input on a user form, and the results populate a list box. Simple enough. Here's a bit of my code: Set objConn = CreateObject("ADODB.Connection")...
  6. gnt

    Recordset Problem...

    Steve- I figured it out using .AddNew to populate my tables. 50,000, 10 field records in 15 seconds - that I can live with. Syntax in thread705-208622. Thanks-
  7. gnt

    Recordset problem

    Yahoo! Thanks so much for pointing me in that direction. You don't know how many weeks I've been working on this! My INSERT query took over 5 minutes to run, but with the objRS.AddNew command - 50,000 records in 15 seconds! Thanks also to koukouroukou in thread705-208622 for the syntax.
  8. gnt

    Recordset problem

    Thanks- I'll look around for that.
  9. gnt

    Recordset problem

    Geoff- Yeah, that's what I've been trying. Unless you know of another way to append records besides the INSERT statement. In theory, what I want to do is this: INSERT INTO tblMaster (shipno, shpnam, sinout) SELECT (shipno, shpnam, sinout) FROM [My recordset] But as far as I know (which is...
  10. gnt

    Recordset Problem...

    Thanks Steve- The problem with the pass-through query and linked tables is that once I establish a connection using the following Connect statement: ODBC;server=cnxsvr;dsn=vax_db;uid=uid1;pwd=pwd1; it won't close the connection until I shut down Access. So when I run another pass-through...
  11. gnt

    Recordset Problem...

    Hello- I'm trying this thread again, because I haven't had much luck with it... I'm trying to pull data from a database on our server and import it into a local table in Access. The only way I've found to do it is to create a recordset with the data and run an INSERT SQL statement cycling...
  12. gnt

    Recordset problem

    Hello- I'm trying this thread again, because I haven't had much luck with it... I'm trying to pull data from a database on our server and import it into a local table in Access. The only way I've found to do it is to create a recordset with the data and run an INSERT SQL statement cycling...
  13. gnt

    How do I reference the Microsoft DAO 3.6 Object Library

    I think all it means is the following: In your VB Editor choose Tools -> References... and then check the box next to Microsoft DAO 3.6 Object Library. And that's it. Let me know if you mean to do something else...
  14. gnt

    SQL INSERT INTO, using multiple databases

    Yeah, I thought about that. But as I'm a bit of a novice to ADO, I haven't been able to figure it out yet. Could you perhaps get me started on the code? Do I throw the data into a recordset? Then what? I need to pull about 15 fields, and about 50,000 records. Thanks-
  15. gnt

    SQL INSERT INTO, using multiple databases

    smin- I run into the same problem as with the pass-through query. Once I establish a connection uid/pwd, I can't change it. It will look like it's changed, but will only pull data from the original connection. Linking the tables would be ideal - if you know a way around this problem.
See more

Part and Inventory Search

Back
Top