By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,383 Members | 2,075 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,383 IT Pros & Developers. It's quick & easy.

Lots of problems / errors

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Darryl Gore wrote:
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

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
Nov 13 '05 #2

P: n/a
Salad wrote:
A bookmark is a byte, not a string.


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)
Nov 13 '05 #3

P: n/a
Darryl Gore wrote:
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.


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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.