No access to .dbf files in access 97 after installing access 2003
I need to maintain an access97 database that is linked to dbf's, but
after having installed access 2003, when I try to link a .dbf file to
an access97 database, I only have access and odbc when the dialog box
to choose the external table comes up.
I tried going to control panel and change my office 97 setup.
When I go to the data access option, dbf is grayed out with a
checkmark in it and it states that dbf access is already installed.
Yet, I don't have access to that option when trying to link my dbf
table to the access97 database.
Any way to get that option back on?
Than...Access 97 to Access 2003
Am about to upgrade several machines running access 97 to new boxes with
access 2003. Got a massive access front end DB with a SQL back end. Guess
I will have to "upgrade" that '97 front.
Anyone have any advice or things to watch out for? Any VBA hasles? Horror
Hope it goes seamlessly... Got enough headaches.
This link contains our experience with upgrading Access.
It does not address the SQL Server aspects, but does describe
Setup, Conversion, and Usability issues:
Converting from Access 97 to 2000, 2002 or 2003
http://members.iinet.net.au...Access 97 or Access 2003
I want to use an Access database in a Visual Basic 6 program.
-Should I use Access 97 or Access 2003?
On Wed, 11 May 2005 11:28:20 -0400, "Sylmena" <firstname.lastname@example.org> wrote:
> I want to use an Access database in a Visual Basic 6 program.
>-Should I use Access 97 or Access 2003?
If you use MS Access '97, more people will be able to access your data.
Access '97 doesn't use Unicode - a space/speed advantage if you are not storing
Russian or a language other than English.
I can't think ...Running a ms access database with access 2003 in Vista
I have a Database that I am trying to run on a new vista computer. Up
to now I was running it on a win 98 computer and using access 2003! I
installed access 2003 and I can make it run and view the data but I
can not save any new records.
Has any one seen this problem yet?
Thanks Clarence Wollman
On Wed, 22 Aug 2007 13:17:13 -0700, cwoll <email@example.com>
Do you have the same problem with the Northwind sample application?
(search your computer for northwind.mdb)
>I have a Database that I am trying to run on a new vista computer. Up
>to now I was running...Enabling an Access 97 database for use with Access 2003
We have an Access 97 database app that we'd like to enable (not convert) for
Access 2003. We still have users running 97 and are not prepared to upgrade
everyone who uses this database to the 2003 version yet. We're getting an
error message when we try to do this which reads as follows:
"There were compilation errors during the conversion or enabling of this
database. The database has not been saved in a compiled state. The
performance of this database will be impaired because Microsoft Access will
need to recompile the database for each session."
The MS Knowledgebase doesn...Convert Access 2003 database to Access 97 format in VB6
Can anyone advise me if it is possible within VB6 to convert an Access
2003 database to Access 97.
The database only consists of tables, no VBA, no queries, and all of
the information I have found so far deal with either converting the
VBA to VB6 or using the tools within Access 2003 to convert to Access
What I want to do within the program is to take an Access 2003
database and create a copy in Access 97 format for use in an
application that will only handle Access up to Access 97.
Can this be done ?
remove fred before emailing
Hello, what would be a good module for accessing data contained in
a MS Access database file? Are there any examples of doing this
that you know of?
In article <nn1Ah.2617$2%1.2205@trndny02>, <QoS@domain.invalid.com> wrote:
>Hello, what would be a good module for accessing data contained in
>a MS Access database file? Are there any examples of doing this
>that you know of?
Depends what kind of platform you can use.
If you are under Windows, DBD::ODBC will work wonders.
If you `bridge' Windows <-> Unix, you can set up a DBI::ProxyServer on
a windows...Accessing access
Can anyone help me please? This has been driving me nuts for ages.
I want to use vb 6.0 to control data in a database (an access
database). I've looked at tutorial all over the net but I don't want
to use a data grid or anything like that because I want to control the
database, not see it.
So far, from one tutorial I've managed to get something on the lines
dim db as Database
Set db = OpenDatabase("E:\BT.mdb")
dim rspeople as recordset
set rspeople = db.openrecordset("people")
**************...access to Access
We use MS access 2000 at work and few people know how to work it including
We are using it on a network and more than one person is trying to access it
at once. Needless to say this isn't working as one has to log out first
before another can enter data. Is there an easy way around this? Or a
complicated way, actually I'll take anyway.
We have just started this database so any changes would be better done
Mike Kelliher wrote:
> We use MS access 2000 at work and few people know how to work it
> including me.
> We are using it on a network and mo...access to Access
I've been reading some old posts that talk of an inability to connect
to an Access database with RB. Is that (still) true? If so, that
would be a show stipper for us.
Thanks for any insight,
In article <firstname.lastname@example.org>,
Dave <email@example.com> wrote:
> I've been reading some old posts that talk of an inability to connect
> to an Access database with RB. Is that (still) true? If so, that
> would be a show stipper for us.
I've never tried it, but I think you should be able to access Access via
...Open Access Database Form from within Access database
I have included the following code to open an Access database form from
within an exsisting Access database. But when I run the code, it
appears that it opens the database because in windows explorer I can see
the database has the .ldb file extension. So it appears that it's open,
but I can't see the database or the form that I've tried to open. What
am I doing wrong. The following is the code:
'This is in the declaration part of the module
Dim appAccess As Access.Application
' Initialize string to database path.
Const strConPathToSamples = "C:\Documents a...Should I upgrade from MS Access 97 to MS Access 2002
My company has in one of their products used Access 97 and MS JET 3.5
for several years now.
Should we move the database to Access 2002 -which we use now in other
parts of the company and also upgrade the MS JET to the latest
And what does MS JET do?
Kjell Arne Johansen
MS Jet is the database engine that comes with, and is, by default, used by
If you aren't having any troubles with the Access 97 database, then there
isn't any technical reason to change. There may be company political reasons
if, say, the IT department only wants to have one ve...problem accessing access 97 database through odbc on windows 2003 sp1
We have a legacy application which relies on an Access 97 database
(upgrading is nog an option atm). As we are setting up a new server
(Windows 2003), we started experiencing problems running that
application after installing all required updates (Windows, Office, ..)
It did work before updating, with a basic OS + application
installation. Somewhere an update dit break things, but we do not know
Now for the problem. When starting the application, following error is
ODBC Microsoft Access Driver Login Failed
---------------------------...conversion access 97 to access 2003
which are the differences between Access 97 and Access 2003 ?
Converting from Access 97 to 2000, 2002 or 2003
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"helena" <firstname.lastname@example.org> wrote in message
> which are the differences between Access 97 and Access 2003 ?