Search results

I recently got a corrupt backend with the standard "unexpectedly quit Microsoft Access" message. This type of corruption (backend) has never happened before so I'm a little worried. I think I've taken the standard preventitive steps, but I'm hoping I can do more. I guess I have two questions...

Short Answer: Protect the backend. The frontend is optional. Long Answer: The tables are the most important part of any database. It's the foundation, and if someone screws it up then the whole thing crumbles. Intentional and unintentional malicious acts can ruin your day so make sure it's...

I thought maybe there was a way to update the tables using "ALTER TABLE", but I'm willing to accept the fact everyone has to log out first.

I know why it won't let me, somebody else has the database/table open, but I hate the solution. I'm working on a multiuser database and 3-5 people could have it open at once. I don't modify the backend very often, but when I do it's a pain to walk around the office and ask people to close the...

Thanks for the input. My third question is actually the most important. When modifying a well-established database I'm very hesitant to add new fields to tables. If all of the previous records are going to pad themselves I think I'd rather take a performance hit by adding a new table. The...

I found this page as a pretty good reference for field data types, but there's some things I still want to know. What's the per-character storage on a Memo and Hyperlink field (ignoring compression)? Are AutoNumber types (Long, Replication ID) unsigned? Do null [non-text] fields still use...

One IMPORTANT thing to keep in mind. Whatever you do make sure at least one user is a member of Admins. Only Admins can add/remove users and change group associations.

Version 2 I tried using continuous forms and it looks slightly better. The list box and subforms have the same color background now. Also, I put the bigger subform at the bottom. I still have an issue with the top subform having so much empty space. My main gripe is that this form doesn't...

Usually, I don't have a problem making halfway decent forms. I just don't like the way my latest form looks. I uploaded a picture. The columns labeled 'KeySet' are just there to show you how each control relates. They're not necessary and I'll probably hide them later. I think the controls...

I posted a single SQL statement that inserts and updates on a different website. I guess since I use this site more I'll post it here. This is a basic example of an insert/update query:UPDATE [Order Details] As OD1 RIGHT JOIN ( SELECT 10248 As [OrderID], 11 As [ProductID]...

How do you get tickcount? It's not in my libraries. I haven't seen very many cases where DateTime.Timer wasn't good enough, but I'd much rather have a millisecond-accurate timer.

I vaguely mentioned this earlier, but this query is going to be converted into a crosstab query that looks like this:EID ISM ABC BGP ========================== 111-11-1111 1 1 0 222-22-2222 0 1 1The difference between the running time of the select and crosstab query is...

Whoops! I found the problem. I never changed the names of the controls so my control names were the same as my field names. Everything works fine now.

I'm having a similar problem with a report. I want a 0 to give me "N" and a 1 to give me "Y". I've tried using IIf and Choose but the result is always "#Error".

Thanks for the suggestion, but I don't know if it's possible that way. Getting a list of classes taken is easy, but getting the classes not taken is harder. The only way I know how is to use an EXISTS or IN clause, but that requires me to use outer query data in the inner query. Crosstab...

I have a query worked out with the exact result I'm looking for, but it's kind of slow. Can someone find another way to write up this query?SELECT EID, ShortName, ClassID FROM ( SELECT Employee.EID, Class.CID, Class.ShortName FROM Employee, Class ) AS Temp1 LEFT JOIN [Class...

I forgot to include the relationship diagram. It's in PNG format which is a little uncommon so tell me if I need to include a JPG or GIF version.

I've had a lot of experiences creating databases but a questionnaire database is the most complicated I've had to create. I'm pretty close to finishing but I'd like to hear some comments if I'm doing something wrong. So if you agree with my design there's no need to tell me (unless you want...

I haven't looked thru all the posts but I like the overall structure Sergeant recommended (link). I'm working on a survey database right now and this is my current setup: Employee -------- EID (PK) FirstName LastName etc. Question -------- QID (PK; Auto) QuestionText (Memo) Configuration...

If I understand you correctly you have a regular and a 'light' version of a questionnaire. You want to load only the 'light' questions if the "light analysis" box is ticked and all the questions if it isn't ticked. If all that is correct it should be very easy. To load only the 'light'...