Search results

What's a joinery company?

Not at all. As a matter of making your life easier, you should probably go with artificial (AKA surrogate) primary keys (with autonumber type). Make your current primary keys into unique indexes, then use the number type as your FK in the related table. Second, there is absolutely no reason...

No problems with the links. Looks like the problem is on your end.

You haven't really told us what you're trying to do. Referential integrity is there for a reason. If you don't need RI, turn it off. For a better answer, give more information. What do your tables look like? What are you trying to do and why?

We are updating our SQL Server this Wednesday night and a last minute issue has cropped up to threaten our implementation. We are changing all of our Access front ends to use DSN-less connections and won't be updating the DSNs on the client machines. We did a pretty thorough check of all the...

I think that's the word we were waiting for, Jon. Seems there is an issue with propagating the new IP address, I guess. The IP address I have is 64.57.208.119, which seems to work just fine.

Jon, you might want to hold off on taking any action. Further PMs from Rookie may indicate that at least one of their domain controllers had the old IP address in their hosts file. I don't really know the details so I suggest you wait until one of us hears back from Rookie. If this turns out...

MSAccessRookie tells me that he has not been able to access AWF since last week from his work. Here is one of the PMs I received from Rookie on my FB: BTW, the thing I recommended he do is to put AWF in his hosts file. This might explain why the traffic on AWF seems to be lower than before.

Odd; when I hovered over this topic, the popup never went away (until I moved the cursor away). In the past, I found the hover timeout to be too short. Somebody must have already fixed this. What about you? Has it changed for you, too?

Or store your "autonumber" in a different table with a FK from the table that references it.

You need to put your aggregate functions in your query, not in the text box. Then bind your text boxes to the aggregated fields within the query.

It is in common usage in the US, also.

Music Performers unknown Legend of Zelda: Ocarinia of Time Medley Composed by: Duncan Blickenstaff http://www.youtube.com/watch?v=0guFHIGxvmc&feature=related Notes: Nintendo, Zelda, Ocarina of Time, OOT, string quartet

I really like the "Hallelujah" versions. I especially like how that song just keeps growing. Here's one I've recently "found": Music Kansas Byzantium http://www.youtube.com/watch?v=QO2BJOadcjo Notes: orchestra/rock fusion

Check your help file for Timer Interval and the On Timer event (hint: you'll need a form).

The same way you distribute an MDB file: you give the MDE or ACCDE file to the user to begin using with Access (just like you would with a Word or Excel file, for instance). I recommend you do a lot of studying about the ramifications of maintaining a system that you've distributed as an...

Here's something else interesting: http://support.microsoft.com/kb/275561/en

Is there a where clause or join in your "query"? What happens when you do the delete from the back-end? Is the back-end Access or something else (SQL Server, MySQL, etc.)? If it's something else, you might consider doing a "truncate" instead of a "delete" (if there is no join or where...

Nice! I hope it goes well for you.

The new feature of UA is the Wiki. It is very appealing in concept, though I still come here instead of there.