Viewing 15 posts - 16 through 30 (of 33 total)
I think this maybe what I need to do, but I do not see where the Get_Connection_String() function came from.
Please elaborate on your code a little. I think if I...
August 16, 2007 at 11:02 am
Well I am using it in VB6 code to open a recordset. I am doing so using a DAO reference(I know dead technology, but I think I can make it...
August 15, 2007 at 8:27 pm
BTW, the gridview looping is incorrect
August 15, 2007 at 1:02 pm
Here is a little update of progress only problem now is the newdb variable being set to open sql:
Dim sql_connect As
August 15, 2007 at 12:40 pm
Well I am only pulling from certain columns if there is data in them, and if there is data in them then I will insert that data into a name...
August 15, 2007 at 11:34 am
Just an update:
I have tried an alternate route of loading the schema into a datagrid and i can see the table names there but i do not know how to...
August 14, 2007 at 1:55 pm
Yes, sorry I have not provided enough details (newbie mistake). Anyways answers to your questions:
1) I CAN convert when I open the 97 DB in access 07 but I do not have to....
August 13, 2007 at 10:04 pm
Sorry took so long to reply, been crazy busy.. anyways, I tried querying the system table but i got the error: Record(s) could not be read, no permissions on MSysObjects,...
August 13, 2007 at 1:39 pm
when i am linking the access db with Linked Servers in sql server it give me an error message could not find installable ISAM. i don't have a clue at...
August 8, 2007 at 2:28 pm
k i am an idiot.. i got the reference in vs2005
August 8, 2007 at 1:50 pm
i know this is a little off but its from access 97 format (opens with access 07), goes into sql server 2005, and in vb.net code or SSIS i want...
August 8, 2007 at 1:00 pm
Please excuse my ignorance but I don't see how to add the DAO, I see only the ADODB reference.. and I think I forgot to mention these are access 97 DB's, thanks...
August 8, 2007 at 9:51 am
i did a little research on the reference but i am now thinking that if I use the SSIS package and do a union all that it might solve my problem,...
August 5, 2007 at 9:52 pm
jus a lil sayin round my way..
ya know diff strokes for diff folks, like that
July 24, 2007 at 10:56 am
problem solved, i went about the hard way but i got it.... o yeah bye bye access very soon, just trying to please big boss man for now, thanks a...
July 23, 2007 at 2:13 pm
Viewing 15 posts - 16 through 30 (of 33 total)