Hello,
I'm a bit of a newby here, but i have a small problem and i hope someone can help me.
We have a small access database to record sales for small fairs. We used to hook up 3 laptops to a private network and use the public folder in one of the laptops to open and read/write the database.
1 laptop is running Vista, 1 is running windows 8, and one is running windows 7. All of them have Access 2010 installed.
Now each time when we try to open the database, 2 can open the same database, but the third can't open it. No error message, it's just not opening. We tried to switch the ones who opened it first, but that doesn't matter. The third to open can't get in.
I hope i specified my problem enough. Sorry for my english... :)
Greets, Tom
5  976 
Tom,
Welcome to Bytes!
Please clarify: You have Computer A, Computer B and Computer C. After Computer A and Computer B open the DB, Computer C cannot open it. Now, if Computer C opens it first, and Computer A opens it next, then Computer B cannot open it. Is this a correct understanding of the problem?
Either way, this is strange.
Do you have your DB split into a Front End (which holds all the forms, reports, queries and code) and a Back End (which houses only the data)? This may alleviate your problem, and there are many methods of doing this effectively. There are also many very complex ways to achieve this, but very effective if you have some more advanced VBA skills.
You state you are a newby here (to Bytes), but are you a newby to VBA? Your current skill level will dictate how complex we want to get with this.
Hello Twinnyfo,
Thank you for your quick reaction.
To answer your questions:
Yes. You understand the problem. I've tried to open the database with in the order
A, B, C
A, C, B
B, A, C enz. Always the third computer won't open it.
The database is not split in a frontend and backend. Both the forms, reports, tables and code are in 1 database. Is that going to fix my problem?
I not a noob at VBA, but also not an expert. I'm trying hard to learn everything, but the only way to learn it is by doing it.
Are you familiar with how to split a DB into Front and Back Ends? A more involved method is here: Working with Front and Back Ends, but if we get the basics down first, let's just see if splitting the DB will work.
As a reminder, before you do anything, Back up, back up, back up!
This might be a simple fix--or it might be an Access quirk that we are dealing with.
I've not done this before. But your link of 'working with Front and Back Ends' is specific enough! I'll give it a try. Thanks for the help!
Let us know how you get along and we can assist with any problem areas.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: lappy |
last post by:
Hello, I have written a small programme to compact an access 97
database.
Dim je As New JRO.JetEngine
' Compacts database Data.Mdb to Data2.mdb.
je.CompactDatabase...
|
by: Orchid |
last post by:
Hello,
I have a MS. Access database in XP. When I open the database in design
view, users will get an error message & cannot even open the database.
Is there any way to solve this problem?
...
|
by: Willie |
last post by:
Greeings all,
I am unable to complete adding a Data Adapter to my application in VB .net.
1) I drag the adapter on to the form,
2) I select 'New Connection,' connect to the database table using...
|
by: willington79 |
last post by:
Hello all,
We have a payroll application that runs with MS Access. It is comprised
of several different database files and one ms access mdb file for each
client. This means there can be from...
|
by: ATXTech |
last post by:
I am using a Access created database with a program I wrote in C# to
create and track helpdesk tickets. I store basic stuff like customer
name, number, issue, tech assigned, etc. with in the...
|
by: Hepburn08 |
last post by:
Hi, I need some help opening a corrupt Microsoft Access database file. I get an error message that says "unrecognized database format". Since I can't open it, I can't export the data to another new...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
