aftre moving back end to a new PC it wont let me add new record (1 Viewer)

philwalker531 · May 2, 2014

hi, im using a front end and back end and sharing the back end. i have had to move the location of the BE. i have linked the tables to the new location but when the front end is opened i cannot add or edit the records. i can view and search but not add??

the back end was on an XP machine and now its on a win 7. im really stuck?? ive set all permissions on the back end to 'full access' but still no.

has anyone got any help??? please?:banghead:

Ari · May 3, 2014

Hi

You use a folder in c drive (c:\YourFolder\YourBe.accdb) or this using the Program Files folder?

philwalker531 · May 3, 2014

Ari said:
Hi

You use a folder in c drive (c:\YourFolder\YourBe.accdb) or this using the Program Files folder?

on the xp machine the backend was in a 'shared' folder
I have moved to a new machine running windows 7 and saved it in the root c:\ and 'shared' the drive. Both front ends can find the BE and read all the data but cannot add or edit

JHB · May 4, 2014

When you open the backend directly, are you able manually to edit or add data?

philwalker531 · May 5, 2014

have not tried that yet, will try on tuesday. thanks

philwalker531 · May 7, 2014

philwalker531 said:
have not tried that yet, will try on tuesday. thanks

ok, so the computer that 'hosts' the back end is working fine. the other pc that is accessing the back end over the network cannot ope the back end as 'it is in use' by another user. i can open the back end tables independently but it states 'it is not updateable'

the host is running win 7 the one that cannot access the file is runing win 8. both PCS are connected to the same network and can find all the files that are 'shared' both are logged in as administrators but i cannot get it to work?!?!?!?!?!?!:banghead::banghead::banghead:

im thinking it could be apermissions or security issue but how do i add a user from another PC onto the file properties of the BE?

TerribadCoder · May 7, 2014

I've had to relink my backend tables to the frontend when I moved from one server to another. Not sure if that will solve your problem, as I received a different error message after moving it.

JHB · May 8, 2014

philwalker531 said:
ok, so the computer that 'hosts' the back end is working fine.

Does "working fine" mean that you able manually to edit or add data in the backend database when you open the backend database?

aftre moving back end to a new PC it wont let me add new record (1 Viewer)

philwalker531

Registered User.

Ari

Registered User.

philwalker531

Registered User.

JHB

Have been here a while

philwalker531

Registered User.

philwalker531

Registered User.

TerribadCoder

Registered User.

JHB

Have been here a while

Similar threads

Users who are viewing this thread