Hi,

My girlfriends mum has just sent me a list of problems with their access
database that I set up.

firstly they got this error

msaccessmp8 has caused an error in MSACCESSMP8.EXE & will now close. restart
computer if problem persists

Then they get this one;

On the job sheet page, you fill in all the info but when you push refresh
ERROR MESSAGES come up in every field and then the screen freezes with no
way out but to restart the computer.
It started yesterday when Diane got a 'database has reached maximum capacity
message.
Do we deleted a bunch of old records from the started of the database hoping
this would allow us to continue.
But now we keep getting that INVALID BOOKMARK message

which is copied and pasted below

You tried to set a bookmark to an invalid string.
This error can occur if you set the Bookmark property to a string that is
invalid or wasn't saved from previously reading a Bookmark property. For
example, the following code produces this error:

Sub SetBookmark()
Dim dbs As Database
Dim rstEmployees As Recordset
Dim strPlaceholder As String

Set dbs = OpenDatabase("Northwind.mdb")
Set rstEmployees = _
dbs.OpenRecordset _
("Employees", dbOpenDynaset)
strPlaceholder = "1"
rstEmployees.Bookmark = strPlaceholder ' Not a valid bookmark.
End Sub


The Northwind.mdb I used as a start and template for their database.

Thanks for any help
Darryl

Darryl Gore wrote:
[color=blue]
> Hi,
>
> My girlfriends mum has just sent me a list of problems with their access
> database that I set up.
>
> firstly they got this error
>
> msaccessmp8 has caused an error in MSACCESSMP8.EXE & will now close. restart
> computer if problem persists
>
> Then they get this one;
>
> On the job sheet page, you fill in all the info but when you push refresh
> ERROR MESSAGES come up in every field and then the screen freezes with no
> way out but to restart the computer.
> It started yesterday when Diane got a 'database has reached maximum capacity
> message.
> Do we deleted a bunch of old records from the started of the database hoping
> this would allow us to continue.
> But now we keep getting that INVALID BOOKMARK message
>
> which is copied and pasted below
>
> You tried to set a bookmark to an invalid string.
> This error can occur if you set the Bookmark property to a string that is
> invalid or wasn't saved from previously reading a Bookmark property. For
> example, the following code produces this error:
>
> Sub SetBookmark()
> Dim dbs As Database
> Dim rstEmployees As Recordset
> Dim strPlaceholder As String
>
> Set dbs = OpenDatabase("Northwind.mdb")
> Set rstEmployees = _
> dbs.OpenRecordset _
> ("Employees", dbOpenDynaset)
> strPlaceholder = "1"
> rstEmployees.Bookmark = strPlaceholder ' Not a valid bookmark.
> End Sub
>
>
> The Northwind.mdb I used as a start and template for their database.
>
> Thanks for any help
> Darryl
>
>[/color]
A bookmark is a byte, not a string. Here is an example of setting the
current record in a form to a record in the form's recordset.
Dim rst As Recordset
set rst = Me.Recordsetclone
rst.FindFirst "EmpLast = 'Gore' And EmpFirst = 'David'"
'set the form's record to the found record in Employees
Me.Bookmark = rst.Bookmark
set rst = Nothing

Salad wrote:
[color=blue]
> A bookmark is a byte, not a string.[/color]

4 bytes I believe.

--
--
Lyle

To subject an enemy belligerent to an unfair trial, to charge him with
an unrecognized crime, or to vent on him our retributive emotions only
antagonizes the enemy nation and hinders the reconciliation necessary to
a peaceful world.

Justice Frank Murphy
Yamashita v. Styer, 327 U.S. 1 (1946)

Darryl Gore wrote:[color=blue]
> On the job sheet page, you fill in all the info but when you push refresh
> ERROR MESSAGES come up in every field and then the screen freezes with no
> way out but to restart the computer.
> It started yesterday when Diane got a 'database has reached maximum capacity
> message.
> Do we deleted a bunch of old records from the started of the database hoping
> this would allow us to continue.[/color]

Did you compact the database? Deleting stuff is not enough to shrink the
database below maximum capacity.


--
1f u c4n r34d th1s u r34lly
n33d t0 g37 l41d