Search results

I want to save my current database for deployment, from and .mdb to an .mde. But I was wondering, when I want to update forms and such, do I need to convert it back to an .mdb to work with? If so, what is the process for that conversion and how to I bring the data if the conversion is not...

Just wondering if there's anything I should know ahead of time about splitting a database that has Workgroup security (i.e. is accessed via a shortcut through secured.mdw) already deployed. Is there anything special I should do/pay attention to? Thanks again!:)

167GB used, 324GB free on a 500 GB drive... Any other suggestions? It seems to be somewhat intermittent also if that helps.. The server is a 6.5 Netware server

Compact ReadOnly Error? Every morning I back up my databases and compact and repair them. The last few days, my backend has been giving me this error: "Microsoft Access can't delete L:\KEYSupport\Maintenance Agreements\KTBackEnd.mdb after compacting it. The compacted database has been named...

Timed Compaction, how? I've deployed a database recently, but want to schedule a compact and repair to run in the night before the backup - how do I accomplish this? Thanks again

How do I accomplish this with a secured database (shortcut points to secured.mdw)? BTW - thanks for all your help yesterday. I ended up going with the Microsoft solution because it was 2002 compliant without the DAO installations. It does the same trick, and is only dependent on an external...

Would this also work as effectively? http://support.microsoft.com/default.aspx?scid=kb;en-us;304408

Woo hoo All fixed http://jamiessoftware.tk/articles/daomodel.html

That site has some information about this: http://www.rogersaccesslibrary.com/References.htm I will continue to search for solutions

Autoeng, Also - would it have anything to do with me using OfficeXP (2002) Service Pack 2? Just thought I'd throw that out there. Everything in the database has worked very fluidly, except for this code. But I noticed it was meant for 2000, would that be the problem? Thanks again

I'll work on stripping the database, the lines of code it is having problems with are: Dim db As DAO.Database Dim snp As DAO.Recordset Set snp = db.OpenRecordset("Settings", dbOpenSnapshot) In both the Form_Load and Form_Timer sections

Nevermind, I figured it out and just put a requery in the afterupdate() and altered my query to rely on the initial box. Thanks :)

I'm having problems with the DAO portion of the code, where it initializes the connection in the top two lines. I'm also having compile errors with the set snp = line. Any suggestions as to why the errors are coming up. I copied the frm_ExitNow and pasted it into my forms. I created an...

Oops - to continue SQL query: SELECT ATHLETES.ID, ATHLETES.Last_Name, ATHLETES.First_name, ATHLETES.MI, ATHLETES.Sport FROM ATHLETES WHERE (((ATHLETES.Active)=True)); So, I should add a second listbox with just the Sports in it, then set the following...

Alright, I understand what you are saying. Here is what I have so far. In the AfterUpdate, the following runs from my listbox to bring up the appropriate record. ------- Private Sub List65_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs =...

Autoeng, I'm getting compile errors with the lines that have set DAO code as well as the "set snp = db." lines Do I need an extra module to make the LogOff code work? It looks like it would work fine (and the demo code works fine), but when I cut and paste it into my app, I'm having issues...

Perfect solution and easy code to implement - mucho gracias :) Any quick ideas on how to time it to log everyone out/run at midnight? I can use task scheduler for the batch file to run - but how to I set the logout code to run?

I want to make form updates and database modifications, what is the best way to accomplish this with a live database. If I have a production copy and a live copy, how do I swap the two when they are "Secured" with the Users and Groups permissions (i.e. Secured.mdw and a shortcut to open)...

Backing up with a batch file - foolproof? I've got a wonderful batch file I put together that I run at night to backup the whole directory in which the database and it's associated files are stored. However, my question is, for a restore, do I just copy that information back into the...

I have a listbox running a query of data, that is then used to select the records displayed on the form. I.e. First name, last name, Sport, etc.. When it's clicked on, the form moves to that ID and displays the appropriate data. I want to be able to put buttons on the side of the list box...