Replies

Hi Hans –
Basically, I have a recordset that I break apart based on one of the fields, assign a file name, then use the TransferSpreadsheet function to export the files to a staged directory. Code is attached.

Thanks,
Mike

Yeah Hans, sorry – it’s been one of those days… Thanks!!

Hans –
Thanks, but the databases are Access 2000 databases. We have Office 2000 on our desktops. We only upgraded the operating system to Office XP. I didn’t think that should make a difference, but it’s the only thing I can think of that’s different. Any suggestions on troubleshooting the size? I guess I could create a new db, import the objects and create an mde after each import to see if I can isolate the problem to a particular object … what do you think?

Mike

Well, that ‘s interesting Hans. Now I’ve got to go look at their registries.

I am using a file dsn to link the tables in the app. The dsn resides on my pc, and dsn configuration indicates that SQL use the Windows login for verification.

I’m still not sure how the user is actually reading this file dsn, since it does not reside in the targeted folder on their pc. Maybe it is in their registry. Or maybe, since a file dsn, by definition, can be shared by users with the same drivers installed, the users don’t have to have the dsn reside on their pc.

I’ll have to research this some more. I thought I understood this better…

Thanks again, Hans!

Thanks, Hans.

So, just for clarification, you’re saying that when you link a table in MS Access via ODBC and furnish all the dsn connection info, that this dsn info is stored with the app. Once the app is deployed to the user, the user is connecting to it via the stored dsn info. It’s a dsn-less connection in that the user doesn’t have to have a dsn of the same name on his pc.

Is that right?

Thanks, Hans. As usual you’ve given me the direction to go in. I’ll check out the code samples!!

Appreciate it!!
Mike

Thanks Hans! This gave me the direction I needed. I actually ended up using the Follow Method after saving the file string to a hyperlink address on a control. It works great.

Appreciate it!!

Mike

Yes, it’s set.

Mike

John –
FANTASTIC!! Thanks alot!! It works like a charm!!

I was actually thinking about using the recordset approach, but I just couldn’t get it to work. Thanks for turning on the light bulb!!

I sure appreciate it.

As a newcomer to the Lounge, I was thrilled to see this! It is exactly the topic I’ve been struggling with off and on for the last two weeks!!

I’ve been trying to populate a table with the selected items from several multi-select list boxes so that I can then query it as a ‘parameter table’ in an sql sp. However, the code for populating the table has eluded me to the point of frustration!!

I’d be very grateful if you could show me how you did this, or at least point me in the right direction.

Thanks in advance!