Hello PHV,
Aparantly i cannot split the db at the moment, once i or any of my users try opening the db the error: "the microsoft jet database The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time" comes up, i...
Hello Hap,
Thanks for your reply, however the 2003 mdb database has not been split, therfore it resides in a shared drive so users can access.
Any more suggestions.....
I have a database currently accessed by several users over our network, we encountered "Run-time error '3043' which was rectified on it's own. A couple of hours later a user complained of another error in which it asked to repair the database, users exited and i run the compact and repair option...
Hi there,
Yes, i have not split this db, i guess this is because i don't know much about it and how it works when it comes to making changes to the form and tables later on. I've read posts many times that users whom split their db ends up with it much slower than if it was not split, in my...
Duane,
I was able to see my logon id and created the table with the roles for each user: I used #A for Administering, #ED for Editing/admin and #V for users only viewing. The info. was filled out in the table directly, As for the data form and entering the tag property, do i have to create a...
Duane what's up,
Currently this database resides in a shared drive in the server, users simply log on to their pc's and open the db from the mapped drive, i am willing to be guided by your advice on this problem, i however don't know vb therefore "Get logon name" and setting up these codes in...
Hello
I have created a database that is used by multiple users, two of whom does day to day data entry of all records, some users only uses this database to enter information in one field "Invoice #" of each record, some users only filters data from the db to get info. to cross reference other...
Hello,
I have a spreadsheet with all my users whom have a blackberry phone, this sheet has six (6) columns with various details of the phone and rows with the user names, i want to create a dropdown to show the previous phone so i can simply click the little + button to drop the list showing...
I just spoke to the user, apparently when the last record icon is chosen it jumps to record # 18 and no further. If i scroll single, it reaches up to # 100 and then jumps to record # 10, at this point the single scroll button will not show any more record (not # 9 or 11)
I looked at # 19 record...
Hello,
A mail merge has been created in word 2003 with a list of Employee names, this list is used to print their names on their pay envelopes.
When using the left and right arrow to scroll throught the 170 mail merge names to print, the button reaches until record # 17 and won't go further...
Thanks for your information,
I was able to get some info. recently from a microsoft support site, which i followed and was able to get a solution, this is what i did:
Solution 2: Replace the ADO code in the Switchboard form with DAO
Replace the following line of code
Set con =...
Am cool my brother,
Just for starters, i build this database without writing any codes, i have no formal training on programming, therefore understanding these codes is a bit of a problem.
The code from the Form_Switchboard(Code)is:
Set the focus to the first button on the form,
' and then...
I have designed a simple database in access 2003, however on one user system it won't open, the error i get is: Private Sub Combo35_AfterUpdate()
Find the record that matches the control.
Dim rs As Object
After i close the error message module, i get "Error loading DLL.
Can anyone help!
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.