Problems networking Access - Microsoft Access / VBA

jg1130

Greetings all,

Here's my problem...

I've built a small Access database that I placed on my server. I have
one workstation connected to the database.

The folder that the database is in on the server is shared and I've
mapped the path to the database on the workstation.

The advanced tab of the database options are set to:

Default open mode - Exclusive
Default record locking - Edited record
Open databases using record-level locking is checked

The database is also split, the workstation has a frontend which is
linked to the backend on the server.

When I enter records into the database from the workstation, they do
not appear on the server. To be able to see the newly added record on
the server I have to close the database then re-open it to see the new
record. The same problem exists if I attempt to add a new record on the
server after one has been added to via the workstation, I can't save
the new record.

I'm a little confused as to why this is happening. Should I not use the
database on the server to view and edit records? Is there some
additional step I need to take in order to network the database
properly?

I would appreciate any suggestions, because from what I know about
Access the setup I'm using should work.

Thanks,

John

May 4 '06 #1

Subscribe Reply

1291

Mark Reed

I think that the record is still dirty when you are checking the BE which is
why it is not appearing. Create your new record and then navigate to another
record and then back again. By moving to a different record and back again,
it will save it (Dirty = False). Open up the BE and the record should be
there.

See how that works.

Mark

<jg****@gmail.c om> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. .

Greetings all,

Here's my problem...

I've built a small Access database that I placed on my server. I have
one workstation connected to the database.

The folder that the database is in on the server is shared and I've
mapped the path to the database on the workstation.

The advanced tab of the database options are set to:

Default open mode - Exclusive
Default record locking - Edited record
Open databases using record-level locking is checked

The database is also split, the workstation has a frontend which is
linked to the backend on the server.

When I enter records into the database from the workstation, they do
not appear on the server. To be able to see the newly added record on
the server I have to close the database then re-open it to see the new
record. The same problem exists if I attempt to add a new record on the
server after one has been added to via the workstation, I can't save
the new record.

I'm a little confused as to why this is happening. Should I not use the
database on the server to view and edit records? Is there some
additional step I need to take in order to network the database
properly?

I would appreciate any suggestions, because from what I know about
Access the setup I'm using should work.

Thanks,

John

May 4 '06 #2

Albert D. Kallal

>Default open mode - Exclusive

The above should be set to shared...

The database is also split, the workstation has a frontend which is
linked to the backend on the server.
Good, that is the recommended setup.

When I enter records into the database from the workstation, they do
not appear on the server.

How are you testing the above? A form should be loaded to one record...you
exit the form (and thus save the record). You are then back to some type of
prompt the user for the next record to work on. If you just open form to a
large table of records, that form have to be told to re-load the records
(so that is can see other reocrds added by other people).

A good approach is to build some type of search form, such as

http://www.members.shaw.ca/AlbertKal...rch/index.html

So, ask/display the records you are searching for. If you do this, then you
eliminate the issue/problem of having to re-load up a form with a LARGE
number of records in the process, and your appcation will performance much
better.

You should not have to exit the application, but you certainly have to close
the form, or issue a requery to that form to see new records added. As
mentioned, if you change your design to ask for what records to view first,
then others peoples work will be available if you open up a form to these
newly added records....

And, if you are just testing by opening the back end direclty, you will have
to close, and then re-open a table to see the newly added records.

Of course, users would never see, or edit a table direct..but just a like
form, you do have to close, and then re-open the form to see records added
by other people.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal

May 5 '06 #3

jg1130

That sounds logical, I didn't even think of that. I suppose I could
also requery the table, which would do the same thing. That way it
world work on the server and workstation(s).

I'll keep you posted on this.

Thanks for your input,

John

May 5 '06 #4

jg1130

Hi Albert,

Thank you so much, I was testing it by closing and re-opening the form.
If I requery the problem is solved. I like your idea about using a
search form. I can now see that I need to re-think portions of the
database GUI.

Thanks again,

John

May 5 '06 #5

Similar topics

3208

PHP blamed for security problems

by: Tim Tyler | last post by:

Here's what this morning's security advisory read here: ``In the last 3 months we have noticed an marked increase in the number of web-server attacks and successful compromise on our network. These are mostly PHP-script exploits and are giving hackers easy shell access to virtual servers, as mentioned in the PHP Security Advisory in the News section of the control centre. We really cannot do much about these network attacks other than to...

PHP

4597

problems submitting form from one domain to another

by: Tyler Style | last post by:

Hullo - looking for a little advice here. I have a form on a page in one domain submitting to a cgi in another domain. Weirdly, on some Windows XP systems, a form on the page fails to submit/post properly to the cgi and users get the message from IE that it "Cannot find server: The page cannot be displayed The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to...

Javascript

1839

Networking Database

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...

Microsoft Access / VBA

2095

Why not networking support?

by: H.A. Sujith | last post by:

Why doesn't the standard library provide (at least basic) networking facilities using TCP/IP ?

C / C++

1756

Networking

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

C / C++

1289

Problems Accessing New MSDE

by: Fred Nelson | last post by:

Help! I just upgraded MSDE to the latest version on my Windows 2000 server. Everything appears to work fine - the enterprise manager on both the server and on my computer are able to access the new database and I have loaded it with all of its data using the enterprise manager. (Actually I've completed the entire cycle three times!) The catch is that my VB.NET web application is no longer able to access the database! I'm using the...

Visual Basic .NET

1602

NETWORKING Wireless Pro Laptop to Wireless Home Network

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...

.NET Framework

1810

Record corruption problems

by: Owen Jenkins | last post by:

I have an Access 2000 app which is in use by about 20 clients on LANs where each LAN would have between 2 and 6 PCs networked. The main form is a tabbed form with multiple subforms. It has been in use for several years and the only corruption issues I have had have been a few instances of a corrupted memo field and I've been able to copy and paste the rest of the record successfully. After a recent update (I update the front end...

Microsoft Access / VBA

2246

Wireless Networking Problems

by: Nefrit | last post by:

Ok, I can't figure it out, please someone else help if you know what to do. I have a Linksys Wireless G Router and Wireless G USB network adapter. My host computer is using Windows XP and there is no problems. My downstairs computer, which I'm trying to connect to the internet, is running on Windows ME. My problem is, the client computer downstairs IS recieving a signal from the Router just fine, but I cannot get the internet! I've tryed setting...

Networking - Hardware / Configuration

8851

Problem With Comparison Operator <=> in G++

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...

C / C++

8531

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8628

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

5650

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4175

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4335

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2754

transfer the data from one system to another through ip address

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

C# / C Sharp

1978

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1739

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General