 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / February 2005Access 2003 Runtime and table deletion
I am building a front end / back end MDE application where most of the front end (FE) workstations would be running using Access 2003 runtime. I have a few tables that I would like to keep local (FE) for minor data manipulations which will require SQL deletes to keep this table fresh. My concern is keeping the FE from growing and growing. I don’t believe I can do Compact on Close with a Runtime environment. Would a drop table work any better? Any ideas? >I am building a front end / back end MDE application where most of the front >end (FE) workstations would be running using Access 2003 runtime. [quoted text clipped - 3 lines] >concern is keeping the FE from growing and growing. I dont believe I can do >Compact on Close with a Runtime environment. See the TempTables.MDB page at my website which illustrates how to use a temporary MDB in your app. http://www.granite.ab.ca/access/temptables.htm Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Hi Tony, Thanks! I have spent a good deal of time searching what others have to say, which led me to your web site and found a great deal of helpful ideas there. Some problems I haven't even thought of yet. I have added a class module that creates a temp database using ADOX and it works like a charm. No FE bloating here! > >I am building a front end / back end MDE application where most of the front > >end (FE) workstations would be running using Access 2003 runtime. [quoted text clipped - 15 lines] > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm >Thanks! I have spent a good deal of time searching what others have to say, >which led me to your web site and found a great deal of helpful ideas there. >Some problems I haven't even thought of yet. > >I have added a class module that creates a temp database using ADOX and it >works like a charm. No FE bloating here! Glad to hear my website is of some use. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.