o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

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, because i want to use ACCESS 2000. On my work i have also got Vb6, but over there i do not have the ACCESS 2000 option. I have downloaded the Jet4.0 SP5 and installed it, but is still cant access ACCESS 2000 databases. The reference is also at DAO 3.6.

Can anybody help me because i am getting really frustrated...

Many thanks in advance,

Per Cramer

 

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,

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

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 97 / 2000 compatibility -
I am trying to set up a database as part of the company Intranet (which needs to be ready for next Tuesday - ulp). The problem is as follows: - The company has a mixture of Access 97 and 2000, but they need to both access the same database. Solutions I am thinking about are as follo

Data Object with Access 2000 -
I can't use access 2000. In this forum, Angelfire, helps me with DAO, recommending me to use DAO 3.6, it did work, actually I can use Database object with 2000. Now, I have another problem : I want to use the Data object, but it doesn't work with Access 2000, What can I do ? Th

Access 97 --> Access 2000 -
I have done a Access database with Access 97. Here at my work, we use Access 2000 and Access 97. How do I do if I wanna use the same Accessdatabase to the both versions. Access 2000 and Access 97? Now I get this error: You can't make changes to the database objects in the databa

can't get rs.maxrecords to work with ADO & Access 2000 -
Try as I might, I can not get the MaxRecords property to work. I am on a Win 2000 machine with Access 2000. I am using ADO 2.5 I have tried to create a system DSN with the Access database and set a cn to that but when I do rs.MaxRecords = 2...it just ignores it. I've also tri

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

Data control with Access 2000 -
Hi all, I am using VB5 with the Data Control but am having difficulty connecting to an Access 2000 D/base. Is the control compatible with Access 2000 ? If so how can I get it to work ?? If the control cannot be used with Access 2000 is there any other controls or ways to conne

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

Worried (Distributing a VB-Access program) -
Hello, I have developed a visual basic 6 educational program, that gets its information from an access 2000 mdb file. (The users only get info from the db, and do not write to it) The program is quite complicated, it has graphs, a lot of graphics and so on, yet it runs without

For vbKnight...................... -
....had a look at your code fror compacting Access dbs. Does this work with an Access 2000 database connected through DAO, am having problems with getting this to work with our code that was fine for Access 97. Haven't tried your code as yet, out on site and they don't have Access 2000

Data Controls w/ Access 2000 -
Hi, I recently moved a fairly large VB6/Access '97 system over to VB6/Access 2000. Almost everything seems to work fine after I converted the database to an Access 2000 one except for the datacontrols. They generate an error that says: 'unrecognized database format database.mdb'

wich Access version do I need. -
I have Visual Basic V 6.0 and Microsoft Access 2000 but when a Try to use a Database created in access into a VB program I got this mesage "Run-Timer error '3343' unrecognized database format" I know that means than VB 6.0 can't work with that version of Access. Wich Acc

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

MDAC question -
At the moment I'm using VB6 with Access 97, so I am installing MDAC 2.1 with the application I have written. I'm using 2.1 as I had problems with 2.5 ages ago. I'm sure I can't use it with Access97, something to do with Access 2000. Anyway I'm soon to be developing with VB6 and

VB6 / Access97 /Access 2000 -
I built a VB6 app that interfaces with a Access 97 DB on our LAN. My problem is that one individual has access 2000 loaded on his PC and my app does not work with him. Any suggestions? Thanks

AddItem doesn't work in Access 2000 -
Hi, I have a function (see below): Private Sub PopulateCboYear() Dim iYear As Integer For iYear = 1900 To Year(Now()) cboYear.AddItem (iYear) Next End Sub When I call PopulateCboYear, 4-digit years are populated to a combo box on the main form. The code w

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.)

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

Access 2000 in VB6 -
Is it possible to enable VB6 to read Access 2000 databases. I've tried to use Access 2k dbs in my projects, but it wont work.

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

Problem opening Access 2000 docs With VB 6 .... -
i have a program that opens access 97 docs and read from them etc... now i uinstalled access 2000 and modifgied the dbs and thus saving them in the access 2000 fromat ... As a consequence Vb6 Returns "unrecognised Format" .... anything ican do other than unistalling acc

SQL 6 to 2000 -
I have data gathering hw/sw that says it works with SQL Server 6 and Access 97. We are buying SQL Server 2000. Would the program work with SQL 2000 without any problems? (IE is SQL 2000 backwards compatible with 6?) Thanks, Josh

**Resolved ** Crystal Reports, VB6 and Access 2000 DB -
I am trying to use Crystal Reports that shipped with VB6 to generate some reports for my database that uses an Access 2000 database. When I try to design the report I keep getting an message asking me for a database password . The database isn't passworded though. Works fine with Ac

Access 97 to Access 2000 Problems -
A post similar to this was posted by NethBD, who is someone I work with. We still do not have this problem worked out. Reports for VB created in Access 97. Try and run those reports on a machine with 2000, and you get this error: "Microsoft access can't start because there i

OpenDatabase not working in Access 2000 -
Ok well the problem is that the following code used to work for an Access 97 database, but it doesn't want to work for me now that I have moved to Access 2000. Set db = wrkJet.OpenDatabase(Me.TxtPath, True, False) The error message that I get is unrecognised database format. I

System Date for Access 2000 -
I have a query where I want to pull only those records where The field for QuoteDate <=( Todays Date - 12 months). I have located Edate but Access 2000 seems to have a problem with this. In ORACLE I would just perform a calculation on SYSDATE - "12 months from now"

Use of Access 2000 Forms -
Is it possible to use an Access 2000 Form for data entry/updating that is called from VB. Have many Access forms that work well that I need to tie together using a VB application. Any suggestions -- I keep hitting a brick wall Thanks

Database Quiry -
hi, I am having problems with access 2000 and vb6 where it wont read the database that i create, it says invalid database or something similar, does anyone know if sp4 makes it work, or does anybody know of any other way i can get a datbase to work in vb6, preferably using access 20

Install Shield Issues. -
OK, I know this is only vaguely related to VB, but I was wondering if someone could help me out please?!? I have written an Access 2000 VBA project. It's all code driven (ie. No queries or anything like that!), hence my tenuous link to VB! I am trying to deploy my project using I

Why do Access files Bloat when using ADO -
I had a similar prob. VB6, ADO, Access 2000 did some database work through code (SQL) and the DB Size increased by 300% of its compacted size and slowed to a grind. I could not compact it due to other users being in the DB so after days of trying different stuffs I converted the DB to

Joining MS Access 2000 DB Tables -
I am encountering a problem in the MS Access 2000 Database tables. I had designed the tables in MS Access 2000 application. I did all my home-work there, that is: 1. Created the tables 2. Created the Primary keys 3. Edited the Relationships to enforce data integrity 4. and

Using the Data Control with Access 2000 -
Hi. I noticed that the Data Control cannot work with Access 2000 databases unless you set the data control content by code. This method works pretty well, but for some reasons, I cannot go with this solution. I want to know if there is any data control version that will allow me to u

Implementing Access 2000 -
hi, I have created an applicatin that uses Access 2000 as a backend. While installing the application on the end users machine , is there any way that i can use the ACCESS database ("use": as in access the data in the database) without actually having ACCESS 2000 installed

Access 97--2000 -
Hi all. I have run into a snag. I created a program at home. At work, they run Access 97. I am using 2000. I did not convert the database, and used DAO in my app. It works great at home. But when I installed the package on a machine at work, it wouldn't read the database. I made sure t

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

Calling Reports & Forms from Access 2000 -
I'm a newbie VB programmer and need assistance. Background: I have a application design with VB 6.0 front-end and a MS-Access 2000 back-end. I have created MS-Access 2000 forms with buttons that in turn call up in MS-Access 2000 reports on the same database. Problem/Question: How

EXEC FILES IN ACCESS 2000 -
1. Does anyone know any software to generate an EXE FILE using ACCESS 2000 and where i can get it? 2. Why when i am running a MDE and i closed the app, access 2000 show me all forms, tables and reports desegned by me?

vb5 and Access 2000 -
Ok have an app written in vb5 which works correctly with Access 97. However if l try the same app with Access 2000 am getting an "unrecognised database error" message. The apps references include Access 9 so am unsure why it does not like 2000. Any ideas?