Recent content by gnt

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

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!

Ahhh, yes. Thanks for the foresight!

Thanks!

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

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-

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.

Thanks- I'll look around for that.

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

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

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

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

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

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-

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.