473,732 Members | 2,171 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Networking Access

I have the backend database on a network drive. There are 3 employees that
access this backend database through their respective frontend databases
(located on their respective C drive).
One of these employees has a laptop.
Q1. The laptop provides a problem in that each time it is connected to the
network, he cannot access the backend. The database window still has the
linked tables. The only remedy is to simply deleted the linked tables in the
frontend and then proceed to create the link tables in the frontend (again).
This is frustrating. Any suggestions how this can be overcome without any
user intervention... . allowing him/her to simple start using the database
when hooked up to the network.

Q2. There will be updates in the future to the database, which means that I
would have to ammend each individual pc that contains the frontend database.
And as the company grows, pc numbers (frontend) will increase. If I have one
frontend on the network, would their be sharing violations? or a probability
that there would be corruption to data when everyone was using this one
frontend the network ?
thanks for any help.
Jul 9 '06 #1
2 1470

"Gary" <sk**@optusnet. com.auwrote in message
news:44******** *************** @news.optusnet. com.au...
>I have the backend database on a network drive. There are 3 employees that
access this backend database through their respective frontend databases
(located on their respective C drive).
One of these employees has a laptop.
Q1. The laptop provides a problem in that each time it is connected to the
network, he cannot access the backend. The database window still has the
linked tables. The only remedy is to simply deleted the linked tables in
the frontend and then proceed to create the link tables in the frontend
(again). This is frustrating. Any suggestions how this can be overcome
without any user intervention... . allowing him/her to simple start using
the database when hooked up to the network.
There is an article which demonstrates how to re-link Access tables from
code here: http://www.mvps.org/access/tables/tbl0009.htm

Q2. There will be updates in the future to the database, which means that
I would have to ammend each individual pc that contains the frontend
database. And as the company grows, pc numbers (frontend) will increase.
If I have one frontend on the network, would their be sharing violations?
or a probability that there would be corruption to data when everyone was
using this one frontend the network ?
thanks for any help.

Tony has created an excellent app for keeping your frontend's up to date.
http://www.granite.ab.ca/access/autofe.htm
Jul 9 '06 #2
About Q2. just a suggestion - you can think about having a webpage on
your network that accesses the back end, that way you only need to
change the webpage. This way you can control violations using code.
Contact me for more information if necessary.

Sorry dont know what the problem is with the laptop - sounds like a
network problem to me - but not sure.

Colin Possamai

Gary wrote:
I have the backend database on a network drive. There are 3 employees that
access this backend database through their respective frontend databases
(located on their respective C drive).
One of these employees has a laptop.
Q1. The laptop provides a problem in that each time it is connected to the
network, he cannot access the backend. The database window still has the
linked tables. The only remedy is to simply deleted the linked tables in the
frontend and then proceed to create the link tables in the frontend (again).
This is frustrating. Any suggestions how this can be overcome without any
user intervention... . allowing him/her to simple start using the database
when hooked up to the network.

Q2. There will be updates in the future to the database, which means that I
would have to ammend each individual pc that contains the frontend database.
And as the company grows, pc numbers (frontend) will increase. If I have one
frontend on the network, would their be sharing violations? or a probability
that there would be corruption to data when everyone was using this one
frontend the network ?
thanks for any help.

Jul 10 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
1822
by: Steve Jorgensen | last post by:
Now, I don't mean that it's stupid in general. I'm actually pretty impressed with the whole MS Networking thing, but there's one stupid thing that keeps getting in my way, and I can't believe no one has fixed it by now in Windows 200x with its fancy Active Directory and other bells and whistles. When I'm working on a workstation on the network, and I have a file open, then the workstation crashes, the server keeps the bloody file open! ...
6
1845
by: Gary | last post by:
I have recently placed an access database (back end) on a network folder. The standalone pc's accessing the network have in their own respective C drives a copy of the database (minus the table). I have linked the backend source table to these front end database copies. The networking has been working nicely but the other day, I got a message when trying to access the database stating that the format is not a recognizable one... ie i...
7
8925
by: Brian Keogh | last post by:
Hi, I'm a student learning TCP/IP networking at University. Although I understand all about TCP/IP Networking in Java I am expected to understand the basics of C with regard to these programs as all the examples in my course notes and Exams refer to C. Can someone please point me in the right direction to where I might find answers on the web explaining C code involved with TCP/IP networking and what they mean. These are quite basic I'm...
46
2114
by: H.A. Sujith | last post by:
Why doesn't the standard library provide (at least basic) networking facilities using TCP/IP ?
4
1758
by: Raj | last post by:
I want to program C with networking. Can anyone tell me the How to start with a small simple program can it possible in turbo/borland c 3+. or i should go for another verson. i am using windows 98/2000/xp
2
1605
by: JCB19 | last post by:
I need help networking my HP DV4000 laptop to my home network. I have wireless home network with 3 computers using Linksys Wireless G The laptop has built in wireless capability. I want to network the laptop to the computer to have access to files (specifically, iTunes). In the SIMPLEST terms, how do I achieve this? Do I need to hook the laptop up to the router with a cable to get it started? If you haven't already guessed, I am...
1
7163
by: NickP | last post by:
Hi there, I've been experiencing a strange issue for a short while now and have managed to make a tiny replication of the bug. The uploaded a VB.NET 2005 project which implements a single instance application, it's very basic. http://nickpateman.m6.net/Files/xpbug.zip
1
1901
by: chinaemerem ibeawuchi | last post by:
What is the difference between URL networking and Socket networking? with an example of each type and state why the choosen networking technique is most appropriate for the example.
6
5337
by: darrel | last post by:
Hello there VB wizards. I have a few questions, regarding how networking works with Visual Basic. It's like this - I have a PC that has the database of all my system. It's like a central database pc. Now I want to know how I can access those databases in another PC. For able for me to me achieve network. By the way, the databases that are in the central database PC are all Access. Another question; Will App Path work in accessing another...
3
1328
by: =?Utf-8?B?cHJvc3Nyb24=?= | last post by:
I have had a home network with xp for many years. Itried to add a vista laptop to this network, Ok the vista laptop cansee and access files and the printer (which is connected to the desktp) on the xp laptop and deskptop but the both xp machines can neither see or access the vista laptop. Can anyone help me please I need to see and access the vista from the xp machines I am starting to become desparate, ..
0
8774
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9447
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9181
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6735
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4809
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3261
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2721
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2180
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.