Hi guys, Really confused right now i have used the following code in my project
Code:
App.TaskVisible = False
Dim db As Database
Dim rs As Recordset
Dim WS As Workspace
Set WS = DBEngine.Workspaces(0)
dbfile = (App.Path & "\donotdelete.mdb")
pwdstring = "passwordhere"
Set db = DBEngine.OpenDatabase(dbfile, False, False, ";PWD=" & pwdstring)
Set rs = db.OpenRecordset("Other", dbOpenTable)
YourUserName.Text = rs("twitteruser")
yourpassword.Text = rs("twitterpass")
and when i run it on my machine it diplays the stuff from the tables twitteruser and twitter pass in the 2 text boxes. How ever my friend installed my app and its giving him the error Run Time Error '3265' - Item not found in this collection ?
the above code is in form load!
Does anyone know why it's doing that?
Thanks , Happy New Year.