Search results for query: *

You should not join a db to a workgroup using the Workgroup administrator although you need to just to restore your system back to the default System.mdw group. As you have discovered, now you have to log into the workgroup just to open any [new or old] Access databases. You should always use...

Try... 'copy the file FileCopy ("C:\Databases\DB_A.mdb"), ("X:\Archive\DB_A.mdb") 'Delete the file Kill ("C:\Databases\DB_A.mdb") HTH

Was the db not properly shut shut down? Ctrl-Alt-Del is a db killer. Hardware failure, power failure, lost network connection can all create problems with a db. Have your tried the free Microsoft Jet Compact utility? Click on the link below for the version of Access you are using. For more...

What are the exact error messages you are getting when you try to open the db? Can you link to it? Have you tried importing all of the db objects into a "new" db? Have you tried decomiling the db?

I am glad that it works for you! Not sure where the semi-colon came from since I copied the command from a test sample I just made. HTH = hope this helps ;)

I always use this command with the sub that opens another form... DoCmd.Close acForm, Me.Name That will "generically" close the open from that is used to open another form. HTH

You need to test if the form in question is open and then close it if true. Here is a simple way to do that. Function IsFormOpen(strFormName As String) As Boolean IsFormOpen = (SysCmd(acSysCmdGetObjectState, acForm, strFormName) = acObjStateOpen) End Function Private Sub Command1_Click()...

try... Application.FollowHyperlink "http://www.msn.com", , True HTH

I suggest that you log into the secured db and then export all of the db objects into a new "unsecured" db. HTH

I know that Windows XP has the default set to "C:\Documents and Settings\[UsersNetworkName]\My Documents. The =Environ(?) function might help. Try this in a text box and see if it correclty returns the location and main directory where your \My Documents\ directory is located...