ASP password protected database trouble

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built a website with login using ASP pages as per:

http://support.microsoft.com/default.aspx?scid=kb;en-us;825498

It works well when I use the simple table in the database as per
instructions but when I try to use my own table inside that database with
about 900 records I cannot enter the protected area The logon.asp page just
blanks the entries. I have used the same table name, field names and same
field definition as the original but still no go.

I could add the records by hand to the original table but it would be quite
tedious...

How can I create a table with all my records that the logon search in that
article would recognize?

Thanks,
EdH
 
Have you tried selecting the records in your table and copying and then pasting into the sample
database?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
If your DB has the same field names as the original just rename it to the same name as the original and File Import it into the same
folder as the original (overwriting it)

--




|I have built a website with login using ASP pages as per:
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;825498
|
| It works well when I use the simple table in the database as per
| instructions but when I try to use my own table inside that database with
| about 900 records I cannot enter the protected area The logon.asp page just
| blanks the entries. I have used the same table name, field names and same
| field definition as the original but still no go.
|
| I could add the records by hand to the original table but it would be quite
| tedious...
|
| How can I create a table with all my records that the logon search in that
| article would recognize?
|
| Thanks,
| EdH
|
 
Problem solved. Data in my table had a space in front of every record in
Usernames and passwords (probably badly coipied from Excell). When I delete
this one space from every field, of course it works.

NOTE: for your info when trying cut and paste fields from a large table to a
small one, the small table will only copy the same amount of records as it
already has. In other words if I try to paste a field with 100 records unto a
table with the same field but with only 5 records, it will only paste 5
records! Go figure.

Thanks for your help.
EdH
 
Problem solved. Data in my table had a space in front of every record in
Usernames and passwords (probably badly coipied from Excell). When I delete
this one space from every field, of course my table works fine. Also please
see my previous response to Thomas regarding cut and paste fields.

Thanks a lot for prompt response.
EdH
 
Never had that copying problem. I can regular paste any number of records into a table with a single
record or no records, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Back
Top