Stuck in Set rs - How To Build a Secure Multi-User Database With User Logins, Permissions, and Logging in Microsoft Access


	Back to Security Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Stuck in Set rs

Jorge Restrepo

3 years ago

Hello,

I purchased the security seminar, and are trying to incorporate it into an existing database. I copied the UserT table as well as the login form to my database. Also copied the global module and updated the path and password. I am getting an error message as shown in the images. I appreciate your help.

	Jorge Restrepo OP @Reply 3 years ago

	Jorge Restrepo OP @Reply 3 years ago

	Adam Schwanz @Reply 3 years ago
Data type mismatch? Is Username set to a string? Also does it work if you don't line break it? I've seen some weird stuff happen in sql statements depending on where you break it.

	Jorge Restrepo OP @Reply 3 years ago
Username is short text, size 30. I used the original UserT. It generates the same message without the line break.

	John Davy @Reply 3 years ago
Did you create the txtUsername ? You may benefit from watching the video a second time.

	Jorge Restrepo OP @Reply 3 years ago
Thanks to both. I am going over the entire seminar again, thats the best way to take the best advantage of the course. One thing I notice is that the videos are several years old, I assume nothing has changed significantly.

	Adam Schwanz @Reply 3 years ago
Nope, everything in there should still be current. If anything has changed, there is usually an Addendum on the seminar page.

	Kevin Robertson @Reply 3 years ago
Have you tried using Double Double Quotes instead of single quotes? You could also try changing from dbOpenSnapshot to dbOpenDynaset.

	Jorge Restrepo OP @Reply 3 years ago
No, did not try that. Just started from scratch again and its a much better learning experience. The only thing I have noticed is that when the Login form is set to Modal the program freezes. I dont know if the form is hidden somewhere. That is no problem though.

	Scott Axton @Reply 3 years ago
Jorge, I'm just curious. Does the sample database and files that comes with the seminar work OK for you? It may be helpful to open your db and the sample db side by side to compare the two.

	Jorge Restrepo OP @Reply 3 years ago
Scott, sorry for the late reply, I missed your post. Yes the sample databases have been very useful and have worked very well for me as sources of code.

	Kevin Robertson @Reply 3 years ago
Access Security Seminar

	Jorge Restrepo OP @Reply 3 years ago
Tks, I just moved the question because I though it did not belong to this thread.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Security Seminar Lessons.

Next Unseen

New Feature: Comment Live View