473,804 Members | 2,201 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

problem with MS Access 2003-SQL Server communication

Hi everyone,

Got one tiny problem; i've created database in SQL Server and I'm
using MS Access as a front-end to this database. Everything works fine
apart from one small thing: whenever I want to edit a field by adding
additional information to it, I can't do it. The only way is to delete
what that field contains and re-write everything from scratch.
I wonder if that can be related to some SQL Server settings or sth
else...

Thanks,

Maciej
Nov 13 '05 #1
1 1197
Maciej wrote:
Hi everyone,

Got one tiny problem; i've created database in SQL Server and I'm
using MS Access as a front-end to this database. Everything works fine
apart from one small thing: whenever I want to edit a field by adding
additional information to it, I can't do it. The only way is to delete
what that field contains and re-write everything from scratch.
I wonder if that can be related to some SQL Server settings or sth
else...


If you're having the difficulty I think you're having then check
Tools->Options->(one of the tabs I don't remember which)->Arrow key
behavior, set it to "Next Character"

--
Pretentious? Moi?
Nov 13 '05 #2

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

Similar topics

0
2418
by: Sabine Oebbecke | last post by:
Hi Experts! I have several forms and reports where controls get their values with 'Forms!MainForm!Control' or 'Forms!MainForm!Subform!Control' resp 'Forms!MainForm!Subform.Form!Control' which works without any problem in Acc97, 2000 and 2002, but now in Access 2003 there seem to be a problem with this. A user is working with my app, and he uses an Access 2002 MDE in an Access 2003 environment.
5
7866
by: j.mandala | last post by:
Someone is trying to run my Access 2002 database under Access 2003. He has had a number of problems: 1) i used the MSComCt2.ocx for it's Date and Time picker. I can't find it under 2003. Do I need to send it to them? 2) I have a function to fill a table with values, that store the page and column numbers of a display of staff members. I had him check the link to Microsoft DAO 3.6 Object Library under references, but it still won't...
12
8414
by: John | last post by:
Hi When I try to run access 97 I get the message 'Microsoft Access couldn't find file c:\windows\system32\system.mdw'. When I try to create the system.mdw file using workgroup administrator, I get the message 'An error has occurred at changing workgroup database.'. What is the problem and how can I fix it? Regards
3
1427
by: ljubo lecic via AccessMonster.com | last post by:
I have written a pretty complex ACCESS accounting aplication which is working fine.But under some circumstances I get this nasty error message: "Microsoft ACCESS has encauntered a problem and needs to close ..." Then I am asked if I will send an error report to Microsoft. I wonder If I can get the response from Microsoft explaining the reasons of errors .What is the best way to find an explanation of the error ?? For example: Today, I...
4
7476
by: pmhaupt2 | last post by:
I developed an Access 2003 program that will allow the user to produce a group of Word letters that merge with data records from an Access database. I created a mail merge Word document and associated it with a specific query in my Access database. My problem is that when I run my "create letters" button from an Access form, the program opens up Word correctly with the proper letter. However, the MailMerge toolbar in Word appears...
4
1571
by: DeanL | last post by:
Hi All, Having a problem developing an Access 97 database in Access 2003. The database needs to go out to a number of staff who will review it and recommend any changes but when I convert the database to access 97 format, it opens fine on my machine (with the usual convert or open message) but refuses to open on anyone elses PC with Access 97. A message pops up saying that the code needs to be recompiled for the version of VBA that is...
1
1642
by: funfair | last post by:
HI,EVERY ONE first problem, i have create a database in access 2003 it worked fine untill i have format my laptop . now im working on office 2003 on windows xp and i have norton 2006 but im facing a problem in opening some forms from command button a message appear the openform action was canceled and when i open them from the database window(form) there are problem in open event or change event or activate event the same file is work...
2
2969
by: alexgwinn | last post by:
Dear All, Yesterday, one of my students had a problem using MS Access 2003. Whilst editing a report in design view, using the Sorting and Grouping option, if they changed the Group Footer option to Yes, it locked out all the other options, which simply did not respond when clicked on. If the same person open the same database in MS Access 2000, on the same machine, it allowed the changes straight away. On then opening the same file back in...
6
2233
by: Bobby | last post by:
Hi, I'm not 100% sure that this is an Access problem. A friend of mine has an Access 2003 database. Occasionally he brings a copy to me so that I can import some of his data into my Access 2003 database. For years he has done this with no problems by bringing his copy on a CD. However, last week he put his database onto a memory stick and brought it to me. When I try to open the database, I get the error "The Visual Basic for...
0
1040
by: wassimdaccache | last post by:
Hello all I have designed a database on ms access 2003. Now I found that the user that he is going to use this database has ms access 2007 and unfortunately he doesn't want to use 2003 :S I tried to converted into ms access 2007. it makes me crazy :( because a lot of problem are made specially in forms and code. What is the best way to convert my 2003 access file without using my code ?
0
9715
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9595
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
10600
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...
0
10097
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9175
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
7642
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
6867
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5535
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...
3
3002
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.