Forums

This topic is locked

Login in using Auto Number field in Access - Data

Posted 05 Apr 2001 12:14:52
1
has voted
05 Apr 2001 12:14:52 Andrew Cook posted:
I want my users to login using a number which is generated in access using
an AUTONUMBER field and a password

I am using the standard MM login user behaviour.

I get this error when login in, I persume it is something to do with field
types ie text, number, date fields etc.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
expression.
/content/login.asp, line 21

I am ultimatley trying to get this work with Tom Muck's / UltraSuite
insert-retrieve ID behaviour, i can not get that to work either but I think
it may be connected to this error.

Any suggestions will be greatly appreciated as usual.

Andy Cook

Replies

Replied 14 May 2001 07:41:12
14 May 2001 07:41:12 DB Sims replied:
Did you every figure this out I am having the same challenge? Also can someone point me in the right direction for doing a login process like here at UDZone. When our agent login we need to display there personal info and I am stumped... All help appreciated!
Replied 14 May 2001 09:37:12
14 May 2001 09:37:12 Andrew Cook replied:
Sorry, I didn't although I have to address the situation soon so I will let you know if and when I figure it out.

Are you connected to DBS financial serverices?

Replied 14 May 2001 18:28:59
14 May 2001 18:28:59 DB Sims replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Are you connected to DBS financial serverices?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Finacial Service hmmm... I wish!!! Nah, just connected to my own finacials.
Replied 23 May 2001 08:09:37
23 May 2001 08:09:37 Quy To replied:
Let me know if you guys still need help with log-in and display personal information.


------------------------------------

www.DUresources.com
-------------------
Home of DUforum, DUpoll, DUrating & DUcomment

Reply to this topic