[RESOLVED] msAccess

[MintFlavor]

hi everyone
I'm new here and trust i can get helpful tips and precious support from u all.
I will try to hepl as far as I can too.

I am currently designing a db with msAccess. It's been some time since I last designed db's and programmed with VB - thus, numerous problems to solve!!

Well, I have one form which would not display any control at all on running it !!! ANyone know any property causing this?

I am also using a login form to the applic. Since I am using a table of users, I need to check user input against records in my table with:

Dim oRs As ADODB.Recordset
Dim sConn As String
Dim sSQL As String

sConn = "Provider='SQLOLEDB';Data Source='MySqlServer';" & _
"Initial Catalog='inforGT';Integrated Security='SSPI';"

Set oRs = New ADODB.Recordset
oRs.CursorLocation = adUseClient
oRs.Open "tblUsers", objConn, adOpenStatic, adLockOptimistic, adCmdTable

oRs.Find ("' & Username.text & '")
oRs.Find ("' & Password.text & '")


If oRs.EOF Then
MsgBox "Check your username and password again.", vbOKOnly, "inforGT"
Exit Sub
Else
stDocName = "Menu"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If

However, this is generating an error 3001 "Arguments are of the wrong type, out of range or in conflict..." with the line:
oRs.Open "tblUsers", objConn, adOpenStatic, adLockOptimistic, adCmdTable

I have various ways to resolve this login feature I am not used with DAO and ADO.
If anyone has a complete sample code for a login form (plus, "Change my password" feature wud b just gr8!)- thanks

[Hack]

Welcome to the forums.

I have a question.

Your thread title says Ms Access, yet in your example you provide a connection string to SQL Server

sConn = "Provider='SQLOLEDB';Data Source='MySqlServer';" & _
"Initial Catalog='inforGT';Integrated Security='SSPI';"

Which database are you using?

[MintFlavor]

Hack

I collected codes from tutorials and assembled them to try use ADO.
I am using Ms access. Could u/someone correct the parameter values in the connection line? (if this is possible in msAccess vb)
Thanks.

[Always_Confused]

This site is very helpful

http://www.connectionstrings.com/

[Hack]

Ok. You also did not have a connection object declared, so I made one. In addition, I moved your variable declarations from wherever they were going to be to the declarations section of the form, and created them as Private. In my example, you connect to your db when your form opens. You, of course, can move that to whereever you feel would be approrpirate.

Option Explicit
 
Private ADOCn As ADODB.Connection
Private oRs As ADODB.Recordset
Private sConn As String
Private sSQL As String
 
Private Sub Form_Load
sConn = = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=c:\yourdbname.mdb;" & _
        "Persist Security Info=False"
 
Set ADOCn = New ADODB.Connection
ADOCn.ConnectionString = sConn
ADOCn.Open sConn
End Sub

[MintFlavor]

Hack thnx a lot for your connection codes.

However, the ultimate probem i'm having is the error 2147467259 ....
which says that the state set by admin to my db prevents the connection to be opened !

Now, can i do anything to overpass that or is it simply due to my limited rights as user on the network?

[si_the_geek]

Without knowing the exact error message we need to guess a bit.. hopefully one of these should provide the answer:

Does the database have a password? If so, you'll need to specify that in the connection string too.


Do you have permission to read and write the database file itself?
How about the folder it is in? (ie: can you create/edit files in that folder?)

[MintFlavor]

Error encountered:
The database has been placed in a state by user 'Admin' on machine 'Server01' that prevents it from being opened or locked.

There is no password for opening the db, and i do have rights on the db and the folder in which it is found.

[Hack]

It sounds like you have it open in Access at the same time your program is trying to open it.

I've done that before.

[MintFlavor]

It is working only when the form is loaded after the splashscreen an dnot when i manually open the login form.
This is ok because the login will always and only run after the splashscreen in practice.
Thanks