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 edits data - whats worse is that the 2000 users don't have rights to re-enable them anyway.
If anyone has a solution to this please help as we are reaching a critical stage!
Thanks.
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
Upgrade code from Acess 2000 to Sql server -
hi,
I have written an application in VB 6.0 and Access 2000 (as Backend).The project basically deals with adding and editing records (that use Dates extensively). Due to an increase in the users of the system I want to upgrade to MSDE or even Sql Server.
What I wanted to know was tha
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
Moving Data from Access to SQL Server [Resolved -
I don't have direct access to the production environment. I am trying to move data from tables in the Access DB to the new SQL Server DB. Several of the tables have auto-incrimenting fields. I want the values assigned in Access to be carried over so I don't have to change values in
MS Access 97 Db Migration (Test to Production) -
Does a tool exist to move structural Db changes from a test Db to a production Db for MS Access 97? I know such migration tools exist for SQL Server but what about for Access?
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 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
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
SQL Migration Tool Quesiton -
hi
i have too much work at work, so i have decided to take my Company's data home to create a test Environment so that i can develop on weekends. am using SQL2000 at and Export the data to Access Database, after that when i get home ,i used SQL2005. i use Migration Assistant to Exp
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
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
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
.NET migrate -
Hi,
I've got task of writing plan to migrate from Access databases to SQL Server 2000 and VB .NET. Apart from me nobody else has experience of VB .NET - just VBA (Access). They have gained some knowledge of SQL Server.
Can people give me ideas of things I need to think about and plan
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
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
After migration to Windows 2003 can't access some files -
We set up here a new windows 2003 server (without ANY problems ).
we put in this server a hard disk from a windows 2000 server (the drive has data on it).
now we have the problem that we can't access some data on this hard drive.
(we have administration rights on this server).
b
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
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?
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
Data migration from Access 97 to SQL server2000 -
Hi,
I have a program done in full Access 97 with forms,querries,reports,macros. everything fully in Access97 mdb file. since because of database size its very difficult to continue. Is there anyway to migrate to SQLserver2000. if so any can give some sample codings. is there any way
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
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 ?
Access 2000 with Password -
I was able to set my Access DB with password and then using DAO to access the DB with no problem.
But it seems like te Access 2000 has more choices in setting the security. Could anybody let me know how should I set the password at Access 2000, then how do I access to the database
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.
connecting to access -
i cant get VB 5 to connect to ms access 2000
it connects to ms access 97 but not 2000
this is probably coz VB 5 is old
is there a way to fix this?
without using access 97?
thanks alot
Problem with VB and ACCESS 2000 -
Does anyone knows why i can call an ACCESS 97 APP from vb and i can not do it from ACCESS 2000?
From VB6 (and with the appropiate refrences installed) i used to call and ACCESS APP, now in ACCESS 2000, the VB program just display de ID FORM. This means: The APP has a main menu, th
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?
VB3.0 and Access'2000 -
Hi,
I am having a VB3.0 app. It is using Access'95. I want to port that app to Windows'2000 with Access'2000. I tried to rewrite it in VB5/6 using a migration wizard. But unfortunately, there are so many VBX files used and I have to do a lots of re-coding for which i don't have enou
Corrupt Access Database -
Hello all! I have an application that uses ADO to connect to an Access 97 database. My problem is that this database gets corrupted every now and then. We have deployed it on several PCs. Most of them have either Access 97 or Access 2000 installed. Our problem occurs mainly on Windows
VB 5.0 vs Access 2000 -
Should be an easy question.
I just upgraded to Access 2000. I was trying to write a quick application in VB 5.0 and I get a runtime 3343 error: Unrecognized Database Format.
Does VB5.0 not play with Access 2000 ??
Automatic Database Copy (Data Migration) -
Hi Everybody,
I wanted to know some information about Database programming which is liek Migration of Data from one type of Database to other type of Database.
Is it possible for us to automatically insert a record into SQL-Server or Access Database whenever we insert a record
Whwat to do that VB on WinXP would recognize "Access 2000" DB Resolved ! Thanks! -
Why VB6 on my WinXP do not recognizes "Access 2000" Data Base while:
VB6 on Win98 or Win 2000 recognizes "Access 2000" databases
MS Access version on my WinXP is ":Access 2000" and it recognizes "Access 2000" databases
Data1.Default Type prope
Why VB6 WinXP do not recognizes Access 2000 Data Base -
Why VB6 on my WinXP do not recognizes "Access 2000" Data Base while:
VB6 on Win98 or Win 2000 recognizes "Access 2000" databases
MS Access version on my WinXP is ":Access 2000" and it recognizes "Access 2000" databases
Data1.Default Type p
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.)
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'
Connecting Access 2000 with ADO -
hi all,
i m facing a problem of conecting to access 2000 with ADO.
previously i was using access 97 and i had no problems but then when i converted my access 97 file to access 2000 file i started gettng problems.
i have also changed the provider from MICROSOFT.JET.OLEDB.3.51 TO ..
Question about SQLServer Stored Procedure and Access 2000 -
I create a couple of stored procedures in SQL 2000 and was looking for similar functionalty in Access 2000. would this be the equivalent to Macros in Access and do they Access Macros understand standard sequel statements.
Thanks
DAO to ADO problem in Access 2000 -
I updated a database from Access 97 to Access 2000
In older version, in the module, I wrote
Dim db as Database
dim rs as Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("select * from employee")
Can you tell me how to write equivalent lines in Access 2000
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