Replies

Ok, I’m a little busy at the moment, trying to get a project for work done, so I don’t have the time to modify the code for you. But here’s what you should do. Where it is opening the recordset, change that line to open a SQL statement that queries for that email address…then check for EOF/BOF. (Stay away from filters in a recordset….). If there is a record, close the recordset, and create the HTML you want to display, otherwise, close the recordset, reopen it (like the original line) add the record and display whatever you want for that.

To display different data to the user, use conditional formatting:

This text is displayed to the user if x=something, it’s HTML, so
would display to the end user as a line break

This is displayed if x doesn’t equal something

Within conditional formatting, you can ‘place’ variables into the html with like this:

Hello

hope this helps.

This shows some promise. Unfortunately, I’m swamped today, I’ve added that site to my favorites. If I figure out a way to ‘hook’ into AD, I’ll post my solution here.

That’s possible. Honestly, I have code that can get the data I am looking for. Wouldn’t be hard to modify the code so that I can set it as a service to ‘check’ for changes by doing comparisons. I just don’t want to have a service constantly checking AD. I actually have a service I wrote that does check AD for locked user accounts. Runs once a minute….very quick code. There are hooks for all sorts of things, was just hoping there was one for AD.

Thanks Joe, that did the trick. (Actually, I added the ‘In Folder’ field)

Cool, well if you have any specific questions, give me a holler.

Have you ever made an asp page?

What about the folder that the database is in?

Ok, so the account has nothing to do with Access itself, both the admin and the limited user are NT based accounts, and both are logging into the database with Admin (the default account). If that’s the case, then it’s not an Access issue, it’s a file permission issue. Create a .txt file in the same folder as the .mdb, then log in with the limited account, and see if they can change the contents of that .txt file.

google for request.cookie and response.cookie. The first ‘reads’ cookies from the web user, the other writes.

I started with Access 97, taught myself how to write VBA code, and about 2 years later decided to give asp a whack…haven’t turned back since. I love web interfaces, they have some distinct advantages over anything else (with only a few drawbacks).

If you have the MSDN installed, take a look at the ASP Built in Objects reference card. Pretty handy.

Sorry for the delay in replying, but you really shouldn’t use the IP address to identify something with a web user.

Instead, create a user id and set it as a cookie. Have each page check to see if a session object ‘exists’. If it does, that object is the user’s ‘id’. If not, check for a cookie (you can set and read web users local cookies for your sight) value.

Now, this is a stripped down version of actually having user accounts, where a user has a username and password. (using the cookies will work, but if someone wipes out their cookies, they’d get a ‘new’ account the next time.

What is the limited account? Are we talking an Access User Level Security account, or an NT account?

Thanks Hans. I hope I get a reply too. I haven’t found what I am looking for through google yet. I just need to know if it’s possible.

Thanks! I’ll try to be more active, just got too busy with work.

A lot of information has been posted already. Text fields are limited to 255 characters, because the first byte of storage represents how many characters will follow, so if there are 10 characters stored for the text in a field, in the actual .mdb file, where that field ‘starts’ will be one byte with the binary value of 10, followed by the 10 bytes representing the characters of the field. So Access never takes up more space then necessary for text fields, due to this prefix byte.

Memo fields, as already explained, are stored outside of the table structure (from the standpoint of the actual file structure of an .mdb). Size wise, however, Memo fields are in theory allowed to take up the entire space of the database. The 65k character limit is only applicable when the data is entered through the Access interface, such as a form, or table view. If you put data into a memo field programatically, you’re limited to the physical disk space limit of the .mdb (1 gig in 97, 2 gig in 2000 and later).

However, the main reason I am posting to this, is that there are other differences which should be taken into consideration when designing a database structure. First, Text fields can be indexed, Memo fields cannot (at least Access won’t index them…). So when data is entered into an indexed text field, doing a search in that field will have jet hit the index. Doing a search in a memo field will have Jet running through the entirety of every applicable memo field. If you have hundreds of megs of text, that’s a lot to run through.

Also Memo fields have some issues with queries. Off the top of my head, I know you can’t group by a memo field, you can with a text field.

Don’t misunderstand me, I use memo fields all the time. I use them when I have no idea how much text is going to be entered. If I know there’s a limit, I use a text field. and if the limit is over 255, but can be dealt with by multiple text fields, sometimes I’ll design the table to have multiple text fields, to include the indexing/querying capabilities of a text field.

A lot of methods posted. Personally, I prefer the ADO method (which will work for tables and queries):

Function GetDBTables()
On Error GoTo ErrorHandler
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
If DBConnect(cnn) Then
Set rs = cnn.OpenSchema(adSchemaTables)
Me.lstTables.Clear
rs.MoveFirst
Do Until rs.EOF = True
If Me.optTables Then
If rs.Fields(“TABLE_TYPE”) = “TABLE” Then Me.lstTables.AddItem rs.Fields(“TABLE_NAME”)
Else
If rs.Fields(“TABLE_TYPE”) = “VIEW” Then Me.lstTables.AddItem rs.Fields(“TABLE_NAME”)
End If
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
cnn.Close
Set cnn = Nothing
End If
Exit Function

ErrorHandler:
Err.Clear
End Function

This is right out of an application I wrote that builds classes in ASP from tables/queries. It’s displaying them in a listbox. And there are option buttons to display tables, or to display queries. The function DBConnect is essentially:

Function DBConnect(ByRef cnn as ADODB.Connection)
set cnn=new ADODB.connection
cnn.Provider=”Microsoft.Jet.OLEDB.4.0″
cnn.Open “C:SomePathSomeDatabase.mdb”
Exit function

However, you can connect that ‘cnn’, the connection object, to any database you want (Access, SQL Server, Oracle, etc), and it will list the tables for you.

I know, my website has been down for a few months, long story.

As for docs on regions, look up Region Function in the MSDN library.