Unable to create new records on linked tables over network

[Huw Davies]

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

[Leigh P]

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***@DatabaseDevelopment.co.uk
Web: www.DatabaseDevelopment.co.uk
Mobile: [phone]
---------------------------------------------------------------
"Huw Davies" <ri**************@btinternet.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.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 "application" 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.

[Brian Wilson]

"Huw Davies" <ri**************@btinternet.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.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 "application" 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\DataFolder)
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.

[Huw Davies]

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