I have created a split MDB that was intended for use on a single PC.The
user has asked for it now to be setup as a multi-user (without
security) system.
I have placed the "applicatio n" mdb on one PC and linked to the "data"
mdb across a Windows network. The linking works fine, but when I open a
form that is supposed to display records on a continuous form, only
existing records are displayed, i.e. there is no "blank" new record
displaying at the bottom of the form to enable the user to create a new
record.
The system was created in Access 11 (2003), and runs happily on the
first PC under Access 10 (2002) and XP. The second PC (the one across
the network that is giving the problems) is running Access 11 under XP.
Allow Additions is set to Yes for the form, and Data Entry is set to
No.
Any ideas will be gratefully received.
Regards,
Huw Davies. 3 2704
Can the users edit existing data?
Is the shared folder allowing updates to the logged in Windows user?
--
---------------------------------------------------------------
Mr Leigh Purvis - Proprietor
Database Development
---------------------------------------------------------------
Email: Le***@DatabaseD evelopment.co.u k
Web: www.DatabaseDevelopment.co.uk
Mobile: 07713 166938
---------------------------------------------------------------
"Huw Davies" <ri************ **@btinternet.c om> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. . I have created a split MDB that was intended for use on a single PC.The user has asked for it now to be setup as a multi-user (without security) system.
I have placed the "applicatio n" mdb on one PC and linked to the "data" mdb across a Windows network. The linking works fine, but when I open a form that is supposed to display records on a continuous form, only existing records are displayed, i.e. there is no "blank" new record displaying at the bottom of the form to enable the user to create a new record.
The system was created in Access 11 (2003), and runs happily on the first PC under Access 10 (2002) and XP. The second PC (the one across the network that is giving the problems) is running Access 11 under XP.
Allow Additions is set to Yes for the form, and Data Entry is set to No.
Any ideas will be gratefully received.
Regards,
Huw Davies.
"Huw Davies" <ri************ **@btinternet.c om> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. . I have created a split MDB that was intended for use on a single PC.The user has asked for it now to be setup as a multi-user (without security) system.
I have placed the "applicatio n" mdb on one PC and linked to the "data" mdb across a Windows network. The linking works fine, but when I open a form that is supposed to display records on a continuous form, only existing records are displayed, i.e. there is no "blank" new record displaying at the bottom of the form to enable the user to create a new record.
The system was created in Access 11 (2003), and runs happily on the first PC under Access 10 (2002) and XP. The second PC (the one across the network that is giving the problems) is running Access 11 under XP.
Allow Additions is set to Yes for the form, and Data Entry is set to No.
Any ideas will be gratefully received.
Regards,
Huw Davies.
This is probably a Windows permissions issue with the folder where the data
is kept ( eg \\DataMachine\D ataFolder)
Get the user who is having trouble to open notepad, create a small text file
and save it to this folder. Make sure he can edit and save it - if not
adjust the Windows permissions.
If you can't do this or it doesn't solve the problem, post back.
Thanks to those who replied. The issue was with the permissions set on
the shared folder that contained the Back End MDB. Once I set these to
allow both read / write access to the network user, the problem was
fixed. Thanks once again.
*** Sent via Developersdex http://www.developersdex.com *** This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Marcus |
last post by:
I have a database containing my own tables and data and I wanted to
be able to query this against an accountancy program which has an ODBC
driver. This was never a problem with MS Access and Jet but I hit Jet's
limitations and have moved to SQL.
Creating my own SQL database was no problem, but I was unsure of the
best way to be able to be able to have my SQL tables and my accountancy
software tables appearing in the same Access front end....
|
by: Bill Reid |
last post by:
Hello,
I am a just-beyond-beginning user of Access 97 on a Windows 98se
machine (a single, non-networked home machine). All of a sudden I am
unable to sort any of my tables. I click on any random heading to
select the column, but the A\Z and Z\A buttons in the toolbar stay
grayed out. This happens for any column on any table. I even created
a test table since I first noticed this problem, but it also is not
sort-able. I haven't...
|
by: G rumpy O ld D uffer |
last post by:
This is probably a 'Low-Level' question to all the ACCESS experts but
I've only been using ACCESS for a couple of weeks.
I've been given 30+ (and counting) separate 'Weekly' Databases which
all have a Table, in exactly the same Field format, in each of these
'Weekly' DataBases.
I want to set-up a new 'Master' Database, so that I can write one
Query to search all the 'Weekly' Databases and produce one new Table
in the 'Master' Database...
|
by: James Fortune |
last post by:
In order to get the records I want on a report I sometimes create a
SQL string for the RecordSource and sometimes supply the criteria
using the Filter Property. If I use the Filter Property rather than a
RecordSource returning just the values I want is there extra traffic
across the network to bring the unfiltered data to the front end?
Thanks,
James A. Fortune
|
by: S. van Beek |
last post by:
Dear reader,
To work with linked tables is a professional method of working with a frond
end and back end mdb.
Working with linked tables on a local pc gives an acceptable performance but
in case you start working with linked tables on a server (network) the
performance will be drastically reduce.
| |
by: Jim |
last post by:
Hi all, is there a way for me to create an alias on my home PC for a
network path at the company work for?
I have a database (front end and back end) where the tables in the back
end are linked to the front end, which has all my forms and reports, so
all the linked tables in the front end link to the company's network
path:
\\nt24\canapp\newdb\tables.mdb
|
by: effiw |
last post by:
I'm working with an application that has an MS Access front end linked to the SQL Server DB backend. During a period of one week, 32 records of a spefic event (and all related records to that event) disappeared from both DBs. The application uses an Access report db for users to query for specialized data. Security is to the Access DB is limited to 3 db admins (2 IT, I departmental), and 1dept manager. The app's audit log is supposed to track...
|
by: news.sbcglobal.net |
last post by:
Hi!
I am able to add records to my SQL 2005 database using bound forms in my
Access application, but if I try to edit any records (not only the new
records I create) using the same bound forms, I receive a write conflict.
For the record, I am currently the only user of this application and my SQL
Server database has only one userID. I used this userID to create all of
the objects in the database and to connect to the database from...
|
by: gerbski |
last post by:
Hi all,
I am relatively new to ADO, but up to now I got things working the way
I wanted. But now I've run into somethng really annoying.
I am working in MS Access. I am using an Access frontend separately
from a backend. The tables from the backend database are linked in the
frontend database.
In the frontend there is a Form with a listbox in it. The listbox
rowsource is a query that selects all the records from a (linked)
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |