By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,171 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Rowset does not support scrolling backward

P: 11
Hello,

I have created a split database. The frontend interface is working fine on some systems. But on one system it shows this error: "rowset does not support scrolling backward". I am not sure why it is creating problem on only one system at this time.

I tested it on my system and on others too. Never showed any error while submitting or retrieving a record.

Please help!!!
Oct 8 '12 #1
Share this Question
Share on Google+
9 Replies


zmbd
Expert Mod 5K+
P: 5,286
SriKumar,
You have not given us any information about the PCs, the database, what it is that you are attempting to accomplish and so forth...

Please read your post, from the viewpoint of someone that knows nothing about your organization, could you provide an answer?
Oct 8 '12 #2

TheSmileyCoder
Expert Mod 100+
P: 2,321
I have to agree with zmbd here. First off, that doesn't sound like a error message I have ever heard before. Access usually user RECORDSETs not Rowsets. This might just be because you are translating it from a non-english language.

Are you using a normal form, with a recordsource? Are you using code? Macros?

What version of access are used on the systems? What versions of access is the frontend and backend file?
Oct 8 '12 #3

P: 11
Sorry zmbd & TheSmileyCoder about half information on my problem.
Database: Access Database with tables - DB is in one of the shared folders.
Frontend UI: Access file with forms and VBA codes.
Both FE & BE are in Access 2010 version.

Code used is:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Check_Click()
  2.    Dim Conn As ADODB.Connection
  3.    Dim myRecordset As ADODB.Recordset
  4.    Dim strConn, str As String
  5.  
  6.     DoCmd.OpenForm "Retrieving", acNormal, "", "", acReadOnly, acNormal
  7.     DoCmd.RepaintObject acForm, "Retrieving"
  8.  
  9. Set Conn = New ADODB.Connection
  10. Set myRecordset = New ADODB.Recordset
  11. Conn.Provider = "Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=sree"
  12. Conn.Open "Path to DB"
  13. myRecordset.Open "Select * From [Tracker DB]", Conn, adOpenStatic, adLockOptimistic
  14.  
  15. SChk.SetFocus
  16. str = SChk.Value
  17. myRecordset.Find "[Reference Number] = " & SChk
  18. Me.STCH.Visible = False
  19.  
  20. If Not myRecordset.EOF Then
  21.     Me.Box.Visible = True
  22.     Me.UON.Visible = True
  23.     PON.Value = myRecordset(1)
  24.     Me.PON.Locked = True
  25.     Line.Value = myRecordset(2)
  26.     Me.Line.Locked = True
  27.     SchLine.Value = myRecordset(3)
  28.     Me.Line.Locked = True
  29.     PN.Value = myRecordset(4)
  30.     Me.PN.Locked = True
  31.     Plt.Value = myRecordset(27)
  32.     CQ.Value = myRecordset(5)
  33.     USDCost.Value = myRecordset(6)
  34.     USDCFU.Value = myRecordset(7)
  35.     Exchange.Value = myRecordset(8)
  36.     USDTCF.Value = myRecordset(9)
  37.     Cost.Value = myRecordset(80)
  38.     CF.Value = myRecordset(81)
  39.     TCF.Value = myRecordset(82)
  40.     POD.Value = myRecordset(11)
  41.     POCD.Value = myRecordset(12)
  42.     SN.Value = myRecordset(13)
  43.     Backup.Value = myRecordset(14)
  44.     ReOp.Value = myRecordset(17)
  45.     DisPo.Value = myRecordset(18)
  46.     SSBOQty.Value = myRecordset(19)
  47.     SSBOFee.Value = myRecordset(20)
  48.     Status.Value = myRecordset(21)
  49.     Comments.Value = myRecordset(22)
  50.     UON.Value = myRecordset(24)
  51.  
  52. Else
  53.     DoCmd.Close acForm, "Retrieving"
  54.     Me.RefNAvaiAlert.Visible = True
  55.     Me.AlertRef.Visible = True
  56.     Me.AlertRef.Value = Form_PO_Cancellation_Request_Form.SChk
  57.     Me.SChk.Value = ""
  58.  
  59. End If
  60. myRecordset.Close
  61.  
  62. DoCmd.Close acForm, "Retrieving"
  63. End Sub
  64.  
Please let me know if you need more information on the issue.
Thanks much for your comments.. :)
Oct 9 '12 #4

TheSmileyCoder
Expert Mod 100+
P: 2,321
Thanks for those updates. Much better.

A final bit of missing information from your post now is on which line the error occures.

I am going to assume the "Path to DB" is just you censoring your information. :)

I usually use DAO instead of ADODB, so I am a bit rusty on the cursors, but I thought the static cursor did support backwords scrolling, so thats odd. Also as far as I can see you only perform one navigation which would have to be forwards...

I am going to guess the error occurs on line 17, if not the following suggestions may not apply:
Try changing the recordset type, just to make sure if that makes a difference.
and / or
DAO has a FindFirst and a Findnext method, I can't recall if ADODB has the same, if it does you could try using those instead, and see if it makes a difference.
Oct 9 '12 #5

P: 11
Hey TheSmileyCoder,

As you mentioned, error occurs on line 17. I tried changing to FindFirst but it says: Compile Error: Method or data member not found.

Also, I have one question... This code works on many other systems but not on one system with whom we are facing this issue. Is there any solution you can recommend there?
Oct 9 '12 #6

TheSmileyCoder
Expert Mod 100+
P: 2,321
Hi SriKumar

The FindFirst is probably just in DAO then, and actually shouldn't matter as you explain its working on other systems.

Do each user have their own frontend on their own PC or do they share a frontend file on a network share?

If they have their own frontend file, try giving user a new frontend file (You probably allready have, but if haven't try it)

Other then that I can only give general vague advice really. Make sure that both you and the user in question has the same version of Access installed (including service packs). Make sure the user has all updates. Do you both use the same operating system version?

Does the user have the same rights as you (or other users) to the folder in which the backend resides?

Check that the user has the same version(s) of all referenced library's in the vba project.

Other then that....good luck
Oct 9 '12 #7

P: 11
Hi TheSmileyCoder,

Thanks much for quick response...
I will check all the points with that user and let you know on the outcome.
Oct 9 '12 #8

P: 11
Hi TheSmileyCoder,

I have checked all the points with the user.
  1. Do each user have their own frontend on their own PC or do they share a frontend file on a network share?

    - Yes, user has his own file on this desktop.
  2. If they have their own frontend file, try giving user a new frontend file (You probably allready have, but if haven't try it)

    - tried this one too.
  3. Other then that I can only give general vague advice really. Make sure that both you and the user in question has the same version of Access installed (including service packs). Make sure the user has all updates. Do you both use the same operating system version?

    - We both have same Access Version. But I developed this DB in WIN7 system and user have xp.
  4. Does the user have the same rights as you (or other users) to the folder in which the backend resides?

    - We both have change permission to the folder.
  5. Check that the user has the same version(s) of all referenced library's in the vba project.

    - Library references are matching.

Now I am stuck badly ... :(
Oct 15 '12 #9

TheSmileyCoder
Expert Mod 100+
P: 2,321
Im quite sorry to hear that. I really have little else to offer at this point.

Your other users do they also use Win XP or is this the only user who uses Win XP? (To be honest I don't think this is related, but I have nothing better to suggest)

Make sure that the user has a fully updated system. If nothing else helps, try to get him to reinstall access if possible.
Oct 15 '12 #10

Post your reply

Sign in to post your reply or Sign up for a free account.