I am converting an application from A97 to A2003. I have 2 tables
created by another application as a Foxpro.dbf. The table has no index.
The connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
It's really easy to connect to those tables in A97. I'm having
difficulties in A2003. I'm trying to follow the instructions in http://support.microsoft.com/kb/824264/.
When I do a File/GetExternalData/Link in A2003 I select OCDB Databases()
in the files of type. As soon as I select that option type the dialog
box for linking the tables shuts down/closes. I have no opportunity to
select an ODBC data source.
This does not occur in A97. When I select ODBC Databases, I am
presented with a window to select the source.
Does A2003 require something "extra" to permit the selection of ODBC
data sources?
Connected http://www.youtube.com/watch?v=lNVwwumNnqU 7  3026 
On Nov 2, 10:02 am, Salad <o...@vinegar.comwrote:
I am converting an application from A97 to A2003. I have 2 tables
created by another application as a Foxpro.dbf. The table has no index.
The connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
It's really easy to connect to those tables in A97. I'm having
difficulties in A2003. I'm trying to follow the instructions inhttp://support.microsoft.com/kb/824264/.
When I do a File/GetExternalData/Link in A2003 I select OCDB Databases()
in the files of type. As soon as I select that option type the dialog
box for linking the tables shuts down/closes. I have no opportunity to
select an ODBC data source.
This does not occur in A97. When I select ODBC Databases, I am
presented with a window to select the source.
Does A2003 require something "extra" to permit the selection of ODBC
data sources?
Connectedhttp://www.youtube.com/watch?v=lNVwwumNnqU
Maybe the Access install is corrupted?? Do a re-install?
Technolust wrote:
On Nov 2, 10:02 am, Salad <o...@vinegar.comwrote:
>>I am converting an application from A97 to A2003. I have 2 tables
created by another application as a Foxpro.dbf. The table has no index.
The connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
It's really easy to connect to those tables in A97. I'm having
difficulties in A2003. I'm trying to follow the instructions inhttp://support.microsoft.com/kb/824264/.
When I do a File/GetExternalData/Link in A2003 I select OCDB Databases()
in the files of type. As soon as I select that option type the dialog
box for linking the tables shuts down/closes. I have no opportunity to
select an ODBC data source.
This does not occur in A97. When I select ODBC Databases, I am
presented with a window to select the source.
Does A2003 require something "extra" to permit the selection of ODBC
data sources?
Connectedhttp://www.youtube.com/watch?v=lNVwwumNnqU
Maybe the Access install is corrupted??
Thanks for your response.
It could be. However, the application, and Access 2003, seems to run
OK. The only thing I've done recently is install VSTO.
I noticed something funny. My connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
I have an old FoxPro DOS 2.6 on my computer. If I attempt to open those
dbf files with FoxPro 2.6 it says it's not a database file. If they
were 2.0 files I'd think my 2.6 version would see and recognize them.
If I attempt to open them with A2003 as a Dbase III, Dbase IV, or Dbase
IV it tells me the External table's not in the expected format.
I opened the dbf table in A97 and exported it to a text file.
Fortunately A2003 can recognize a text file. I may need to tell the
developer to create the files as text files instead.
I'm really disappointed in MS. I'd like to think their programs work
together. I expect upgrading to make things better, not add headaches.
>Do a re-install?
As a last resort.
Fire http://www.youtube.com/watch?v=Ye0k-qRDSno
Are these files still being created / updated with the other application?
If not, then export them as Access tables from Access 97 and link/import
them into Access 2003.
I can imagine that support for older versions might have been dropped
between Access 97 and 2003, but I don't do much with either Fox or dBase
files, so don't know for sure.
If you have a problem reading them with a later version of FoxPro, I
wouldn't think that a reinstall of Access 2003 is likely to help -- that's
usually a final, desperation try (and usually doesn't solve whatever problem
brought on the desperation -- which is not to say that it never is
successful).
Larry Linson
Microsoft Access MVP
"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...
Technolust wrote:
>On Nov 2, 10:02 am, Salad <o...@vinegar.comwrote:
>>>I am converting an application from A97 to A2003. I have 2 tables
created by another application as a Foxpro.dbf. The table has no index.
The connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
It's really easy to connect to those tables in A97. I'm having
difficulties in A2003. I'm trying to follow the instructions
inhttp://support.microsoft.com/kb/824264/.
When I do a File/GetExternalData/Link in A2003 I select OCDB Databases()
in the files of type. As soon as I select that option type the dialog
box for linking the tables shuts down/closes. I have no opportunity to
select an ODBC data source.
This does not occur in A97. When I select ODBC Databases, I am
presented with a window to select the source.
Does A2003 require something "extra" to permit the selection of ODBC
data sources?
Connectedhttp://www.youtube.com/watch?v=lNVwwumNnqU
Maybe the Access install is corrupted??
Thanks for your response.
It could be. However, the application, and Access 2003, seems to run OK.
The only thing I've done recently is install VSTO.
I noticed something funny. My connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
I have an old FoxPro DOS 2.6 on my computer. If I attempt to open those
dbf files with FoxPro 2.6 it says it's not a database file. If they were
2.0 files I'd think my 2.6 version would see and recognize them.
If I attempt to open them with A2003 as a Dbase III, Dbase IV, or Dbase IV
it tells me the External table's not in the expected format.
I opened the dbf table in A97 and exported it to a text file. Fortunately
A2003 can recognize a text file. I may need to tell the developer to
create the files as text files instead.
I'm really disappointed in MS. I'd like to think their programs work
together. I expect upgrading to make things better, not add headaches.
>>Do a re-install?
As a last resort.
Fire
http://www.youtube.com/watch?v=Ye0k-qRDSno
Larry Linson wrote:
Are these files still being created / updated with the other application?
If not, then export them as Access tables from Access 97 and link/import
them into Access 2003.
I can imagine that support for older versions might have been dropped
between Access 97 and 2003, but I don't do much with either Fox or dBase
files, so don't know for sure.
If you have a problem reading them with a later version of FoxPro, I
wouldn't think that a reinstall of Access 2003 is likely to help -- that's
usually a final, desperation try (and usually doesn't solve whatever problem
brought on the desperation -- which is not to say that it never is
successful).
These files are created from an external accounting program. They're
recognized by A97 but then A97 has FoxPro in the "Files of type"
dropdown. If I select "ODBC Databases ()" in A97 the next window that
pops up is the datasource window so the ODBC works as expected.
In A2003, since there is no FoxPro, I guess my only option is ODBC.
However, when I select "ODBC Databases ()" file types the datasource
window isn't displayed...it simply returns to the database window as if
the linking process is complete although no data source was selected.
This doesn't seem normal. I suppose if I ever needed to link to SQL
Server I'd have to buy a new computer and install Access on it.
Thanks for your suggestions.
>
Larry Linson
Microsoft Access MVP
"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...
>>Technolust wrote:
>>>On Nov 2, 10:02 am, Salad <o...@vinegar.comwrote:
I am converting an application from A97 to A2003. I have 2 tables
created by another application as a Foxpro.dbf. The table has no index.
The connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
It's really easy to connect to those tables in A97. I'm having
difficulties in A2003. I'm trying to follow the instructions
inhttp://support.microsoft.com/kb/824264/.
When I do a File/GetExternalData/Link in A2003 I select OCDB Databases()
in the files of type. As soon as I select that option type the dialog
box for linking the tables shuts down/closes. I have no opportunity to
select an ODBC data source.
This does not occur in A97. When I select ODBC Databases, I am
presented with a window to select the source.
Does A2003 require something "extra" to permit the selection of ODBC
data sources?
Connectedhttp://www.youtube.com/watch?v=lNVwwumNnqU
Maybe the Access install is corrupted??
Thanks for your response.
It could be. However, the application, and Access 2003, seems to run OK.
The only thing I've done recently is install VSTO.
I noticed something funny. My connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
I have an old FoxPro DOS 2.6 on my computer. If I attempt to open those
dbf files with FoxPro 2.6 it says it's not a database file. If they were
2.0 files I'd think my 2.6 version would see and recognize them.
If I attempt to open them with A2003 as a Dbase III, Dbase IV, or Dbase IV
it tells me the External table's not in the expected format.
I opened the dbf table in A97 and exported it to a text file. Fortunately
A2003 can recognize a text file. I may need to tell the developer to
create the files as text files instead.
I'm really disappointed in MS. I'd like to think their programs work
together. I expect upgrading to make things better, not add headaches.
>>>Do a re-install?
As a last resort.
Fire
http://www.youtube.com/watch?v=Ye0k-qRDSno
Do you have an ODBC driver for FoxPro installed?
As there appears to be no direct option for "FoxPro" in Access 2002 (I'm
temporarily reverted to that version to expedite using Speed Ferret in a
current project), I tried ODBC, and there were two listings for FoxPro...
one "Visual FoxPro Database (not sharable).dsn" and the other "Visual FoxPro
Tables (not sharable).dsn". When I try to select either, it fails with an
ODBC Error. Those could appear because Access 97 was installed on this
machine, and never uninstalled, although later installs of Access 2002 and
2003 made it unusable, or something could have been installed / registry
settings modified by some third-party application.
As far as I know, I have no FoxPro files of either type on the machine...
perhaps that is why the call fails, or perhaps the "(not sharable)" on those
listings means that use is limited in some way.
Larry Linson
Microsoft Access MVP
"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...
Larry Linson wrote:
>Are these files still being created / updated with the other application?
If not, then export them as Access tables from Access 97 and link/import
them into Access 2003.
I can imagine that support for older versions might have been dropped
between Access 97 and 2003, but I don't do much with either Fox or dBase
files, so don't know for sure.
If you have a problem reading them with a later version of FoxPro, I
wouldn't think that a reinstall of Access 2003 is likely to help --
that's usually a final, desperation try (and usually doesn't solve
whatever problem brought on the desperation -- which is not to say that
it never is successful).
These files are created from an external accounting program. They're
recognized by A97 but then A97 has FoxPro in the "Files of type" dropdown.
If I select "ODBC Databases ()" in A97 the next window that pops up is the
datasource window so the ODBC works as expected.
In A2003, since there is no FoxPro, I guess my only option is ODBC.
However, when I select "ODBC Databases ()" file types the datasource
window isn't displayed...it simply returns to the database window as if
the linking process is complete although no data source was selected.
This doesn't seem normal. I suppose if I ever needed to link to SQL
Server I'd have to buy a new computer and install Access on it.
Thanks for your suggestions.
>>
Larry Linson
Microsoft Access MVP
"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...
>>>Technolust wrote:
On Nov 2, 10:02 am, Salad <o...@vinegar.comwrote:
>I am converting an application from A97 to A2003. I have 2 tables
>created by another application as a Foxpro.dbf. The table has no
>index.
>
>The connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
>
>It's really easy to connect to those tables in A97. I'm having
>difficulties in A2003. I'm trying to follow the instructions
>inhttp://support.microsoft.com/kb/824264/.
>
>When I do a File/GetExternalData/Link in A2003 I select OCDB
>Databases()
>in the files of type. As soon as I select that option type the dialog
>box for linking the tables shuts down/closes. I have no opportunity to
>select an ODBC data source.
>
>This does not occur in A97. When I select ODBC Databases, I am
>presented with a window to select the source.
>
>Does A2003 require something "extra" to permit the selection of ODBC
>data sources?
>
>Connectedhttp://www.youtube.com/watch?v=lNVwwumNnqU
Maybe the Access install is corrupted??
Thanks for your response.
It could be. However, the application, and Access 2003, seems to run OK.
The only thing I've done recently is install VSTO.
I noticed something funny. My connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
I have an old FoxPro DOS 2.6 on my computer. If I attempt to open those
dbf files with FoxPro 2.6 it says it's not a database file. If they were
2.0 files I'd think my 2.6 version would see and recognize them.
If I attempt to open them with A2003 as a Dbase III, Dbase IV, or Dbase
IV it tells me the External table's not in the expected format.
I opened the dbf table in A97 and exported it to a text file. Fortunately
A2003 can recognize a text file. I may need to tell the developer to
create the files as text files instead.
I'm really disappointed in MS. I'd like to think their programs work
together. I expect upgrading to make things better, not add headaches.
Do a re-install?
As a last resort.
Fire
http://www.youtube.com/watch?v=Ye0k-qRDSno
Larry Linson wrote:
Do you have an ODBC driver for FoxPro installed?
Hi Larry. It appears FoxPro had nothing to do with it. It was Norton
Anti-Virus. I started another thread regarding the solution.
Thanks for your response.
>
As there appears to be no direct option for "FoxPro" in Access 2002 (I'm
temporarily reverted to that version to expedite using Speed Ferret in a
current project), I tried ODBC, and there were two listings for FoxPro...
one "Visual FoxPro Database (not sharable).dsn" and the other "Visual FoxPro
Tables (not sharable).dsn". When I try to select either, it fails with an
ODBC Error. Those could appear because Access 97 was installed on this
machine, and never uninstalled, although later installs of Access 2002 and
2003 made it unusable, or something could have been installed / registry
settings modified by some third-party application.
As far as I know, I have no FoxPro files of either type on the machine...
perhaps that is why the call fails, or perhaps the "(not sharable)" on those
listings means that use is limited in some way.
Larry Linson
Microsoft Access MVP
"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...
>>Larry Linson wrote:
>>>Are these files still being created / updated with the other application?
If not, then export them as Access tables from Access 97 and link/import
them into Access 2003.
I can imagine that support for older versions might have been dropped
between Access 97 and 2003, but I don't do much with either Fox or dBase
files, so don't know for sure.
If you have a problem reading them with a later version of FoxPro, I
wouldn't think that a reinstall of Access 2003 is likely to help --
that's usually a final, desperation try (and usually doesn't solve
whatever problem brought on the desperation -- which is not to say that
it never is successful).
These files are created from an external accounting program. They're
recognized by A97 but then A97 has FoxPro in the "Files of type" dropdown.
If I select "ODBC Databases ()" in A97 the next window that pops up is the
datasource window so the ODBC works as expected.
In A2003, since there is no FoxPro, I guess my only option is ODBC.
However, when I select "ODBC Databases ()" file types the datasource
window isn't displayed...it simply returns to the database window as if
the linking process is complete although no data source was selected.
This doesn't seem normal. I suppose if I ever needed to link to SQL
Server I'd have to buy a new computer and install Access on it.
Thanks for your suggestions.
>>Larry Linson
Microsoft Access MVP
"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...
Technolust wrote:
>On Nov 2, 10:02 am, Salad <o...@vinegar.comwrote:
>
>
>
>>I am converting an application from A97 to A2003. I have 2 tables
>>created by another application as a Foxpro.dbf. The table has no
>>index.
>>
>>The connect string in A97 is
> FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
>>
>>It's really easy to connect to those tables in A97. I'm having
>>difficulties in A2003. I'm trying to follow the instructions
>>inhttp://support.microsoft.com/kb/824264/.
>>
>>When I do a File/GetExternalData/Link in A2003 I select OCDB
>>Databases()
>>in the files of type. As soon as I select that option type the dialog
>>box for linking the tables shuts down/closes. I have no opportunity to
>>select an ODBC data source.
>>
>>This does not occur in A97. When I select ODBC Databases, I am
>>presented with a window to select the source.
>>
>>Does A2003 require something "extra" to permit the selection of ODBC
>>data sources?
>>
>>Connectedhttp://www.youtube.com/watch?v=lNVwwumNnqU
>
>
>Maybe the Access install is corrupted??
Thanks for your response.
It could be. However, the application, and Access 2003, seems to run OK.
The only thing I've done recently is install VSTO.
I noticed something funny. My connect string in A97 is
FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test
I have an old FoxPro DOS 2.6 on my computer. If I attempt to open those
dbf files with FoxPro 2.6 it says it's not a database file. If they were
2.0 files I'd think my 2.6 version would see and recognize them.
If I attempt to open them with A2003 as a Dbase III, Dbase IV, or Dbase
IV it tells me the External table's not in the expected format.
I opened the dbf table in A97 and exported it to a text file. Fortunately
A2003 can recognize a text file. I may need to tell the developer to
create the files as text files instead.
I'm really disappointed in MS. I'd like to think their programs work
together. I expect upgrading to make things better, not add headaches.
>Do a re-install?
As a last resort.
Fire
http://www.youtube.com/watch?v=Ye0k-qRDSno
"Salad" <oi*@vinegar.comwrote
>Do you have an ODBC driver for FoxPro installed?
Hi Larry. It appears FoxPro had nothing to do with it. It was Norton
Anti-Virus. I started another thread regarding the solution.
I saw the other thread... Some time ago I used NAV, but haven't for some
time.
I'm using NOD32 from www.eset.com. I haven't had a virus infection since I
began using it over a year ago, it's unobtrusive, and, AFAIK, it doesn't
interfere with anything except the "bad stuff". This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Katuil Katuil |
last post by:
Hello All:
Have a problem that I have never seen before and have not found anything
on
technet on how to resolve it. I have a SQL Server 2000 server that I
have
created a new database. I then...
|
by: Andreas Lauffer |
last post by:
I use Blanks in ColumnNames ( I know that this isnīt very good, but a
lot of code and querys had to be changed if I would remove all blanks
in all columnnames).
When I link this tables with ODBC...
|
by: Eric E |
last post by:
Hi all,
I'm having quite a bit of trouble with code to create linked tables in
Access 2K. I create a DAO tabledef using CreateTableDef against a DAO
database object, then set its connection...
|
by: Joe |
last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource
(using Oracle ODBC drivers). After linking the tables in Access, I inspect
the data contained in the linked tables. For...
|
by: Tim Marshall |
last post by:
Hi folks.
In A2003, I am sometimes getting an error when I try to open a pass
through query or display, via DAO, field information from an ODBC
connected table. I've never generated this error...
|
by: ramazan_ozturk |
last post by:
I have the following problem with Access 2003, hopefully someone can
help.
I'm using MS Office Pro. 2003 on a Windows XP Pro. SP2 machine.
When I try to get external data import/link a table I...
|
by: Simon Bailey |
last post by:
In VC++6 I used to use the add member variable tab of the class wizard to
bind recordset fields with dialog controls simply by specifying the m_pSet->
variable before the variable name. This all...
|
by: rdemyan via AccessMonster.com |
last post by:
I just got Access 2003 and have been playing around with it. This whole
macro security thing can be a bit annoying.
Initially, I was able to link to my backends located on a second computer....
|
by: rdemyan via AccessMonster.com |
last post by:
With A2003, I'm having trouble accessing files in a folder on another
computer where back-end files, update files, etc are located. Here's the
scenario:
1) Computer #1 - A2003
2) Computer #2 -...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
