f



Problem mit der Abfrageansicht bei Access 2000 / SQL Server 2000

Ich habe eine Datenbank die vorher komplett in Access war. Jetzt habe
ich die Tabellen von Access auf SQL-Server portiert und in die
Access-Datenbank als Frontend verkn�pft.

Jetzt habe ich folgendes Problem:
Vorher als die Tabelle noch in der Access-Datenbank war konnte ich die
Tabelle (oder auch eine Abfrage darauf) �ffnen und wenn ich durch die
Tabelle gescrollt habe indem ich den Scrollbalken auf der rechten
bewegt habe (nicht mit dem Mausrad!) wurden w�hrend des Scrollens die
Inhalte der Datens�tze in echtzeit mitbewegt. Bei der Variante wo die
Tabellen jetzt auf dem SQL-Server liegen ist es nun so, dass der
Inhalt der Datens�tze erst dann angezeigt wird, wenn ich mit dem
Scrollbalken wieder anhalte (w�hrend des Scrollvorgangs selber wird
also immer das Bild mit den Ursprungsdatens�tzen angezeigt)
Hat jemand eine Idee ob es m�glich ist, die "alte" Funktionalit�t
durch Einstellungen von Access oder SQL-Server wieder hin zu kriegen?
Ich habe schon nach Einstellungen gesucht, die bewirken, dass man beim
�ffnen sofort die ganze Tabelle geladen wird oder sowas �hnliches,
aber ich hab nichts derartiges gefunden.

Vielen Dank im Voraus.
Matthias J�rgens
0
3/18/2005 11:15:18 AM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

0 Replies
508 Views

Similar Articles

[PageSpeed] 55

Reply:

Similar Artilces:

Converting SQL Server 2000 query to MS Access 2000 query
Hello! I am trying to convert a query written for SQL Server 2000 database tables, to a MS Access query. Here is what I have in SQL Server: SELECT t2.*, CASE WHEN t2.QType = '3' THEN t1.Note ELSE CASE WHEN t2.QType = '2' THEN CASE WHEN CONVERT(varchar(100), t1.ANumber) = '1' THEN 'Yes' ELSE 'No' END ELSE CASE WHEN CONVERT(varchar(5), t2.Qnumber)+'.' + CONVERT(varchar(5), t1.ANumber) = t2.SubQ THEN 'Selected' ELSE 'Not Selected' END END END AS Client_Response FROM (SELECT * FROM ClientAnswer WHER...

Sql Server 2000 linked server to Access 97/2000 incompatability
We are experiencing a problem with Sql Server 2000 linking to an Access 97 file. We have two machines that link to this .mdb file, and we recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. The link on this upgraded machine no longer works, giving this message: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Cannot open a database created with a previous version of your application.] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize r...

Migrating From Access 2000 To SQl Server 2000
Hi, I have developed an application using VB 6 (SP 5), MS Access 2000 and Crystal Reports 9. I migrated from from access to SQl Server 2000. This wasn't a problem as i could import all the tables to SQL Server. Also, i could make VB6 talk to SQl Server. The problem arsies when i run my application. The sql syntax for access seems to be different than that for SQL Server. A simple example being: In access boolean datatype is true/false ,whereas in SQL Server the boolean equivalent is bit (numerical 1 or 0). These kind of issues are causing problems and most queries don't run. Would ...

what is equivalent of format(date) function of MS Access in MS Sql Server 2000
Hi All, I am facing a problem with a sql what i used in MS Access but its not returning the same result in MS Sql Server 2000. Here i am giving the sql: SELECT TOP 3 format( MY_DATE, "dddd mm, yyyy" ) FROM MY_TAB WHERE MY_ID=1 The above sql in ACCESS return me the date in below format in one column: Friday 09, 2003 But in Sql server 2000 i am not getting the same format eventhough i am using convert function, date part function etc. Please if you find the solution would be helpful for me.. Thanks Hoque Hi If you field is a datetime, you can use the CONVERT function to conver...

ODBC connection
Hello all! I have such question to all of you. I have some tables linked from MS SQL Server 2000. Is time of processing query based on these linked tables from MS SQL Server 2000, faster or slower than the time of processing the same query based on tables, which are not linked but imported to MS Access? Can you answer this question? Thank you in advance for posts Marcin from Poland. On Tue, 19 Apr 2005 17:23:48 +0200, "Kamyk" <marcinzmyslowski@poczta.onet.pl> wrote: >Hello all! > >I have such question to all of you. >I have some tables linked from MS SQL Server 2000. Is time of processing >query >based on these linked tables from MS SQL Server 2000, faster or slower than >the time of processing the same query based on tables, which are not linked >but >imported to MS Access? > >Can you answer this question? > >Thank you in advance for posts >Marcin from Poland. > That depends on a lot of things... The most obvious thing it depends on is the size of the result set. In a client/server arrangement, you want to keep result sizes down, and do aggregation and filtering on the server. Next, how many people will be sharing the back-end data. Access slows down as soon as 2 people are sharing a JET back-end, but the server won't have this limitation. On the other hand, if the server is too slow, or you're trying to use MSDE with more users than it's optimized for, the server will be slow. There are m...

Access MS SQL Server 2000?
------_=_NextPart_001_01C3B4EB.13FA7080 Content-Type: text/plain; charset="iso-8859-1" Hello Guys, How can I access MS SQL Server 2000 database from Ruby? Is there a library I can use? Lennie De Villiers ------_=_NextPart_001_01C3B4EB.13FA7080-- Lennie DeVilliers wrote: > Hello Guys, > > How can I access MS SQL Server 2000 database from Ruby? Is there a library I > can use? > > Lennie De Villiers > > Check sqlrelay: http://sqlrelay.sourceforge.net/ I tested it a very short time only (I think with a MS SQL 2000, not even sure;-), so I can...

MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and the MS SQL 2000 Server JDBC driver. I have installed and configured the MS SQL Server 2000 onto two computers, which reside on the same network. (In fact, these two computers comprise the entire network). The network server (computer name=SUNCDS1), and the lone node (SUNCDS2), each have their own SQL Server 2000 instance. The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2. It may be worthwhile to mention that the SUNCDS2 instance on the Enterprise console does not show the SQL Server Agent as being started, but I can navigate to the SUNCDS2 databases, and display the table information. If I try to start the SQL Server Agent for SUNCDS2, I receive the message "Access is Denied". The enterprise console on the SUNCDS2 machine indeed shows the SQL Server Agent as being started. I have written a sample Java application that uses both the MS SQL Server ODBC driver and a JDBC type 4 driver (MS SQL Server 2000 JDBC) to establish a connection to the SUNCDS2 instance. This application resides on the SUNCDS1 network server. The ODBC driver will connect to SUNCDS2 instance wihout a problem. The JDBC driver does not connect to SUNCDS2. The JDBC driver will, however, connect to the local SQL Server instance that resides on SUNCDS1. Following are the code snippet to est...

Access 2000 Linked to SQL Server 2000, openRecordset error
I'm trying to access data in vba using the openrecordset command. The data in on a SQL Server 2000 database, and I have linked tables to that data. the Table I'm trying to access is one of these linked tables, and my codes is as follows: Set vRS = CurrentDb.OpenRecordset(tbl_DataCommentLog) when this line is executed I get the error: "Run-time error '3622': You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an Identity column. " so I changed my code to: Set vRS = CurrentDb.OpenRecordset(vSQL, , dbseeChanges) Wh...

Accessing a passworded MS Access 2000 database in Crystal Reports
Can anybody give me some code that I can put in to my VB6 app to open a passworded Access database in the Crystal Reports 8.5 RDC? I see so many examples - none of which seem to work for me. I am using a native connection in Crystal ( pdbdao.dll). My current code is : Dim Report As New crPrintPreview Dim crTable As CRAXDRT.DatabaseTable Private Sub Form_Load() Set crTable = Report.Database.Tables.Item(1) varpath = CurDir crTable.Location = varpath & "\OrderManager.mdb" CRViewer1.ReportSource = Report CRViewer1.ViewReport End Sub All I receive is the message "Error opening file xxxxxxx etc" and then "Open Database session failed" Appreciate any help! Peter Tyler ...

Moving data from MS SQL Server 2000 or MS Access XP to UniData 5.2.9
Complete MVDBMS neophyte -I may not even qualify at the neophyte level- that needs a simple solution to move data -in batch initially...real-time eventually- from RDBMSs such as SQL Server 2000 or Access 2002 (XP) to UniData 5.2.9. Any leads would be greatly appreciated. --Ryan N. Ryan N. wrote: > Complete MVDBMS neophyte -I may not even qualify at the neophyte > level- that needs a simple solution to move data -in batch > initially...real-time eventually- from RDBMSs such as SQL Server 2000 > or Access 2002 (XP) to UniData 5.2.9. > > Any leads would be greatly appreciated. > > --Ryan N. Accuterm, look at the Excel option, and then the scripting to move it on. www.asent.com Better yet, most likely you need a consultant. Check out Tony Gravagno. He's good at building interfaces, and has most of the tools pre-built. He is at http:(no spam)//nebula-rnd.com/ get rid of the (no spam) HTH, Patrick <;=) "(Latimerp)" <"(Latimerp)"@comcast.net> wrote: >Ryan N. wrote: >> Complete MVDBMS neophyte -I may not even qualify at the neophyte >> level- that needs a simple solution to move data -in batch >> initially...real-time eventually- from RDBMSs such as SQL Server 2000 >> or Access 2002 (XP) to UniData 5.2.9. >> >> Any leads would be greatly appreciated. >> >> --Ryan N. > >Accuterm, look at the Excel option, and then t...

ODBC access to sql 2000 server problem
Hi, all, I have license for SAS/ACCESS Interface to ODBC and SAS/ACCESS Interface to ORACLE. Last time to access Oracle table on my WAN, at a remote physical location, I ran this piece of code and it worked fine. " libname so oracle user=ann7 password=1234 path='@oracle.world'; proc sql; create stay as select * from so.table1; quit; run ;" Since I don't have ACCESS Interface to SQL server, I tried different code this time " proc setinit; run ; option obs=10000; libname m2 '/money/sasdata/'; libname ms odbc NOPROMPT="DRIVER=SQ...

Re: Access MS SQL Server 2000?
Hello, Thank you! This page: http://sqlrelay.sourceforge.net/sqlrelay/programming/rubydbi.html Show how to use SQLRelay with Ruby. Lennie De Villiers -----Original Message----- Lennie DeVilliers wrote: > Hello Guys, > > How can I access MS SQL Server 2000 database from Ruby? Is there a library I > can use? > > Lennie De Villiers > > Check sqlrelay: http://sqlrelay.sourceforge.net/ I tested it a very short time only (I think with a MS SQL 2000, not even sure;-), so I can't say more about it. Raph ...

Accessing a passworded MS Access 2000 database in Crystal Reports #2
Can anybody give me some code that I can put in to my VB6 app to open a passworded Access database in the Crystal Reports 8.5 RDC? I see so many examples - none of which seem to work for me. I am using a native connection in Crystal ( pdbdao.dll). My current code is : Dim Report As New crPrintPreview Dim crTable As CRAXDRT.DatabaseTable Private Sub Form_Load() Set crTable = Report.Database.Tables.Item(1) varpath = CurDir crTable.Location = varpath & "\OrderManager.mdb" CRViewer1.ReportSource = Report CRViewer1.ViewReport End Sub All I receive is the message "Error opening file xxxxxxx etc" and then "Open Database session failed" Appreciate any help! Peter Tyler ...

Performance Issues
Hi, Simple question: A customer has an application using Access 2000 frontend and SQL Server 2000 backend. Data connection is over ODBC. There are almost 250 concurrent users and is growing. Have they squeezed everything out of Access? Should the move to a VB.Net frontend taken place ages ago? Cheers Mike Hi Mike, I just completed a similar conversion if that's what you're thinking of doing. We converted 100 forms, 60 access reports and 15,000 lines of code "TO" 100 forms, 60 crystal reports, and 75,000 lines of VB.net code. It was a nightmare. We spent a good 50 perc...

Too few parameters expected 2 error occurs after migrating "MS Access 2000" to "MS SQL Server"
Hello all I get Too few parameters expected 2 error and "The MS Jet Database engine cannot find the input table or query "myTempTablename". Make sure it exists and that its name is spelled correctly. 3078" after I migrated "MS Access 2000" to "MS SQL Server 2000" and relinked all linked tables. The front-end interface of my application is MS Access 2000. The back-end is MS SQL Server 2000. After I migrated the database and relinked all linked tables, "Too few parameters expected 2" and "input table or query "myTempTablename" 3078" error occurs. I found a article in Microsoft website. The "Too few parameter" error occurs because the limitation of the MS Access ODBC driver. If it is, any solution? Thanks in advance Cheers Bon Hi Bon, If you mean you are getting the error when you are trying to relink the tables through ODBC, then the problem could be - if your table(s) had a memo field, that sql server picked up the memo field as a varchar, and Access is trying to read a text field that exceeds 255 chars. You need to go to Query Analyzer (sql server QA) and run some queries against the offending table to see what the text length is in your varchar fields in the sql server table. And if Sql Server did pick up an Access memo field as a Sql Server Text field, ODBC can't read Sql Server Text fields. If any of the varchar fields exceeds 250 chars (for me I get errors after exceeding 250 cha...

Using both IS NULL and IS NOT NULL in Access 2000 Pass Through Query (for SQL Server 2000)
Hello, I'm in the process of changing our 'normal' Access 2000 update queries to Update Pass Through Queries. We have a SQL server 2000 database and we're using an Access 2000 database as our front end. In the criteria of one of our update query fields, we use both the isnull(field1) and Not IsNull(field2) then Field3, otherwise, set the updated field as null. Here's my converted Pass Through Query : UPDATE Vsel SET VSel.Cert1 = IIf(IsNull(VSel.Cert1), RenArch.Cert1), VSel.Cert2 = IIf(IsNull(VSel.Cert2), RenArch.Cert2), VSel.Cert3 = IIf(IsNull(VSel.Cert3), RenArch.Cert3), VSel.Cert4 = IIf(IsNull(VSel.Cert4), RenArch.Cert4), VSel.Cert1ExpDt = IIf(IsNull(BDACmpltDt) AND IS NOT NULL (RenArch.Cert1), RenArch.CDDt), VSel.Cert2ExpDt = IIf(IsNull(BOMSADtIssd) AND IS NOT NULL (RenArch.Cert2), RenArch.CDDt), VSel.Cert3ExpDt = IIf(IsNull(BDPMADtIssd) AND IS NOT NULL (RenArch.Cert3), RenArch.CDDt), VSel.Cert4ExpDt = IIf(IsNull(BOACmpltDt) AND IS NOT NULL (RenArch.Cert4), RenArch.CDDt), VSel.BDACmpltDt = IIf(IsNull(BDACmpltDt), RenArch.Cert1DOC), VSel.BOACmpltDt = IIf(IsNull(BOACmpltDt), RenArch.Cert4DOC), VSel.BDPMADtIssd = IIf(IsNull(BDPMADtIssd), RenArch.Cert3DOC), VSel.BOMSADtIssd = IIf(IsNull(BOMSADtIssd), RenArch.Cert2DOC) FROM VSel INNER JOIN RenArch ON VSel.SSN = RenArch.SSN This is the original criteria in the access update query for line #6 (when I start to use both is null and is not null) IIf(IsNull([BDACmpltDt]) And Not IsNull([RenArch].[Cert1]),[Re...

Re: ODBC access to sql 2000 server problem
Does your server have an ODBC driver for mssql? I believe you'll need one. On windows it comes with the OS but on unix you've got to get them from (I think) 3rd parties... HTH, -Roy -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of sophe88@YAHOO.COM Sent: Monday, December 04, 2006 1:34 PM To: SAS-L@LISTSERV.UGA.EDU Subject: ODBC access to sql 2000 server problem Hi, all, I have license for SAS/ACCESS Interface to ODBC and SAS/ACCESS Interface to ORACLE. Last time to access Oracle table on my WAN, at a remote physical location, I ran this piece of code and it worked fine. " libname so oracle user=ann7 password=1234 path='@oracle.world'; proc sql; create stay as select * from so.table1; quit; run ;" Since I don't have ACCESS Interface to SQL server, I tried different code this time " proc setinit; run ; option obs=10000; libname m2 '/money/sasdata/'; libname ms odbc NOPROMPT="DRIVER=SQL Server; SERVER=boney;DATABASE=visa;" user=sas password=1234; proc sql; create table m2.invoice10k as select * from ms.invoice;quit ; " I have error message " .... Could not load /opt/sas913m3/sasexe/sasodb (34 images loaded) Error: ld.so.1: sas: fatal: libodbc.so: open failed: No such file or directory... ERROR: The SAS/ACCESS Interface to ODBC cannot be loaded. The SASODB code appendage could not be loaded. ERROR: Error in t...

Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to migrate the backend database from MS Access 2000 to MS SQL Server 2000. However, I want to keep the MS Access 2000 interface. Would it be possible? If I migrate the MS Access to SQL Server, would the queries, back-end VBA, macro, tables and forms be affected? Do I need to change the MS Access data type to SQL server supported data type? Which tool I can use to do the migration? Upsizing wizard or exporting...

Converting Access 2000 to SQL Server (docmd.GoToRecord problem)
Hi, I'm converting ACCESS 2000 database to SQL Server. I have .adp project. In the .mdb I have form where I'll insert rows into two different tables using docmd.GoToRecod ,,acNewRec. In .adp form's Record source property I have following Stored Procedure (in .mdb there were similar query). Stored Procedure: Insert_sp SELECT [Table1].[Name], [Table2].[Name] as Name2 FROM Table1 INNER JOIN Table2 ON Table1.Name = Table2.Name; return In the form I have command button (Command4) and its code in VBA Private Sub Command4_Click() On Error GoTo Err_Command4_Click DoCmd....

Re: ODBC access to sql 2000 server problem #2
It looks like the Mono project includes odbc that can go from UNIX to SQL Server. (or so they say, I haven't tried it myself.) It looks like the have a package for download for Solaris 8 anyway. http://www.mono-project.com/Main_Page -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of sophe88@YAHOO.COM Sent: Monday, December 04, 2006 2:34 PM To: SAS-L@LISTSERV.UGA.EDU Subject: ODBC access to sql 2000 server problem Hi, all, I have license for SAS/ACCESS Interface to ODBC and SAS/ACCESS Interface to ORACLE. Last time to access Oracle table on my WAN, at a remote physical location, I ran this piece of code and it worked fine. " libname so oracle user=ann7 password=1234 path='@oracle.world'; proc sql; create stay as select * from so.table1; quit; run ;" Since I don't have ACCESS Interface to SQL server, I tried different code this time " proc setinit; run ; option obs=10000; libname m2 '/money/sasdata/'; libname ms odbc NOPROMPT="DRIVER=SQL Server; SERVER=boney;DATABASE=visa;" user=sas password=1234; proc sql; create table m2.invoice10k as select * from ms.invoice;quit ; " I have error message " .... Could not load /opt/sas913m3/sasexe/sasodb (34 images loaded) Error: ld.so.1: sas: fatal: libodbc.so: open failed: No such file or directory... ERROR: The SAS/ACCESS Interface to ODBC cannot be loaded. The SASODB code a...

SQL works in Access but not in SQL Server 2000 ! Why?
I am new to MS SQL Server. I have SELECT statement which works fine using Access 2000 but when I try to use this in SQL Server 2000 I get error. Statement works fine in Access 2000: SELECT Field1, Field2 FROM Table WHERE Field1 & Field2 LIKE '%keyword1%' AND Field1 & Field2 LIKE '%keyword2%' Error I get using SQL Server 2000: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data type. Operator equals boolean AND, type equals float. Does anyone know how to fix this? I would really appreciate ...

ODBC problem with Access Queries to linked tables to SQL Server 2000
Help, I have an Access database with link tables to a SQL Server 2000 database. When I run the following query, it works OK: SELECT Format([Issue_Date],"mmmm yyyy") AS DateTXT, Sum([Current_State]='CANCELLED') AS Cancelled FROM ECNDetails GROUP BY Format([Issue_Date],"mmmm yyyy") However, when I try to run this one, it fails: SELECT Issue_Date AS DateTXT, Sum([Current_State]='CANCELLED') AS Cancelled FROM ECNDetails GROUP BY Issue_Date It gives me two messages: "ODBC -- call Failed" and "[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='. (#170)" I have checked the DSN for the linked tables. I have re-created all the linked tables. Both password and authorities are correct. So, can anybody tell me why the first query would run but the second wouldn't. Any help is very much appreciated. Thanks. Sorry, I forgot to mention I'm talking about Access 97 ... boris_amj@hotmail.com wrote: > Help, > > I have an Access database with link tables to a SQL Server 2000 > database. > > When I run the following query, it works OK: > > SELECT Format([Issue_Date],"mmmm yyyy") AS DateTXT, > Sum([Current_State]='CANCELLED') AS Cancelled > FROM ECNDetails > GROUP BY Format([Issue_Date],"mmmm yyyy") > > > However, when I try to run this one, it fails: >...

Why upgrade to MS SQL Server (be it 2000 or 2005) from Access (say, 97)?
Probably this question has been asked hundreds of times and yet net search has not generated satisfactory enough answer, at least, to me. And OK, let's assume your organization has more than 200 employees, just one measure to indicate that it's not small and data processing needs are quite extensive (for both OLTP and OLAP). We've heard so much about concurrency support, stability and performance. Are there any real persuasive paper out there to talk about it? Now, let me also put it in another perspective, say, you're a Microsoft sql server sales guy or gal for that matte...

JDBC/ODBC user issues accessing SQL Server 2000 database
I have a SQL Server 2000 database which has been restored from a backup. The restored database contained a user called "X", which is the owner of all of the tables in the database. When I try to execute an SQL SELECT against any of the tables in the database (using the JDBC/ODBC bridge) I get an "invalid object name" error - it seems to be requiring me to prefix the table names with "X.", even though the ODBC data source has been set up with the user "X". If I use MS-Access to link to the database using the same ODBC data source I can see the tables - each is listed with an X. prefix. If I connect from the SQL Server command line using the X user/login I can refer to tables without using the X prexix on table names. The only thing that may have complicated things is that I used sp_change_users_login to associate the X user with the X login. Can anyone tell me how I can avoid having to prexix my table names with the user name, when I should be connecting with that user name? TIA for any help, Isabel ITM wrote: > I have a SQL Server 2000 database which has been restored from a > backup. The restored database contained a user called "X", which is > the owner of all of the tables in the database. When I try to execute > an SQL SELECT against any of the tables in the database (using the > JDBC/ODBC bridge) I get an "invalid object name" error - it seems to > be requi...

Web resources about - Problem mit der Abfrageansicht bei Access 2000 / SQL Server 2000 - comp.databases.ms-access

Resources last updated: 3/21/2016 10:52:12 AM