testing a split database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have read through almost everyone's postings on splitting databases and it
was actually quite simple (took my database about 20 seconds). I am working
on a database that is located at another location using our system-wide
network. I can access their shared drive folder and have been making changes
and updates in this folder but I do not have a access to each person's
individual folder. Also, because I am not at their school, how can I test
the FE/BE split to be sure it working right? Should I just assume it is? I
love technology and am learning Access very well and have some BASIC
programming experience but I don't always trust the "fixes" that I do without
thoroughly testing them. Thanks.
 
Hi Eduman,
I am working on a database that is located at another location using
our system-wide network.
Click to expand...

My advice is to copy the database to your local hard drive, before making
any design changes. Access can work okay with a split database over a LAN
(Local Area Network), but it is not designed to work over a WAN (Wide Area
Network). I would think you would be risking DB corruption to be making any
design changes with a database opened over a network.
Also, because I am not at their school, how can I test the FE/BE split to be
sure it working right?
Click to expand...

I would either go to the school myself, or I'd work closely with a
knowledgeable staff member at the school. That means someone who is fairly
computer literate, has some knowledge of networks, and preferably some
experience using Access.
Also, because I am not at their school, how can I test the FE/BE split
to be sure it working right? Should I just assume it is?
Click to expand...

Sure, go ahead and make assumptions.....if you don't care about your
reputation. Personally, I would not assume anything.

Here is two articles I wrote that you might find useful:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html

Update Front End
http://www.access.qbuilt.com/html/update_front_end.html


Bottom line is you need to either do the testing yourself, or you need to
work with someone who is knowledgeable at the school, and can reliably run
any tests that you ask for and report the results.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I have read through almost everyone's postings on splitting databases and it
was actually quite simple (took my database about 20 seconds). I am working
on a database that is located at another location using our system-wide
network. I can access their shared drive folder and have been making changes
and updates in this folder but I do not have a access to each person's
individual folder. Also, because I am not at their school, how can I test
the FE/BE split to be sure it working right? Should I just assume it is? I
love technology and am learning Access very well and have some BASIC
programming experience but I don't always trust the "fixes" that I do without
thoroughly testing them. Thanks.
 
Thanks Tom. There really isn't anyone who has the kind of knowledge there to
do this work so I'll figure out how to get there. I completely agree with
the reputation thing; that's why I try and try again before I put it out
there.

I looked at the two articles and wil try to udnerstand them the best I can.
Part of my problem is my limited access to folders and setups. I can access
shared folders (P: drive in our case) but don't have the permissions to copy
to each person's "personal drive" (the H: drive in our case). I'll figure it
out though as I am quite proud of my creation.
 
Hi Eduman,

Funny...when I used to teach at Bellevue Community College, in Bellevue, WA.
(USA), they used the same exact drive letters (P:\ and H:\) for shared and
personal folders, respectively.

I would put the back-end (BE) on the P:\ drive, although my recommendation
is to use the equivalent UNC path (\\Server\Share) instead of the mapped
drive letter.

I'd ask the system administrator if they can write some script to copy the
front-end (FE) to the local hard drive of each PC, and place a shortcut on
each user's desktop, rather than copying the FE to a personal folder (H:\).
The reason is that you really want the FE to be local, so that you are not
adding unnecessary network traffic. Here is an article that Albert Kallal
wrote that is worth reading:

Splitting a access database, or how to run ms-access in a multi-user
mode.
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm



Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Thanks Tom. There really isn't anyone who has the kind of knowledge there
to do this work so I'll figure out how to get there. I completely agree with
the reputation thing; that's why I try and try again before I put it out
there.

I looked at the two articles and wil try to udnerstand them the best I can.
Part of my problem is my limited access to folders and setups. I can access
shared folders (P: drive in our case) but don't have the permissions to copy
to each person's "personal drive" (the H: drive in our case). I'll figure it
out though as I am quite proud of my creation.
 
Back
Top