Search results for query: *

Quick follow-up to my previous post -- I took a quick look at pass-through queries, and it appears that they will only talk to an ODBC server (such as SQL server), and our back-end database only lives on a network shared directory as a file, not as something that has a server running. Is there...

Hi ssecca, Thanks for your reply. Please clarify what you mean by "pass through queries" and "moduleless forms" Thanks! asp

Ok, unfortunately, the indexing doesn't seem to make much of an appreciable difference on the speed of changing records when the filter and/or sort is active (still 3 or 4 seconds). And I didn't have any NAMEAUTOCORRECT boxes on options/general (I'm on 97 -- are they somewhere else?) The...

Hi all, A little background: my database has a main table of projects with about 275 records (with about 40 fields per record), and each record is linked with 0 to 10 additional issue records in another table (depending on the project). I've got a form for entering and modifying the data...

Hi all, Since this is a question related to Windows Explorer, I hope this is the correct forum! In trying to make my Outlook messages more bearable, I wanted to try to save the individual messages directly on the disk in their own directory (rather than using .pst files). Outlook lets me drag...

Thanks for the reminder -- I had forgotten about being able to get the login ID without using access security -- that's almost certainly the best way to do it, and I'll put the table in the back-end db. Could you please post the code/other ideas for how to get the login ID? I'd really...

Hi, I've got a DB that multiple people access, and would like to have a flexible way for them to have a query that they can easily input the parameters for (such as looking for their own name in the contact information, etc). I know I can do this directly in the query, having it prompt them...

Hi, I'm fairly new to FrontPage, and have a bunch of pages on a development server. So far, all is going well. However, I just found out that later today the development server will be inaccessible for about a week and a half, and I'd like to be able to continue to develop on my local...

Hi, I know this may sound like a bizarre question, but our corporate IT group is not allowing frames on pages, so the standard way of doing it is to create tables to do the layout. A typical page will include a standard module that has a "tabbed-style" navigation bar across the...

Hi, I've got some files on a network share drive, and we'd like to have everyone be able to read them, but only a select few be able to write/modify them. I've used the security tab on the files and can't seem to get it to work. What I've done is used the "everyone" group and set...

Hi, I've got an Access97 DB that I've split into frontend/backend databases, which works fine. Since about half of the people accessing the db are on Access2k, I converted the frontend to 2k also, so both types of users can operate natively (the backend is in 97 format, of course). However...

Thanks! That does what I was looking for! asp

Hi, I've got a report that's almost where I need it to be, but need some summary information on it that I'm not sure how to accumulate. Here's the situation: I've got multiple Organizations (I'll use 2 for simplicity -- call them AA and BB), each with Divisions (call them A and B). Each of...

Hi, I need to create a field in a query that will be a logical "OR" of other fields -- for example, if I have a table with the following structure: Name Issue1 Issue2 Issue3 I'd like a query that will return Name HasIssues where HasIssues is True if any of the issues exists, False...

Ok, the access security sounds like a good idea. What about the mde vs mdb issue? Thanks for your reply! asp

Hi all, I've got a DB that has about 5-10 users, some with access97 and some with access2000. The DB is in 97 format, which has caused a little trouble with the 2000 users. I've heard that splitting the DB into a frontend/backend makes for a much more robust database, so I did that and it...

That did it! Thanks a bunch! asp

Hi, I just started trying to secure a database, which seemed to work well, and then wanted to convert it to a front end/back end arrangement. So I ran the database splitter -- no problems encountered. Then I tried to make the .mde file, and got an error on one of my functions that the...

What is the best way to propagate the mdw file? I've just started setting up a DB for secure access, and have the mdw file locally on my machine. Since the DB will eventually live on a network drive,what is the best strategy for giving others access to the mdw file? Thanks! asp

Hi folks! I just inherited a DB that is used by about 10-20 different people, and each one in the past has created their own queries and reports (many of them very similar to each other, but with slight differences, such as filtering on different names, projects, etc). I've changed the DB...