Search results

  1. G

    Question Database Auto-closing on Required Time

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

    Question How to password-protect my vb codes?

    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...
  3. G

    Does anyone know why

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

    Does anyone know why

    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...
  5. G

    ACL Surgery- What to expect

    Nice! I hope it goes well for you.
  6. G

    Changes to Access World Forums

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

    Models to market small business applications in UK

    Spam in siggy of post #4 reported.
  8. G

    Downsize to Access

    Yeah, I finally got it fixed about 1:00 AM this morning. Seems you cannot install SSE on a computer that has the same name as the installing user name. There are features not covered in SSE (according to MS literature) that will make this take a lot longer than one would think. The system I...
  9. G

    Changes to Access World Forums

    Reasonable from your perspective. All I can tell you is why I like this site over others. The look and feel of the site (mostly because of vBulletin) is especially neat and easy to read and administer, as a user. Though UA has improved considerably since their upgrade, it is still easier to...
  10. G

    Downsize to Access

    Your logic is impeccable. I do question your estimates, though. Time spent on this thread is pushing 10 minutes. Time trying (unsuccessfully) to install SSE this month is around 4 hours. I'm not sure if I can sell an install of SSE to my personal PC to my client, but I can sell a re-usable...
  11. G

    Downsize to Access

    I got db converter (with a space). It is a gnu GPL thing. The google description said it converted MS SQL to Access but the program read-me says it is for converting Access to MySQL and Oracle. When I force google to "dbconverter" (without a space), the definitions and sources of the files...
  12. G

    Downsize to Access

    I'm kind of doing that, but no, the names are not the same when importing. There is the naming problem and there are a LOT of tables (I don't want to go in and rename the tables by hand). I'm also worried about some views and stored procedures I am using and of course, the referential...
  13. G

    Downsize to Access

    I thought about that but I didn't want to invest a lot of time in the SS Express install. I am only doing this to reverse engineer the design of the database so I can design a replacement for it; I don't need anything like perfection or any need to use it after I am done with the analysis work...
  14. G

    Downsize to Access

    I'll check out dbConverter. Thanks, Banana!
  15. G

    Downsize to Access

    I am working on revamping a SQL Server database with an Access 2002 front end. I'd like to set up the environment on my computer at home but I really don't want to mess around with SQL Server variants on my computer (I am using Vista). Is there a quick and easy way to downsize a SQL Server...
  16. G

    Changes to Access World Forums

    I'm not sure what people will do but I'd say based on UA's response and based on our own samples and demo sections that it would go over well. I am in the process of writing some wikis for the UA site and was going to cross post them here.
  17. G

    Changes to Access World Forums

    Go for it. Also, I noticed that they have a Wiki over at UA now. Any chance the new software has a user managed Wiki?
  18. G

    Happy Birthday SQL_Hell

    Happy birthday, Mr. T.
  19. G

    Hoover effect, is it possible ?

    Man, I've been wracking my brain over this. I had no idea what a "hoover" effect was. I did all kinds of googles and just couldn't grok the concept. I assumed it was an April Fools type joke to capture a person's pointer on a control and not allow it to get very far away (similar to the old...
  20. G

    How to create a circular text box

    That is an interesting question. If it is just so you have a logo or something, you could just mock it up in photo shop or whatever and add it as a graphic. Maybe the OP is helping new businesses create logos (which one would think would be done better with a graphics tool). It is an...
Back
Top Bottom