Serious Performance Problem

S

Sharkbyte

I posted previously about a performce loss when moving my development db from
an older laptop to my newer, faster laptop.

Where I am clearly able to see the problem occuring is when I am calling a
lookup form to select an Owner record. If I enter an OwnerID directly to the
main form, the code processes in less than 3 seconds. If I use the lookup
form, which copies the selected OwnerID to the main form, closes itself, and
runs the exact same code, I am seeing 7-8 second times...

I hope I am being clear, here, and have included the code for calling the
lookup form, processing the OwnerID select, and the code run from the module.
There are a couple of subforms being opened, but since all the same code is
being run, I would expect them to process the same...

Any help is greatly appreciated.


<<Code from directly entering OwnerID - main form>>
Private Sub txtOwnerID_AfterUpdate()

If IsNull(DLookup("ownerid", "qrymanageowners1")) Or DLookup("ownerid",
"qrymanageowners1") = "" Then
MsgBox "There is no Owner associated with this ID. Please re-enter."
Me.txtOwnerID = ""
Me.txtOwnerID.SetFocus
Else
pfOwners1
End If

End Sub

<<Code calling lookup form - main form>>
Private Sub cmdSearchOwner_Click()

gblOwnerSearch = "MO"
DoCmd.OpenForm "frmownersearch", , , , , acDialog

Me.txtOwnerID = gblNumber7
pfOwners1

End Sub

<<Code from lookup form>>
Private Sub OwnerAddress1_DblClick(Cancel As Integer)

gblNumber7 = Me.OwnerID

DoCmd.Close acForm, "frmownersearch"

End Sub

<<Code from module - pfOwners1>>
Function pfOwners1()

[Forms]![frmmanageowners]![cmdClose].SetFocus
[Forms]![frmmanageowners]![txtOwnerID].Enabled = False
[Forms]![frmmanageowners]![txtOwnerID].Locked = True
[Forms]![frmmanageowners]![txtOwnerNotes].Locked = False

DoCmd.Close acForm, "subfrmmanageowners"
DoCmd.OpenForm "subfrmmanageowners", , , , , acHidden

'Contract Information
Select Case gblNumber1 = IIf(IsNull(DMin("contracttypeid",
"qrymanageowners2")), 0, DMin("contracttypeid", "qrymanageowners2"))
Case 0
[Forms]![frmmanageowners]![cmbContractType] = ""
[Forms]![frmmanageowners]![txtRegHour] = ""
[Forms]![frmmanageowners]![txtOvtHour] = ""
[Forms]![frmmanageowners]![txtFirstHour] = ""
[Forms]![frmmanageowners]![txtPerMile] = ""
[Forms]![frmmanageowners]![txtTravelHour] = ""
Case Else
[Forms]![frmmanageowners]![cmbContractType].Requery
[Forms]![frmmanageowners]![cmbContractType] = gblNumber1

DoCmd.Close acForm, "subfrmManageowners4"
DoCmd.OpenForm "subfrmmanageowners4", , , , , acHidden
End Select

[Forms]![frmmanageowners]![subfrmManageOwners1].Requery
[Forms]![frmmanageowners]![subfrmManageOwners2].Requery

End Function
 
S

Sharkbyte

This was actually the first thing I did. I removed 5 aggregate functions and
replaced them with the call to "subfrmmanageowners4". The two that are left
return in the time expected. Actually, some of the "delay" is during the
OnOpen event of subfrmmanageowners4, so I will add that code.

Nothing, however, has been able to explain the loss in performance with an
increase in RAM and CPU.

<<Code for subfrmManageOwners4 - OnOpen event>>
Private Sub Form_Open(Cancel As Integer)

If Me.RegularHR = "" Or IsNull(Me.RegularHR) Then
[Forms]![frmmanageowners]![txtRegHour] = 0
Else
[Forms]![frmmanageowners]![txtRegHour] = Me.RegularHR
End If

If Me.EmergencyHR = "" Or IsNull(Me.EmergencyHR) Then
[Forms]![frmmanageowners]![txtOvtHour] = 0
Else
[Forms]![frmmanageowners]![txtOvtHour] = Me.EmergencyHR
End If

If IsNull(Me.TravelFirstHr) Or Me.TravelFirstHr = "" Then
[Forms]![frmmanageowners]![txtFirstHour] = 0
Else
[Forms]![frmmanageowners]![txtFirstHour] = Me.TravelFirstHr
End If

If IsNull(Me.PerMile) Or Me.PerMile = "" Then
[Forms]![frmmanageowners]![txtPerMile] = 0
Else
[Forms]![frmmanageowners]![txtPerMile] = Me.PerMile
End If

If IsNull(Me.TravelHR) Or Me.TravelHR = "" Then
[Forms]![frmmanageowners]![txtTravelHour] = 0
Else
[Forms]![frmmanageowners]![txtTravelHour] = Me.TravelHR
End If

End Sub
 
S

Sharkbyte

Is there a way to change Access' memory parameters? It appears that it may
be a memory issue.

I get a small drag on open of the lookup form, but get a serious delay if I
simply close the form. Like it is running everything through Page Swap
rather than RAM.

Any ideas?
 
A

a a r o n . k e m p f

Jet is tool old to run correctly on modern hardware
Jet is a slug.

Move to SQL Server-- with SQL 2005; it is just as easy to COPY A
SINGLE DB FILE as it is with Jet

of course, I'd just keep it on the lappie and publish DDL scripts
whenever you need to get stuff to the main server / desktop

-Aaron






I posted previously about a performce loss when moving my development db from
an older laptop to my newer, faster laptop.

Where I am clearly able to see the problem occuring is when I am calling a
lookup form to select an Owner record.  If I enter an OwnerID directly to the
main form, the code processes in less than 3 seconds.  If I use the lookup
form, which copies the selected OwnerID to the main form, closes itself, and
runs the exact same code, I am seeing 7-8 second times...

I hope I am being clear, here, and have included the code for calling the
lookup form, processing the OwnerID select, and the code run from the module.
 There are a couple of subforms being opened, but since all the same code is
being run, I would expect them to process the same...

Any help is greatly appreciated.

<<Code from  directly entering OwnerID - main form>>
Private Sub txtOwnerID_AfterUpdate()

    If IsNull(DLookup("ownerid", "qrymanageowners1")) Or DLookup("ownerid",
"qrymanageowners1") = "" Then
        MsgBox "There is no Owner associated with this ID.  Please re-enter."
        Me.txtOwnerID = ""
        Me.txtOwnerID.SetFocus
    Else
        pfOwners1
    End If

End Sub

<<Code calling lookup form - main form>>
Private Sub cmdSearchOwner_Click()

    gblOwnerSearch = "MO"
    DoCmd.OpenForm "frmownersearch", , , , , acDialog

    Me.txtOwnerID = gblNumber7
    pfOwners1

End Sub

<<Code from lookup form>>
Private Sub OwnerAddress1_DblClick(Cancel As Integer)

        gblNumber7 = Me.OwnerID

        DoCmd.Close acForm, "frmownersearch"

End Sub

<<Code from module - pfOwners1>>
Function pfOwners1()

    [Forms]![frmmanageowners]![cmdClose].SetFocus
    [Forms]![frmmanageowners]![txtOwnerID].Enabled = False
    [Forms]![frmmanageowners]![txtOwnerID].Locked = True
    [Forms]![frmmanageowners]![txtOwnerNotes].Locked = False

    DoCmd.Close acForm, "subfrmmanageowners"
    DoCmd.OpenForm "subfrmmanageowners", , , , , acHidden

    'Contract Information
        Select Case gblNumber1 = IIf(IsNull(DMin("contracttypeid",
"qrymanageowners2")), 0, DMin("contracttypeid", "qrymanageowners2"))
        Case 0
            [Forms]![frmmanageowners]![cmbContractType] = ""
            [Forms]![frmmanageowners]![txtRegHour] = ""
            [Forms]![frmmanageowners]![txtOvtHour] = ""
            [Forms]![frmmanageowners]![txtFirstHour] = ""
            [Forms]![frmmanageowners]![txtPerMile] = ""
            [Forms]![frmmanageowners]![txtTravelHour] = ""
        Case Else
            [Forms]![frmmanageowners]![cmbContractType].Requery
            [Forms]![frmmanageowners]![cmbContractType] = gblNumber1

            DoCmd.Close acForm, "subfrmManageowners4"
            DoCmd.OpenForm "subfrmmanageowners4", , , , , acHidden
        End Select

    [Forms]![frmmanageowners]![subfrmManageOwners1].Requery
    [Forms]![frmmanageowners]![subfrmManageOwners2].Requery

End Function
Click to expand...
 
A

a a r o n . k e m p f

jet databases are notoriously slow. Try not to use them
unless absolutely necessary.
 
A

a a r o n . k e m p f

nope; Jet doesn't really even UTILIZE memory.

but SQL Server will automatically cache queries and raw data-- in
memory.
Jet has been obsolete for a decade-- time to grow up!!!
 
S

Sharkbyte

Actually, Aaron, the db is SQL Server 2005. This is entirely front-end code
causing the problem.


a a r o n . k e m p f @ g m a i l . c o said:
Jet is tool old to run correctly on modern hardware
Jet is a slug.

Move to SQL Server-- with SQL 2005; it is just as easy to COPY A
SINGLE DB FILE as it is with Jet

of course, I'd just keep it on the lappie and publish DDL scripts
whenever you need to get stuff to the main server / desktop

-Aaron






I posted previously about a performce loss when moving my development db from
an older laptop to my newer, faster laptop.

Where I am clearly able to see the problem occuring is when I am calling a
lookup form to select an Owner record. If I enter an OwnerID directly to the
main form, the code processes in less than 3 seconds. If I use the lookup
form, which copies the selected OwnerID to the main form, closes itself, and
runs the exact same code, I am seeing 7-8 second times...

I hope I am being clear, here, and have included the code for calling the
lookup form, processing the OwnerID select, and the code run from the module.
There are a couple of subforms being opened, but since all the same code is
being run, I would expect them to process the same...

Any help is greatly appreciated.

<<Code from directly entering OwnerID - main form>>
Private Sub txtOwnerID_AfterUpdate()

If IsNull(DLookup("ownerid", "qrymanageowners1")) Or DLookup("ownerid",
"qrymanageowners1") = "" Then
MsgBox "There is no Owner associated with this ID. Please re-enter."
Me.txtOwnerID = ""
Me.txtOwnerID.SetFocus
Else
pfOwners1
End If

End Sub

<<Code calling lookup form - main form>>
Private Sub cmdSearchOwner_Click()

gblOwnerSearch = "MO"
DoCmd.OpenForm "frmownersearch", , , , , acDialog

Me.txtOwnerID = gblNumber7
pfOwners1

End Sub

<<Code from lookup form>>
Private Sub OwnerAddress1_DblClick(Cancel As Integer)

gblNumber7 = Me.OwnerID

DoCmd.Close acForm, "frmownersearch"

End Sub

<<Code from module - pfOwners1>>
Function pfOwners1()

[Forms]![frmmanageowners]![cmdClose].SetFocus
[Forms]![frmmanageowners]![txtOwnerID].Enabled = False
[Forms]![frmmanageowners]![txtOwnerID].Locked = True
[Forms]![frmmanageowners]![txtOwnerNotes].Locked = False

DoCmd.Close acForm, "subfrmmanageowners"
DoCmd.OpenForm "subfrmmanageowners", , , , , acHidden

'Contract Information
Select Case gblNumber1 = IIf(IsNull(DMin("contracttypeid",
"qrymanageowners2")), 0, DMin("contracttypeid", "qrymanageowners2"))
Case 0
[Forms]![frmmanageowners]![cmbContractType] = ""
[Forms]![frmmanageowners]![txtRegHour] = ""
[Forms]![frmmanageowners]![txtOvtHour] = ""
[Forms]![frmmanageowners]![txtFirstHour] = ""
[Forms]![frmmanageowners]![txtPerMile] = ""
[Forms]![frmmanageowners]![txtTravelHour] = ""
Case Else
[Forms]![frmmanageowners]![cmbContractType].Requery
[Forms]![frmmanageowners]![cmbContractType] = gblNumber1

DoCmd.Close acForm, "subfrmManageowners4"
DoCmd.OpenForm "subfrmmanageowners4", , , , , acHidden
End Select

[Forms]![frmmanageowners]![subfrmManageOwners1].Requery
[Forms]![frmmanageowners]![subfrmManageOwners2].Requery

End Function
Click to expand...
Click to expand...
 
A

a a r o n . k e m p f

yah it's because you're using SQL Server _DIVIDED_BY_ JET

throw away JET
upsize to Access Data Projects

SQL Server direct-- MUCH MUCH MUCH simpler

JET scans large tables every time you query them.
ADP is a tru client-server environment






Actually, Aaron, the db is SQL Server 2005.  This is entirely front-endcode
causing the problem.

a a r o n . k e m p f @ g m a i l . c o said:
Jet is tool old to run correctly on modern hardware
Jet is a slug.
Click to expand...
Move to SQL Server-- with SQL 2005; it is just as easy to COPY A
SINGLE DB FILE as it is with Jet
Click to expand...
of course, I'd just keep it on the lappie and publish DDL scripts
whenever you need to get stuff to the main server / desktop
-Aaron
Click to expand...

I posted previously about a performce loss when moving my developmentdb from
an older laptop to my newer, faster laptop.
Where I am clearly able to see the problem occuring is when I am calling a
lookup form to select an Owner record.  If I enter an OwnerID directly to the
main form, the code processes in less than 3 seconds.  If I use thelookup
form, which copies the selected OwnerID to the main form, closes itself, and
runs the exact same code, I am seeing 7-8 second times...
I hope I am being clear, here, and have included the code for callingthe
lookup form, processing the OwnerID select, and the code run from themodule.
 There are a couple of subforms being opened, but since all the same code is
being run, I would expect them to process the same...
Any help is greatly appreciated.
<<Code from  directly entering OwnerID - main form>>
Private Sub txtOwnerID_AfterUpdate()
    If IsNull(DLookup("ownerid", "qrymanageowners1")) Or DLookup("ownerid",
"qrymanageowners1") = "" Then
        MsgBox "There is no Owner associated with this ID.  Please re-enter."
        Me.txtOwnerID = ""
        Me.txtOwnerID.SetFocus
    Else
        pfOwners1
    End If
End Sub
<<Code calling lookup form - main form>>
Private Sub cmdSearchOwner_Click()
    gblOwnerSearch = "MO"
    DoCmd.OpenForm "frmownersearch", , , , , acDialog
    Me.txtOwnerID = gblNumber7
    pfOwners1
End Sub
<<Code from lookup form>>
Private Sub OwnerAddress1_DblClick(Cancel As Integer)
        gblNumber7 = Me.OwnerID
        DoCmd.Close acForm, "frmownersearch"
End Sub
<<Code from module - pfOwners1>>
Function pfOwners1()
    [Forms]![frmmanageowners]![cmdClose].SetFocus
    [Forms]![frmmanageowners]![txtOwnerID].Enabled = False
    [Forms]![frmmanageowners]![txtOwnerID].Locked = True
    [Forms]![frmmanageowners]![txtOwnerNotes].Locked = False
    DoCmd.Close acForm, "subfrmmanageowners"
    DoCmd.OpenForm "subfrmmanageowners", , , , , acHidden
    'Contract Information
        Select Case gblNumber1 = IIf(IsNull(DMin("contracttypeid",
"qrymanageowners2")), 0, DMin("contracttypeid", "qrymanageowners2"))
        Case 0
            [Forms]![frmmanageowners]![cmbContractType] = ""
            [Forms]![frmmanageowners]![txtRegHour] = ""
            [Forms]![frmmanageowners]![txtOvtHour] = ""
            [Forms]![frmmanageowners]![txtFirstHour] = ""
            [Forms]![frmmanageowners]![txtPerMile] = ""
            [Forms]![frmmanageowners]![txtTravelHour] =""
        Case Else
            [Forms]![frmmanageowners]![cmbContractType].Requery
            [Forms]![frmmanageowners]![cmbContractType] = gblNumber1
            DoCmd.Close acForm, "subfrmManageowners4"
            DoCmd.OpenForm "subfrmmanageowners4", , , , ,acHidden
        End Select
    [Forms]![frmmanageowners]![subfrmManageOwners1].Requery
    [Forms]![frmmanageowners]![subfrmManageOwners2].Requery
End Function
Click to expand...
Click to expand...
Click to expand...
 
A

a a r o n . k e m p f

yah it's because you're using SQL Server _DIVIDED_BY_ JET

throw away JET
upsize to Access Data Projects

SQL Server direct-- MUCH MUCH MUCH simpler

JET scans large tables every time you query them.
ADP is a tru client-server environment






Actually, Aaron, the db is SQL Server 2005.  This is entirely front-endcode
causing the problem.

a a r o n . k e m p f @ g m a i l . c o said:
Jet is tool old to run correctly on modern hardware
Jet is a slug.
Click to expand...
Move to SQL Server-- with SQL 2005; it is just as easy to COPY A
SINGLE DB FILE as it is with Jet
Click to expand...
of course, I'd just keep it on the lappie and publish DDL scripts
whenever you need to get stuff to the main server / desktop
-Aaron
Click to expand...

I posted previously about a performce loss when moving my developmentdb from
an older laptop to my newer, faster laptop.
Where I am clearly able to see the problem occuring is when I am calling a
lookup form to select an Owner record.  If I enter an OwnerID directly to the
main form, the code processes in less than 3 seconds.  If I use thelookup
form, which copies the selected OwnerID to the main form, closes itself, and
runs the exact same code, I am seeing 7-8 second times...
I hope I am being clear, here, and have included the code for callingthe
lookup form, processing the OwnerID select, and the code run from themodule.
 There are a couple of subforms being opened, but since all the same code is
being run, I would expect them to process the same...
Any help is greatly appreciated.
<<Code from  directly entering OwnerID - main form>>
Private Sub txtOwnerID_AfterUpdate()
    If IsNull(DLookup("ownerid", "qrymanageowners1")) Or DLookup("ownerid",
"qrymanageowners1") = "" Then
        MsgBox "There is no Owner associated with this ID.  Please re-enter."
        Me.txtOwnerID = ""
        Me.txtOwnerID.SetFocus
    Else
        pfOwners1
    End If
End Sub
<<Code calling lookup form - main form>>
Private Sub cmdSearchOwner_Click()
    gblOwnerSearch = "MO"
    DoCmd.OpenForm "frmownersearch", , , , , acDialog
    Me.txtOwnerID = gblNumber7
    pfOwners1
End Sub
<<Code from lookup form>>
Private Sub OwnerAddress1_DblClick(Cancel As Integer)
        gblNumber7 = Me.OwnerID
        DoCmd.Close acForm, "frmownersearch"
End Sub
<<Code from module - pfOwners1>>
Function pfOwners1()
    [Forms]![frmmanageowners]![cmdClose].SetFocus
    [Forms]![frmmanageowners]![txtOwnerID].Enabled = False
    [Forms]![frmmanageowners]![txtOwnerID].Locked = True
    [Forms]![frmmanageowners]![txtOwnerNotes].Locked = False
    DoCmd.Close acForm, "subfrmmanageowners"
    DoCmd.OpenForm "subfrmmanageowners", , , , , acHidden
    'Contract Information
        Select Case gblNumber1 = IIf(IsNull(DMin("contracttypeid",
"qrymanageowners2")), 0, DMin("contracttypeid", "qrymanageowners2"))
        Case 0
            [Forms]![frmmanageowners]![cmbContractType] = ""
            [Forms]![frmmanageowners]![txtRegHour] = ""
            [Forms]![frmmanageowners]![txtOvtHour] = ""
            [Forms]![frmmanageowners]![txtFirstHour] = ""
            [Forms]![frmmanageowners]![txtPerMile] = ""
            [Forms]![frmmanageowners]![txtTravelHour] =""
        Case Else
            [Forms]![frmmanageowners]![cmbContractType].Requery
            [Forms]![frmmanageowners]![cmbContractType] = gblNumber1
            DoCmd.Close acForm, "subfrmManageowners4"
            DoCmd.OpenForm "subfrmmanageowners4", , , , ,acHidden
        End Select
    [Forms]![frmmanageowners]![subfrmManageOwners1].Requery
    [Forms]![frmmanageowners]![subfrmManageOwners2].Requery
End Function
Click to expand...
Click to expand...
Click to expand...
 
A

a a r o n . k e m p f

yah it's because you're using SQL Server _DIVIDED_BY_ JET

throw away JET
upsize to Access Data Projects

SQL Server direct-- MUCH MUCH MUCH simpler

JET scans large tables every time you query them.
ADP is a tru client-server environment







yah it's because you're using SQL Server _DIVIDED_BY_ JET

throw away JET
upsize to Access Data Projects

SQL Server direct-- MUCH MUCH MUCH simpler

JET scans large tables every time you query them.
ADP is a tru client-server environment

Actually, Aaron, the db is SQL Server 2005.  This is entirely front-end code
causing the problem.
Click to expand...
Jet is tool old to run correctly on modern hardware
Jet is a slug.
Move to SQL Server-- with SQL 2005; it is just as easy to COPY A
SINGLE DB FILE as it is with Jet
of course, I'd just keep it on the lappie and publish DDL scripts
whenever you need to get stuff to the main server / desktop
-Aaron
I posted previously about a performce loss when moving my development db from
an older laptop to my newer, faster laptop.
Where I am clearly able to see the problem occuring is when I am calling a
lookup form to select an Owner record.  If I enter an OwnerID directly to the
main form, the code processes in less than 3 seconds.  If I use the lookup
form, which copies the selected OwnerID to the main form, closes itself, and
runs the exact same code, I am seeing 7-8 second times...
I hope I am being clear, here, and have included the code for calling the
lookup form, processing the OwnerID select, and the code run from the module.
 There are a couple of subforms being opened, but since all the same code is
being run, I would expect them to process the same...
Any help is greatly appreciated.
<<Code from  directly entering OwnerID - main form>>
Private Sub txtOwnerID_AfterUpdate()
    If IsNull(DLookup("ownerid", "qrymanageowners1")) Or DLookup("ownerid",
"qrymanageowners1") = "" Then
        MsgBox "There is no Owner associated with this ID.  Please re-enter."
        Me.txtOwnerID = ""
        Me.txtOwnerID.SetFocus
    Else
        pfOwners1
    End If
End Sub
<<Code calling lookup form - main form>>
Private Sub cmdSearchOwner_Click()
    gblOwnerSearch = "MO"
    DoCmd.OpenForm "frmownersearch", , , , , acDialog
    Me.txtOwnerID = gblNumber7
    pfOwners1
End Sub
<<Code from lookup form>>
Private Sub OwnerAddress1_DblClick(Cancel As Integer)
        gblNumber7 = Me.OwnerID
        DoCmd.Close acForm, "frmownersearch"
End Sub
<<Code from module - pfOwners1>>
Function pfOwners1()
    [Forms]![frmmanageowners]![cmdClose].SetFocus
    [Forms]![frmmanageowners]![txtOwnerID].Enabled = False
    [Forms]![frmmanageowners]![txtOwnerID].Locked = True
    [Forms]![frmmanageowners]![txtOwnerNotes].Locked = False
    DoCmd.Close acForm, "subfrmmanageowners"
    DoCmd.OpenForm "subfrmmanageowners", , , , , acHidden
    'Contract Information
        Select Case gblNumber1 = IIf(IsNull(DMin("contracttypeid",
"qrymanageowners2")), 0, DMin("contracttypeid", "qrymanageowners2"))
        Case 0
            [Forms]![frmmanageowners]![cmbContractType]= ""
            [Forms]![frmmanageowners]![txtRegHour] = ""
            [Forms]![frmmanageowners]![txtOvtHour] = ""
            [Forms]![frmmanageowners]![txtFirstHour] = ""
            [Forms]![frmmanageowners]![txtPerMile] = ""
            [Forms]![frmmanageowners]![txtTravelHour] = ""
        Case Else
            [Forms]![frmmanageowners]![cmbContractType]..Requery
            [Forms]![frmmanageowners]![cmbContractType]= gblNumber1
            DoCmd.Close acForm, "subfrmManageowners4"
            DoCmd.OpenForm "subfrmmanageowners4", , , ,, acHidden
        End Select
    [Forms]![frmmanageowners]![subfrmManageOwners1].Requery
    [Forms]![frmmanageowners]![subfrmManageOwners2].Requery
End Function
Click to expand...
Click to expand...
Click to expand...
 
S

So Sorry For Poor Aaron

a a r o n . k e m p f @ g m a i l . c o said:
yah it's because you're using SQL Server _DIVIDED_BY_ JET

throw away JET
upsize to Access Data Projects

SQL Server direct-- MUCH MUCH MUCH simpler

JET scans large tables every time you query them.
ADP is a tru client-server environment
Click to expand...

How sad! How truly sad! The poor, poor lad!
His comments are so untrue, but his loyalty is true blue.
He's for SQL Server through and through, even though his brains are few.

Aaron the Deceptive, Aaaron the Disreputable, Aaron the Delusional, Aaron
the Distruptor, Aaron the Disgusting, Aaron the Dissembler, Aaron the
Defrocked -- chose one or more. Poor "sweetcheeks," he's taking his
frustration out on you because he can't get back in to spend time with Big
Bruce, Big Bubba, and Big Barney, and he misses 'em SO much.

So Sorry For Poor Aaron
 
A

a a r o n . k e m p f

please stop stalking me, I do not feel comfortable with you following
me around like this..

Stop playing games, stalker


-Aaron
 
P

posted_by_anonymous

a a r o n . k e m p f @ g m a i l . c o said:
please stop stalking me, I do not feel comfortable
with you following me around like this..

Stop playing games, stalker
Click to expand...

Seems people only respond to you when you misrepresent Access, Jet, MDB,
ADP, DAO, and ADO, and recommend moving to SQL Server regardless of the
subject matter the original poster raised. Your problem is that doing those
things that you know will trigger their response is _all_ you do when you
post.

I have not seen any of them _threaten_ you, so you must "feel uncomfortable"
just about being shown to be biased and wrong in your statements and claims.
If they do so poetically and talk about your past, that's legitimate posting,
not stalking.

Grow up, (and as you said to one of the helpful regulars here) "crybaby".

Anony Mous
 
A

a a r o n . k e m p f

I don't misrepresent anything.
SQL Server is superior, and cheaper in maintenance, development,
administration and implmentation

Jet is obsolete.
Can you right click on a Jet database and 'generate scripts' so that
you can buld a PORTABLE SCRIPT to share with a friend?

Can you even prevent your database from corruption?
Can you even prevent your database from corruption?
Can you even prevent your database from corruption?
Can you even prevent your database from corruption?

STFU until you car, stalker
STFU until you car, stalker
STFU until you car, stalker
STFU until you car, stalker
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why Doesn't this work? 4
wierd command button quirk 7
code only works when run twice, why? 3
Opening form unexpectedly closes other form 0
Command Button 1
DoCmd.OpenForm command is not working as should. 8
DoEvents and Execution 4
PopUp Date Picker Form 4

Top