Convert Access 2.0 to 97 or 2000 -
Is there a way to convert Access 2.0 to Access 97 or 2000 or does it do it automatically.
I know you can go to Database Utilities and then click convert, but it doesn't give me the option to convert it to 97. I think when i open it transforms it to 97 right there.
IF so, would the only way to convert it from 2.0 to 97 would be to actually have the 97 version of Access. I currently have 2002
Convert Access 2.0 to 97 or 2000 -
Is there a way to convert Access 2.0 to Access 97 or 2000 or does it do it automatically.
I know you can go to Database Utilities and then click convert, but it doesn't give me the option to convert it to 97. I think when i open it transforms it to 97 right there.
IF so, would
Access 2000 mdb with VB6 -
Does anyone know how to use a 2000 Access mdb with the data form wizard addin in VB6....I keep getting a unknown db format error when I try to access a 2000 mdb.... I know I can convert from 2000 mdb to a previous version of access and get it to work....But is there a way to use a 2000
User Groups in Access 97 to Access 2000 -
Hi,
Someone create an access database file that consist of forms, tables, reports and so on in Access 97.
He also created the user workgroup, so that only a few has administrative rights while the others have only "Users" rights. At least, I believe that is what he did.
ACCESS 2000-ACCESS 97 and SQL 7 -
My APP is in access 97 i want to know two things
1) It is possible to run my app from access 2000 without convert it?
2) It is possible to convert my full app from access 97 to sql and this could work FINE (forms, macro, report, etc.)
CompactDatabase to convert to Access 2000 -
I am trying to convert an Access 97 db to Access 2000. Using DAO 3.6 I tried the following code:
DBEngine.CompactDatabase "c:\A97.mdb", "c:\a2000.mdb", , dbVersion40
Code runs fine and creates a2000.mdb. I try to open a2000.mdb in Access 97 and is does not r
How convert Access 97 to 2000 with VB -
Hello,
is it possible to convert a access 97 format database to access 2000 with VB6? If so, please point me into the right direction.
Thanks in advance
embargo
VB 5.0 interfacing with Access 97 convert to Access 2000 -
I've written an VB5.0 program that interfaces with an Access97 data base. It works perfectly, but, I converted the data base to Access 2000 and get the following error, "Unrecognized database format c:\vb\invenVB97.mdb'. The access database name is invenVB97 in the directory c:\vb
Access 2000 Conversion Problems -
Hello,
Anybody else having problems converting Access 97 databases to Access 2000?. To be specific I'm using an Access 2000 front end .mde to access a 97 .mdb data store, the 97 store is a replica set. When I access the 97 store through an existing 97 front end I can see all the field
How to check the version of access installed through vb -
Hello all,
I need your help in doing this. We have an application in VB and we currently use DAO3.51 to access the database that are created in access 97 and access 2000. Now we are going to support only access 2000 and 2002 and going to use DAO3.6 that is jet engine 4.0 I believe. Th
VB6 not compatible with MS Access 2000 -
I am using a data ctrl to call a database which is created under Access 2000, but it show me an error "Unrecognized database format", when i using Access 2000 to convert the database back to previous version, it's OK.
What does it mean? Is it VB6 cannot coorperate with A
VB apps using Access 97 and 2000 -
hi
i have a vb application using access 97 and is compiled and in a project ...
but when i convert the mdb to access 2000 ... the vb prompts unrecognizable format when opening the mdb ...
anyway i can rectify this ?
or must definitely use access 97 ?
MSDE versus Access 2000 -
I am writing an application for a doctors office. I am using access 2000 for my DB. The doctors office has told me that they will be running between 7-15 Workstations and I guess 1 Server. I have no Idea what OS they will use. But my problem is that many people have told me that Access
Access conversion -
Is there a way to convert access 2000, so it will load up in access 97?
Assuming i dont have access 2000
Access 2.0 Converstion -
Does anyone know how to programmatically convert an older Access DB to Access 2000, using VB6.
[Edited by JR Ewing on 07-28-2000 at 11:27 AM]
Access 2000 with Access 97 runtime -
The program I have uses Access 97 in development but needs to automatically convert the DB to 2000 if it is detected. I have that problem all worked out.
The problem comes in after the DB is converted to 2000. All of the program works perfectly except for the Reports. On triggering
Access conversion probs -
I am trying to open an Access 97 database in 2000, but I am encountering some problems. First of all if I try to open the database in 2000 I will receive a prompt sating “unrecognised database format” I have no option but to click Ok. This then prompts me to open or convert the da
Access 2000 with MSDE -
I have decided to convert from using DAO to ADO and to upgrade to and Access 2000 database instead of Access 97.
I think that I will use the MSDE data engine instead of the Jet 4.0 database engine. But I am not sure whether its just changing the connection type in code, or whether I n
Creating new database -
When a DB is created using Access 2000, VisData complains, "Unrecognized Database Format."
If you create DB using VisData, Access 2000 will not allow changes unless you convert the DB using their conversion utility. Then, if you do convert of course, you can no longer load
looking fr access 2000 to sql server 2000 sql/query converter -
Hi guyes . I am looing for a simple to use tool that easily convert the access 2000 query or sql code to sql server 2000 code and visa versa. Thanks
Access 2000 db in VB6 -
I have created an Access database using the Visual Data Manager in VB6. This works fine however when I load the database into Access 2000 and convert it to the 2000 format and try to use the converted database in VB6 I get the error 'Data error event hit. Unrecognised database format .
Access 2000 compatibelity with DAO -
I use DAO 2.5/3.5 when i create a database.
When i open the DB in Access 2000, it says something like: "You must convert the DB to Access 2000 format." And i do so then i will not be able to open it with my VB app later, cause it says that is a wrong version or something.
Use Access 2000 from VB5 without Access on computer -
I want to use an Access 2000 database from VB5 (SP3). On a computer with Access 2000 it works fine. I use DAO 3.6. On a computer without Access 2000 it doesn't work.
Is it possible to use Access 2000 from VB5 if no Access 2000 is on the computer. And if it is, How do I do this? Use
Access VBA to VB6 -
I don't know if this has been asked before, or makes sense but I need to aks. Is there a way to convert an Access 2000 application (Forms with VBA code) to VB 6?
I have an extensive application written originaly in Access 97, upgraded to Access 2000. Most of the Data Access, SQL's
SOS Access 97 Migration to Access 2000 -
We are beginning to rollout Access 2000 and are relying on a strategy of enabling the Access 97 dbs so that the Access 2000 clients can also use them - mixed client base.
However I think that it looks like the dbs revert back to Access 97 only when a user with Access 97 so much as edi
Convert Access Database to SQL Server database -
Can any body provide me prototype code to convert MS Access 2000 database to MS SQL Server database. I know some tools to do it. But I wanted to convert programatically .
Convert Access 97 db to 2003 using VB -
Hi guys,
I'm trying to upgrade an Access 97 db to 2003 using vb as part of the upgrade process for an app we have. I've found lots of code to convert from 97 to 2000 using the Jet object to compact the db, but I cannot find code anywhere to convert to 2002-2003.
Any ideas?
Ch
Access 97 to Access 2000 -
When I convert my Access 97 database to Access 2000 my programs caannot use the new format, tells me its an unrecognized database format and then the path.
Any ideas please as I do not want to redue my database
Thanks in advance
Access 97 & Access 2000... -
Hi guys, I orginally had a project using DAO to access an Access 97 database. Just recently, I installed Access 2000 along with Office 2000 on my system. And now my project can't access the database after I have converted it from Access 97 format to Access 2000 format. What should I do
ACCESS 2000 and i still cant get it to work! -
Hello to you all!
I know that there are a lot of messages about this subject, but none are clear or work. Am i doing something wrong? On my own computer i use Vb6. When i use a datacontrol and i select the "connect" propertie i have got ACCESS and ACCESS 2000. So far good,
EXE FILE IN ACCESS 2000 -
Again, Does anyone know a product to make EXE file from an ACCESS MDB?
or A program to convert from ACCESS 2000 TO VB?
convert old version of Access -
Hi,
I'm trying to open an Access file but it is apparently a really old version. When I try and open the file in Access 2000, it says "This operation not support in Access 1.x."
I guess it's an Access 1.0 version database. Is there any way I can convert this thing? I
Access: Unrecognised format -
Hi there
I've created an Access Database using Access 2000. However, when I connect the database in Visual Basic 6, it gives an error stating "Unrecognised database format".
I've created the exact same database with Access '97 and it works just fine. If I convert the Ac
FilemakerPro to Access 2000 -
Does anyone know how to import or convert FilemakerPro data to Access 2000?
Rev. Michael L. Burns
convert access forms to vb forms -
I have designed some forms in Access 2000 which I would want to convert in to VB6 format.
I would appricate any valuable comments in this regard.
Connection to Access 2000 from Access 97 -
This is how I open my Access 97 DB from VB6 (DAO)
temp3 = ";DATABASE= C:\file.mdb"
Set db = OpenDatabase("", False, False, temp3)
If I convert my DB from ACCCESS 97 to ACCESS 2000 (or 2002?), Do I need to modify my syntax? Will everything else in VB6 (record
VBA Code to stop Access 97 db converting to Access 2000 -
Hi
I have written a database in Access 97 that uses replication.
I have recently discovered that some users have Access 2000 and that it does not givew the option to just open the db but just gives the option to convert it.
I'm afraid if it is converted access 97 users would n
What to do, that Data1.Connect property would be set to Access 2000 -
What to do, that Data1.Connect property could be set to Access 2000 ?
Hallo My Dears !
What to do, that Data1.Connect property could be set to Access 2000 ?
On my PC Win 98, VB6.0, Access 2000 are installed.
When working , at VB6.0 design time Data1.DataBaseName propety is set
convert dBase 4 => Access 2000 -
Hi All,
I have a dBase 4 database with several tables and wish
them all converted to Access 2000.
I could do it with importing/exporting within access but
for some reason I want to use VB code.
Are there commands in VB such as :
Create database, Create Table
and can it b
compatibilty issues -
Hi, I have some questions...
I am developing a VP application (with VB6) that uses the Data Control with the Jet Engine tpye to access an MDB file (Access) over a LAN.
1) Will this work on Win2000 ?
2) I have tested accessing an MDB file from Access 97 and it works.... however
Access version conversion -
Is it possible to convert an Access 2000 database to Access 97 using VB code?