OnOpen Error With Replicated Database
Apr 15, 2008
I have a replicated databse that is used in both 2003 and 2007. Most development is done in 2003. I have stability problems with replicated/synchronised databases when running in 2007. The database normally opens with a switchboard menu, but on occassions the following error occurs:-
"THE EXPRESSION ON OPEN YOU ENTERED AS THE EVENT PROPERTY SETTING PRODUCED THE FOLLOWING ERROR: OBJECT OR CLASS DOES NOT SUPPORT SET OF EVENTS". Once this happens the databse will not open. I have to create a new replica which may or may not work. The strange thing is that I can run the database failing in 2007 from another rmachine that is running 2003, so it seems that the problem is specfic running 2007. Any suggestions or help would be appreciated.
View Replies
ADVERTISEMENT
Sep 8, 2013
I am using ACCESS 2010, win 7 Home Premium 64bit
difficult to handle error when executing my report. I put a code into OnOpen section but ACCESS states:
Quote:
The expression OnOpen you entered as the event property produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.
Additionally it says in description:
This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs.
I am genuinely confused by that. I have also provided the code in the case if I am missing something I don't know yet. In a debug window, I have executed the code line by line and it worked. Whenever I try to open the report, the error occurs. Should I be aware of something when I write code for reports?
Below, the code in my report "module":
Code:
Private Sub Report_Open(Cancel As Integer)
Call CreateTempTable
End Sub
Private Sub CreateTempTable()
On Error GoTo ErrorHandler
Dim strTable As String
[code]....
View 3 Replies
View Related
Nov 16, 2007
Hi -
First some background. A few months ago I replicated an Access 2003 database so that folks in various locations could all enter data. There is one master and 3 copies. One of these copies was operating on a computer with Access 2000 and it also happened to be the copy of the database that gave me some headaches (never with the synching) which I am almost positive were related to the version difference.
So, despite those other problems this copy of the database synched up fine throughout the summer. Now all the sudden I have found a few recently entered records in the copy which are not being transferred during synchronization. And from what I have been able to tell so far they seem to be from a particular data entry session on a particular date. I have already looked through the records in question to see if they are missing an important field of data or something and they seem to be complete and legitimate records.
I have tried a number of things and at this point am at a loss as to where to go next. Does anybody have experience with replicated databases and potentially run into this problem before? Any advice on what to look at next to figure out the casue and the fix?
Thanks for any help.... Steph
View 3 Replies
View Related
Mar 29, 2007
I have created a design master of my database, i want to share it on more than one PC but add data from both whilst keep developing it.
I have noticed that after replication that the ID fields now use really long random numbers and am wondering whether anyone has been able to control the 'randomness' of the autonumber?
Reg...
View 1 Replies
View Related
Mar 16, 2005
I have a replicated database with open access, permissions granted at the folder level. Database users have requested that a form be created where data can only be entered but not modified - for data entry clerks.
I want to create a separate replica for data entry users clerks with only the data entry form available which means that they cannot see other replicated items in the main database. However, if I unreplicate some of my items then my fully functional replicated databases would not synchronize properly.
Any suggestions?
View 1 Replies
View Related
Jan 24, 2006
Hi all...
I have a form that OnOpen does;
DoCmd.GoToRecord , , acNewRec
But, I also call it from another form, using a criteria, but because of the OnOpen event within the form it goes to a new record.
I need to be able to bypass the OnOpen event or find a different way of opening the form to goto a new record...
Please help!
Simon
View 1 Replies
View Related
Oct 19, 2005
Is there a way to verify the drive that an FE is opening from and then close if it is not where is should be?
I have a frontend that gets copied to each users C: drive by a .bat file. However, some just don't care about rules and proceedures and continue to open the frontend on the network drive. Since they map their drive to a specific letter drive for the BE that is where they are opening the FE from.
Thanks
Rich
View 2 Replies
View Related
Jun 12, 2007
How do I code the following?
I have a field in a table called surname. This is not the primary key and I don't want to set it as a unique field however I want there to be a message box that comes up saying "There is already another person of this surname (or something like that" if the surname entered already exists in the database.
Any ideas appreciated
View 2 Replies
View Related
Jan 18, 2006
On clicking a button to open a form I want to filter a list in a combo Box located on the forms subform
The main form is called 'Frm_orders'
The sub form is called 'sub'
The combo box field is called 'CostCodeID'
and I want to filter column 0 of the combobox which is Tbl_InvoiceCostCodes.Type to show records with a type of 'Repairs'
View 2 Replies
View Related
Aug 18, 2006
How do i make my subfrm record source switch to another saved query (qryPendingStatus) when it's opened from the form.
Heres what i am trying to accomplish:
I have a subfrm that i'd like to use to display info in 2 different forms.
There's a form currently for All statuses. Then another new one for Pending status. I'd like to use the same subform for this pending status form also, and in doing that my qryAllStatuses, but change to qryPendingStatus on the subfrm when i open the mainfrom.
This is on the open even ofthe mainform, but does not work (says method not founds...so obviouly i can't use ".Recordsource" here:
Private Sub Form_Open(Cancel As Integer)
Me.subfrmJobInfo.RecordSource = "qryPendingStatus"
End Sub
How can i make this happen?
View 3 Replies
View Related
Jan 28, 2004
Hi,
Im new to asp and access and have been having this problem for serveral weeks.
Every couple of days, all the asp pages on my site that communicate with the database start having 500 internal errors. i turned off the "Show friendly error messages" and one page gave me this specific error:
Microsoft JET Database Engine error '80004005'
Unspecified error
/admin/submitlogin.asp, line 8
I have tried a million things and have no idea why this is happening. Im not sure what other information i should post in order to see the problem. Any help would be greatly appreciated. Thank you,
Patrick
View 3 Replies
View Related
Jul 7, 2005
I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.
I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.
Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.
Thanks!
View 3 Replies
View Related
Jul 26, 2007
When trying to import a spreadsheet into Access i get the following error
Method 'CurrentDb' of object_Application' failed
However when i did the same yesterday it worked fine
anyone know why
cheers
View 6 Replies
View Related
Jul 24, 2005
When closing an access database, I get the following error message:
"There was a problem sending the command to a program"
We recently had our server changed over. Is this an access problem, or their problem?
View 1 Replies
View Related
Jul 27, 2005
I had a fully working database that I decided to clean up by standardising naming formats etc. I have changed the tables names and changed all VBA links etc to the new table names.
This all appears to work fine. The database is still doing exactly what it should be doing. The only problem is whenever a record is updated I get the following error,
"The Microsoft Jet Database Engine cannot find the input table or query, "***". Make sure it exists and that its names is spelled correctly".
Where the missing table is the previously renamed table. All the updates etc work correct to the renamed table but I get this error whenever it is updated. I tried renaming the tables to their original names but then I got the same error for the new names.
Anyone got any ideas or will I have to rebuild the database.
View 1 Replies
View Related
Aug 8, 2006
Good afternoon,
When I'm trying to open a back end database which was previously created is MS Access 97 it gives me the following error;
Cannot update. Database or object is read-only.
I have tried running the "Compact/Repair Function of MS Access 97 and MS Access 2003 to no avail.
I have tried converting the back-end to Access 2003 as well but I still get the same error message. I can link to the database tables from an Access 2003 database fine with no error message!!
Has anyone got any suggestions before I have to take it offline and rebuild the back-end and then copy the data across from the old one?!!!
View 6 Replies
View Related
Sep 10, 2006
Hi,
I am new to the use of access. I have defined the database in the dsn and named that 'abexp', now when i go to access open the database and then create a module and try to establish a connection to the abexp, it gives me an error - database has been placed in a state by an unknown user that prevents it from being opened or locked. Can someone tell me what am i doing that is incorrect over here. i am trying to get convert from sql server to access.
Best Regards,
Arjun Bhandari
View 4 Replies
View Related
Jan 3, 2007
Hi
Happy new year everyone,
I have designed a Access 2000 report which is getting data from a query. However when I run the report is asking to enter a parameter value which is Format$. Running simple the query is all fine but when running the report asks for this parameter and it seems that in does not like my formatting to display dollares values. I have in expression builder the following:
=Format$([Due_Date2],"mmmm yyyy",0,0)
My report is grouped on Dates formatted as month and year but all seems fine.
Does anyone know why is that or had a similar issue?
Thanks
df
View 1 Replies
View Related
Dec 3, 2005
hi
i get the error "The database is already opened exclisively by another user" after running the following code. i ran the same code under the same conditions on my home pc and it worked fine.
Private Sub Command1_Click()
Dim dbs As Database
Dim qdf As QueryDef
Dim strSQL As String
Set dbs = CurrentDb
strSQL = "update Emp set Salary = 786+ val(text2)- val(text3) where EmpID = '& val(text1) &'"
Set qdf = dbs.CreateQueryDef("", strSQL)
End Sub
View 1 Replies
View Related
Mar 28, 2008
OK, I have a database that works great when used on 1 computer. Basically, a friend of mine has a dj show, and he wants an electronic request system. So, I came up with this database, which works great on one computer. I am attaching the database.
So, the problem is, the database is on the dj computer, and then there is another computer on the network that will be setup for accepting requests. When I have the database running on one computer, when you try to open it on the other, it gives me a locked database error. Obviously the requests need to make it from one computer to the other. I'm pretty sure I didn't have it open exclusive. Any ideas...... I'm having a brain fart today, and I've not had much sleep.
View 3 Replies
View Related
Sep 29, 2011
I've recently downloaded the Goods template database from Microsoft [URL]. It's basically a inventory, invoice, purchase order system and is enough to fulfill my office needs. However, I seem to be running into an issue when I'm trying to split the database using the built in tool.
The "the database cannot be opened because vba project contained in it cannot be read..." error pops up when I click on "Access Database" button in an attempt to split the database. I also tried to do it manually, but noticed that none of the queries and most of the forms don't show up on the list when I'm trying to import queries, forms, etc.
View 1 Replies
View Related
Nov 8, 2005
Since splitting my database into a front & back end - when I attempt to run the front end part from a client PC logging in as one of the users/groups defined I get : 'Disk or Network Error' and the DB fails to open.
If I log in using the same username/group bypassing the config/startup options - I do see the Access Design view main window - but then if I attempt to open (not all) most of the forms in Form View - I again get the same 'Disk or Network Error' message each time.
Yet, if I log in as the administrator from the same workstation - no message appears?
Any ideas please? :confused:
View 3 Replies
View Related
Nov 22, 2005
Everything we peachy-keen with my database until I split it and I get the following error:
"The expression On Menu you entered as the event property setting produced the following error: User-defined type not defined."
Please help as I'm not sure how to proceed. Here are some facts:
1. I'm a noobie with Access. I've been clever and resourceful enough to figure out most answers to my questions, but searching for this one have turned up bare.
2. There was a single custom Toolbox present before splitting the database. On the Import, though, I used the option to import toolboxes/menuboxes (checkmark at the bottom on the Import page).
3. I've checked for missing/broken References, there are none being reported.
4. The 'On Menu' event exists nowhere to my knowledge! Where can I find it and hopefully troubleshoot the problem?
Your imput welcome, I'm defeated for now, but am continuing the search for an answer. Please help ;)
View 1 Replies
View Related
Jul 7, 2006
Hi,
We have been having intermittent problems with an MS Access 2000 front-end application linked to a SQL Server 2000 database recently.
From the switchboard a user was sometimes getting "There was an error executing the previous command". When she shut the application and opened it again it works fine for a little while - then the error occurs again.
I removed the generic error handling code from the code for the Switchboard form and I got the error message: "The Microsoft Jet database engine cannot find the input table or query 'Switchboard items'. Make sure it exists and that its name is spelled correctly."
I have been searching this forum and the web to find out what the cause of this error message is but I cannot find anything to go on or to try that might help get rid of this problem.
Does anyone know why this error occurs? Any idea how to stop it of happening?
Any ideas or suggestions would be greatly appreciated.
View 1 Replies
View Related
Jul 24, 2007
Hi there,
when i am tryint to access my Access database its giving this error:
The Microsoft Jet database engine could not find the object MSysDB. Make sure the object exists and that you spell its name and the path name correctly. (Error 3011)
I am not even able to get in there
Please Advice
Danny
View 8 Replies
View Related
Sep 11, 2007
Hello. I just split my Access 2000 database and receive the following Run-time error (#3251): Current provider does not support the necessary interface for Index functionality. This error occurs on the following line of code: tablename.Index = "PrimaryKey"
Does anyone know why this occured after I split the database and what exactly it means?
Thanks in advance.
View 7 Replies
View Related
