Search results

Thanks, it's a Microsoft function, I cannot change the returned values. Sorry, I should have included the subroutine straight away (see below). "Ref.FullPath" is a bit misleading. It actually returns "short" path names. I need "long" path names. Sub GetReferences() 'get VBA references Dim...

It comes from another function that only returns a "short" path name. I need the "long" path equivalent. Cheers

Greetings, I’m trying to programmatically (without any user intervention) retrieve the “long path name” for a given file. It seems to me this should be a rather easy thing to achieve using Access VBA. I’ve tried using various FileSystemObject methods with no luck. I’ve Googled many variants...

Greetings, I created a query (in Access 2010) that joins several linked tables (to an Oracle database). The query runs in about 20 seconds when I filter with a “hard coded” date (e.g., #12/31/2014#). The Oracle table column I’m filtering on is defined as date/time. When I attempt to change...

Success! I finally stumbled upon the correct "connection string" syntax. I can connect from my Access 2010 database to an Oracle 11g database without using a DSN. Here is some sample code. Sub MakeConnection() Dim db As Database Dim td As TableDef Set db = CurrentDb...

Follow-up: It appears that semicolons CANNOT be part of your log-in credentials, as it relates to an ODBC connection string. I tried enclosing the password in double quotes, single quotes, nothing works. Unless I’m missing something, it appears that semicolons are always interpreted as a...

Thanks all for your responses. I think my ignorance of Access database connections may have led me to misstate my question. Although the response I received regarding DSN-less connections is worthy of a second look (for a more overarching/long term database connection solution), my real need...

Hi, I looked all over for a concise example of a DSN-less Oracle connection. I found many code snippets, some short, some quite lengthy, but nothing seems to work. I tried DAO, ADO, etc. I tried searching through Microsoft’s web sites and Access/Oracle user forums, but to no avail. What...

Hi, I've been working with Access for many years. I've hit just about every angle of the product. Most of my work has been in Access 2000/2003. I recently upgraded to Access 2010. I rely heavily on VBA (more flexibility/control). Jeff USA