| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
How 'bout this: I have a new mdb database. Start a new query. Go to
properties. I have 2 choices, Source Database and Source Connect Str. How can I use a UDL file or connect string to work with VFoxPro data? Noob problems?  -JS "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:(E-Mail Removed)... > As far as I'm aware, it's not possible to use OleDb to create a linked > table or a pass-through query. > > It's only possible when creating a recordset in VBA. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "DevourU" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >>I have been running a msaccess 2000-3 database with ODBC for several >>years. >> It is now time to move on to OLEDB. Is there a way to subsititute an >> OLEDB >> link for the ODBC for a one stop switch? If not can I gat help on how to >> place my init string: >> >> Provider=VFPOLEDB.1;Data Source=f:\pcmrpw;Mode=Read|Share Deny >> None;Password="";Collating Sequence=MACHINE >> >> Many thankx in advance. >> -JS >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
As I already said, I don't believe it's possible.
While you can programmatically set the Connect property of a TableDef (or QueryDef) object, as far as I'm aware Access will not access OleDb connection strings, only ODBC ones. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "DevourU" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > How 'bout this: I have a new mdb database. Start a new query. Go to > properties. I have 2 choices, Source Database and Source Connect Str. How > can I use a UDL file or connect string to work with VFoxPro data? Noob > problems? > > -JS > > "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message > news:(E-Mail Removed)... >> As far as I'm aware, it's not possible to use OleDb to create a linked >> table or a pass-through query. >> >> It's only possible when creating a recordset in VBA. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "DevourU" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>>I have been running a msaccess 2000-3 database with ODBC for several >>>years. >>> It is now time to move on to OLEDB. Is there a way to subsititute an >>> OLEDB >>> link for the ODBC for a one stop switch? If not can I gat help on how to >>> place my init string: >>> >>> Provider=VFPOLEDB.1;Data Source=f:\pcmrpw;Mode=Read|Share Deny >>> None;Password="";Collating Sequence=MACHINE >>> >>> Many thankx in advance. >>> -JS >>> >>> >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| using vfoxpro dll in clickonce project | celerno | Microsoft C# .NET | 2 | 1st Nov 2006 02:18 AM |
| convert an xmlString createt by a vFoxPro webservice into a DataSet | Michael Kugler | Microsoft VB .NET | 0 | 4th Apr 2006 07:12 PM |
| Oledb VS Sql. Oledb works with Sql Server; Sql doesn't...why | mrmagoo | Microsoft VB .NET | 5 | 29th Mar 2006 01:32 AM |
| oledb & windows 98 error(oledb not registered on local machine) | =?Utf-8?B?bW1i?= | Microsoft ADO .NET | 1 | 23rd May 2004 04:40 PM |
| VFoxPro & MSAccess Query Freeze... | Jean Claude Haddad | Microsoft Access External Data | 0 | 16th Apr 2004 11:45 PM |
