473,698 Members | 2,571 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

not able to make changes in table

HI,
I have created a database in MS access97.Also i have a program which
would access the database and get me the required record and
data.Later I upgraded to MS access 2000.Now I have two problems.

1.I am able to access the database through my program after including
the version details (Afxgetstatemod ule which I found from groups
only).But I am not able to open the database to make changes.When I
open the table I get warning that I will not be able to make changes
with the current version.I tried converting to Access 2000,and I am
able to make changes.But then I am not able to access the converted
database from my program.I have tried by including and w/o including
the version details (Afxgetstatemod ule ).

2.I also tried creating a new database in Access2000 and access
through my program including the Afxgetstatemodu le function.I get
error "Unable to open database".If I dont include Afxgetstatemodu le
functionality my program crashes at Db.open();
I cannot trace what the problem is..I am not able to understand why my
program is not opening a database created in access 2000 itself.
can anyone get me a solution for thses two problems?

regards,
AKR.
Nov 12 '05 #1
0 1283

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

58
4670
by: Jeff_Relf | last post by:
Hi Tom, You showed: << private const string PHONE_LIST = "495.1000__424.1111___(206)564-5555_1.800.325.3333"; static void Main( string args ) { foreach (string phoneNumber in Regex.Split (PHONE_LIST, "_+")) { Console.WriteLine (phoneNumber); } } Output: 495.1000
1
1529
by: bbrazeau | last post by:
I have a database mdb. that I've made a mde. file out of. When I try to run the file I get a can't make changes requested, would create duplicate values error. Now for the facts: The open event on the form that produces the error supplies a new number to a primary key field by looking at the highest exsisting number in that field and incrementing by 1, similar to the way an autonumber would work. The code finds the record with the highest...
2
1278
by: Derek Davlut | last post by:
I have a make table query that I make a table from. I want the rows to continue increasing but it overwrites the data each time. I am gathering data from a linked source and to collect statistical data for analysis in a table over a period of time. Any help would be appreciated. thanks.
0
1820
by: LesM | last post by:
This is a change of behaviour between Access 2000 SP3 and Access 2002 SP3. I have Progress table that is linked via ODBC into Access using OpenLink Lite for Progress 9.0b. For over a year, using Access 2000 under Win98, I have been running a Make Table or Append query against this ODBC table and producing an extracted Access table. Any fields that are NULL on the source ODBC table show as NULL on the output table. The query also has an...
3
2748
by: Hanif Merali | last post by:
Hello, I'm having some difficulties creating a make table query. The source table which I'm basing the make table query has the fields: CIF BusLine1-2001 BusLine1-2002 BusLine1-2003 BusLine1-2004
16
11563
by: Miguel Dias Moura | last post by:
Hello, i have 5 panels in an ASP.net / VB page. The panel 1 is visible the other 4 are NOT visible. I also have 5 images: image 1, image 2, ..., image5. When i click one of the images, image N, the panel N becomes visible and all the other invisible.
3
10687
by: teedilo | last post by:
Our MS SQL (SQL Server 2000) DBA has database privileges locked down pretty tightly. We end users/developers do not have administrator privileges for most databases. That arrangement has worked out OK for the most part. However, it's a bit aggravating that we can't even create our own database diagrams. When we attempt to do so (in Enterprise Manager), we get a dialog that says "You do not have sufficient privilege to create a new...
5
5614
by: keith.culpepper | last post by:
Can anyone please provide some assistance with a trigger that I need to develop. Here is the situation: Our program updates depend on database updates. If a client receives the program update and the database hasn't been updated then it's a huge mess. No problem right? Just document the changes to the database that you made and then send out a SQL script that will update the database with the program update right? Well, I don't...
5
2504
by: sdupont | last post by:
Hi all, I have a need to make a guest registry, and try as I might, I just can't seem to get the right programming in the expression builder. Here is what I need to do. I have one field labeled "Accommodations" which has a drop down listing of 7 codes. I need to then a) assign a dollar value to each code, then b) place that dollar amount in the "Accommodations Fee" field. Also one of the codes has 3 subtypes each with a different
0
8610
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9170
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8902
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7740
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6528
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4372
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4623
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3052
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2007
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.