Search results

I would greatly appreciate it. Thank you,

hehe. Proabaly so. Do you think this is safe to use?

I tried "FILEDSN=;" and the Data Source prompt opens for me to create one. I use "FILEDSN=C:\MyDSN;" which absolutely does not exist and it works.

No I do not want a DSN at all. I want a DSN-Less connection Check this out. If I make a bogus final parameter like "FILEDSN=C:\asdfasdfasdfasdasd\MyFileDSN.dsn;" Where the DSN does not exist it still works. I am now wondering if this is safe to use (publish) or will it crash later on??? I...

Okay, this works but it is definately not what I am looking for ODBC;DRIVER={iSeries Access ODBC Driver};SIGNON=0;XDYNAMIC=0;CMT=0;PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;LANGUAGEID=ENU;DFTPKGLIB=QGPL;DBQ=My Library;SYSTEM=My System;FILEDSN=C:\Junk\MyFileDSN.dsn; But with this example I need to...

That is where I started. I still get "Reserved Error - 7778 There is no message for this error."

I found this really cool link http://www-1.ibm.com/support/docview.wss?uid=nas1c52dfe451b37518086256931005499ff But I am not sure how to use it to get a Pass-Through query to connect?

Banana, I do not know where to set that. I will look up documentation. All of the examples make is seem easy. One line, 4 parameters and that's it. I thought it would be an easy fix.

I have tried so many combonations I lost count. I can get the DSN popup to open (which I don't want), but even then it does not work. I usuall get -7778 There is no message for this error. Arrrggghhhh..... I'm lost.

Can I get away from or create programmitically an ODBC connector? I have been using a System DSN which uses an iSeries ODBC Driver. I create Pass-Through queries pointing to this DSN. I would like to elimitate the System DSN itself and have a query that has all the required parameters in the...

Thank you, I'll try that

I have actually gone another direction. I wanted to send an argument to Access when I open it. i.e. I am running DB_A which calls DB_B. but DB_B check for an argument and if present preforms an action such as opening a form and navigating to a specific record. I was looking for a simple way...

I use Set db = acc.DBEngine.OpenDatabase(strDbName, False, False, Access_PW) acc.OpenCurrentDatabase strDbName Which is a Microsoft example of how to open a password protected db. I am curious, using the example above (with modification) is there any way to send the db I wish to open a...

is it possible the in the tow different records that TempRA or the RANum are not identical but rather begin with the same digits. Using the 'Like' might then choose records that begin similar and not using it required an exact match. I am not sure but it's a guess.

Did you get your answers. I think I found something in a book. I am playing with (modifying) it if you still need it? If so are you: Trying to move linked SQL tables to local (within the db) tables keeping the same names??? Let me know,

Banana, I need to remember that one. I didn't know I could call a function from a query. I probably won't use it here (because of the SandBox article) but I can think of places I can. Thank you,

chergh, Yep! That worked perfect. Thank you,

True, But to be honest I am unsure as how to do it. The query is used as a RecordSource for Combo Boxes, Forms, etc... It might be easier to simple create a new query each time the db is opened. In either case that really doesn't answer the question though.

I use 'Environ("UserName")' in several places and it has always worked well. In Office 2007 (without Service Pack 1 yet) I can use the variable in VBA but not in a query. i.e. SELECT UCase(tbl_Job_Access.Job_No) as Job_No FROM tbl_Job_Access LEFT JOIN Job_Desc ON tbl_Job_Access.Job_No =...

The other reason for the password is not to allow imports of the underlying queries and tables. This is easily done with a new blank Access Database. I will lookingo the Ctrl+Break further. Thanks.