Networking Glitch
Mar 19, 2008
I have a split database. I hope I can explain this well....
I have a network mapped drive on all computers (win xp pro) of G: I have obviously a front end that was created when it was split.
I keep that fornt end file in same folder of the backend side of things, and I simply copy that exact tile (the front end) and place it on to the desktops of the workstation PC's and my database seemed to work, obviously I do rename the front end file on all PC's to Workstation 1, Workstation 2 and so on.
The front ends on workstations all do connect to the backend and the data does appear in the front ends and new records can be added and edited.
However I have a few issues:
1) If Workstation 1 was editing record 1 and workstation 2 was on another record say '232' and workstation 2 wanted to view the changes made to record 1 then he/she would have to wait till the the user edits the edited record and wait 5 seconds to see any changes. It would appear there is a slight delay in seeing the updated data.
2) If for example the user on workstation 1 adds a new record then it does update it in the table on the backend no problem at all, but it doesn't appear in the other front end databases form until the users exit the form and go back into it - it doesn't update live.
Is there a soloution to this.
View Replies
Jul 28, 2006
Hi Guys,
I'm trying to create a simple form that allows me to enter information about a new customer into my database. I've normalized Addresses into another table. I've attached a stripped down example of my problem to this thread.
Everything works fine when I'm viewing exisitng records, but when I go to add a record, I enter the name and phone number of the company (native to the main form), and go to add the address informaion (native to a subform in the address form), I get a message saying I need a similar record in the Addresses table and I cannot proceed...
But I'm trying to add that record to the addresses table!!
Please guys, whats goen on??!?
View 1 Replies
View Related
Jan 6, 2005
Hi,
When trying to update an access membership db where expired members are
being set to 'inactive' the script keeps hanging up with a runtime error
when the first or last name of the member
has a single quote in their name (eg O'Neil)
Any ideas where to look to fix this would be appreciated.
Regards
Justin
View 3 Replies
View Related
Jan 29, 2007
I'm hoping that someone can help me with this.
I have 5 computers on a network and have designed a form which needs to be accessible by every computer on the network. When I do try to open the form from a different computer other than the one it was created on, I get a security warning message that Microsoft Access will not open the file due to security reasons as the computer I am accessing is not a trusted source or not part of my intranet. I've tried everything. Can someone please help?
View 7 Replies
View Related
Aug 1, 2007
hello,
how is it that I make a table "updatable". That's the error ACCESS 2007 gives me when running the runtime version (front end) on a computer. The program has to update the tables on the back end which are on a different computer (on the same network).
Also, I just saw a thread with some code included to open the database, and then to close it. Do I need any connection code in ACCESS for this case?
This is my configuration:
- Main Machine (which has an shared external hard drive E: where the back
end file resides)
- Other Machines (they contain the front end file which is supposed to be
linked to hard drive E on Main machine)
Everything is shared and the path to link the front and back ends is working well.
View 2 Replies
View Related
Apr 9, 2006
Hi there...
I have splited my database... the table parts in the network (server) other part in some different computers...
I did this to allow others to enter data that ultimately will be gathered in the table-part of the database.
The problems is, when i linked the tables (using my computer) in the splited database it took the address as W:mydatabase.mdb, where W is the logical drive of the server...
when i try to operate it from other computer it can't get the link because the logical drive is defined differently in other computers...
but the actual link is follows:
\vbsrsdatabasemydatabase.mdb
I can hyperlink any document puting this address which are accessible from different computer...
is there any way to link the tables using the actual link in my database?
Thanks and regards
MPB
View 3 Replies
View Related
Aug 22, 2006
I would like to have a back-end Database on a host server and link a
front-end Database to the tables several hundred miles away. The problem is I have no experience whatsoever in doing this.
My questions are:
(1) Can tables be linked via the Internet?
(2) If they can, is this the best way to link the tables?
(3) If it is possible to link the tables by the internet or by some other way; how do I do it?
I really would appreciate any help you can give.
Kind regards
Eddie
View 1 Replies
View Related
Dec 15, 2006
First off, I'm a total newbie at Access. I've had it for a few weeks now and am trying to develop an order entry system for our church (we have a discounted food ministry). I've gotten pretty far with it.
Anyway, once this app is complete, how can we have 2 computers updating one database or do we have to use just one computer exclusively and to do more than that, we'd have to go to sql server?
Also, can we install access on more than one pc? We have access 2003. We don't have any problems with buying another copy, but if we buy it, we need to know we can have 2 computers, accessing one access database. Is this possible?
Thanks for any help at all,
Ken
View 2 Replies
View Related
