Question can i do this in access and a wireless hub

[gregorg]

i have two front end databases with one back end, the two front end use linked tables to the back end. One front end is on one computer with the back end in the pulbic directory, The other front end is in the pubic dirtectorty of the other computer.

I can access both and use both front end databases but only "read only", I can't get write access.

Is this to do with permissions or becasue Acess wont do read write other a wirless hub. I know it is dodgie to do this but I can't get read/write access at all and the record set always open Read only. I have tried changing the permission but to no avail. Also even though I am logged onto the computer, I can't change some persimissions as I dont have permission!

I dont know if it is to do with a permissions problerm or it is just because Access wont allow read write over a wireless hub.

If I have all the programms on one computer it works ok ???????

Gregor.

 

[Banana]

I'll deal with two things separately.

First, Access has no information or knowledge about how you are getting the file it's being told to go to, whether it's over ethernet, wireless, pony express or carrier pigeon. It just attempts to open/read/write the file. Therefore, if you are having problems with reading/writing, then it's almost certainly a permission issue.

Access require that we have full permission upon the folder for both front-end and backend so if the file is stored on a read-only folder, it will be read-only if it even can open at all.

A simple test to verify you have sufficient permission.

1) Navigate to that folder
2) Create a new blank text file in that folder
3) Open it in notepad. Type in random string of characters. Save it.
4) Now delete the file.

If you can do all of the steps successfully, then you have sufficient privileges. Otherwise, you need to look into permissions.


Now onto the second issue.

I really really would recommend against wireless connection because of how Jet/ACE works as a file server, and there's a chance that the file is left fragmented should there be a momentary drop in connectivity and that usually translate into corruption. Furthermore, a wireless client can significantly degrade performance for all other clients, so for those reasons, I would sooner look at other solution such as providing ethernet to all laptops.

 

[gregorg]

thanks for the reply, I will try both these thing out.

 

[NigelShaw]

pony express or carrier pigeon

i do find myself quietly tittering at some of your comments which seemingly, role off the tongue.....



Nigel

 

[Banana]

For your information, NigelShaw, there is actually a formal definition for IP over the carrier pigeon in one of IEEE"s document.