SET NOCOUNT ON

You have made changes to the table since you linked them. Delete the links and relink the tables.

Populate the bit field with 0

In all SQL always qualify the reference, ie. dbo.tablename.

Public Function Remove_Dbo_()

For Each tdf In CurrentDb.TableDefs

Do While left(tdf.NAME, 4) = "dbo_"

tdf.NAME = Mid(tdf.NAME, 5)

Loop

Next tdf

End Function

Create a file DSN to link to your SQL Server db. Use the DSN to link to your sql tables, as long as they are named the same as your...

Some time when the user changes his password ADOM and Novell will not sync and the user will get this error. A reboot resolves the problem.

Private Sub Form_Load()

If Time() >= #2:09:00 PM# And Time() <= #2:20:00 PM# Then

call TestModule

End If

Application.Quit

End Sub

Make TestModule public and just call it don't use RunCommand

Public Sub TestModule()

Create a form that loads when the database is opened. Use this code in the form load event. Open the database using scheduler. If you schedule it for 1 am...

This code uses the file system object to compact an Access database on close if over 35Mb .

Public Sub ShowFileSize(filespec)

On Error GoTo Err_handler

    Dim fs As Object

    Dim f As...