If Splitting A Database Isn't Possible? (And Some Other Basic Questions).

Jan 21, 2007

Hello.

I have spent the last couple of hours looking through the forums but have managed to get myself really confused. Lots of questions, sorry - if anyone can point me in the right direction with one or two of them, I would be hugely grateful!

I have a database in a shared folder on the network at work. It is due to start being used by users other than myself in future weeks, and I see here that it's sensible to split things into a FE and a BE.

1. My initial problem is that I have a nagging memory of being told that we're not supposed to save anything on the individual computers hard drives. Can a split leave both the BE and the various copies of the FE on the shared drive, or does this negate the reasons for splitting in the first place?

2. Additionally, with little space left on the shared drive itself, it's possible we'll not have the room to put 10+ copies of the FE on it anyway. If I just split the database into the BE and ONE copy of the FE which everyone accesses, will the BE at least be made more secure by the split, even if the FE is still vulnerable, and performance isn't improved?

3. If no sort of split is possible, are there any alternatives to splitting?

Lastly, some questions for if we ARE able to split and put the FE on each computer:

(I would be keeping the BE and the "master" version of the FE on the shared drive. All tables in the BE and queries, reports and forms for the "user interface" in the FE. Hopefully this is roughly what I'm supposed to do).

4. With a split database, what happens with compacting? Presumably the BE of the database can be compacted as normal, but what happens with all the versions of the FE? Does each user have to be responsible for compacting them individually? Does an FE even need compacting if the design is unchanged?

5. Does splitting affect what happens if two people either open or amend a record at the same time, or is that still just governed by the record locks setting in Tools (which would need to be set before splitting presumably)?

6. If the design of the FE changes (but none of the underlying tables, queries etc. are touched), do I just give each user a copy of the new version, or does something more complicated have to happen (ie. does the whole splitting process have to take place again)? What about if new tables are added to the BE, or if existing tables / queries are amended? Can I just issue amended versions of the FE that interacts with the new tables as needed?

7. I have drop down lists and combo boxs in the forms in the FE that use tables to populate them. Will it cause problems that these tables are in the BE - such as impractical amounts of time before combo boxs show their options? (The table has to be in the BE (I think?) because the user updates the content of these tables / combo boxs through one of the other forms in the FE)

Many, many, many thanks if anyone can help me out with any of these.

View Replies


ADVERTISEMENT

Basic Database Questions, Probably

Dec 18, 2006

I am new to databases,, in fact I've never created one before,,
However I started learning today , for this project,,
I'm going to be learning on my own, but if someone feels kind they can give me the basics on how (the following) database would be created.



Fields

Box # (Number)

CBS Code (number)

Shackle Code (Number)

Agent Name

Property Street

Date Out

Date In




Where I can put in a Box # and it will fill in the other information for that box, showing if its currently out (aka no check in date with most current record),

If its not I can input Agent name, property, and Date out (then it will be checked out)? or some way to accomplish this.



Info can also be looked up by Agent name with autofill for the rest of the fields?,

Or Property with autofill


If searched by box Num, I want all previous agents used (check in and check out value) as well as current

If search by Agent, I want all box information from past, check in, and check in/out. with the rest of the records,,

I know this is possible,,
And I'll figure it out,,
But help speeding my learning would be appriciated

Thanks!
Collin

View 1 Replies View Related

Some Basic Questions Regarding Forms

Oct 24, 2005

Hello, very basic user here.

I've created a form that has a text field that concatenates values using:
=![PREVOWN] & ![PARKNAME] & ![TRNSNUM]
I know concatenation is a big no-no with normal forms, however, the agency I work for, wants to use this concatenated value as their unique identifier. Using a query alone is not feasible as the database was set up to use this value as the primary key, so we need to include the value.

I am having two problems:

The first is that the field [TRNSNUM], is an incremental autonumber field. The values in this field need to start at 10,000 so I used a Format of "10"000.
This works great in the [TRNSNUM] field itself, but in the concatenated field, I am not seeing the first two digits, so my values for the last third of the concatenation are showing up 123, 124, ... instead of 10123, 10124. Any help on this issue? Also, is this just assigning the two digit field of 10 before my numbers? If so, I need a better way to do this, as my values will reach up to 11,000 and so on.

The next issue, and the larger problem is that my concatenated text field is not being input when I click on my forms, "submit" control button. I used the command button wizard to create this button. I selected "Record Operations" and then "Save record." It seems to save all of my other text field, except the concatenated field. This is a problem, since the value is supposed to be my primary key, so if I cannot obtain the value from my form, I cannot add more records, as the primary key cannot be null.

Any ideas would be of great help, I am a very beginning user, with very little knowledge of SQL or VB, so I am slogging my way through.
Thanks.

View 8 Replies View Related

Newbie - Basic Questions About Design

Mar 5, 2008

hi everyone,
as a network engineer, it administrator, etc etc people expect to know absolutely everything about pc's. so here i am.....

a company whose network i look after are using excel spreadsheets on a weekly basis to take orders, wages, running costs etc from their remote sites (currently about 20 sites)
the spreadsheets are accessed via terminal services and are moved via a script at the end of the week so the remote site doesn't have access to the old records and replaced by a new sheet. so lots of spreadsheets floating about.
you can imagine how hard it is to pull past records & compare etc.

now, i'm new to databases and have order a book to gen up on the subject. the sites should only be able to edit the last 7 days of records but be able to see the last years. i can see how a query and subforms can achieve this etc.

each site shouldn't be able to see the other site's records and the head office should be able to run reports etc on each site or as a whole.

i can narrow the time down that everybody is accessing the data. the sites may grow to 50+ but the head office is unlikely to have more than 5 people access the dabase at the same time.

my question is..... (access 2007.... can't see any user security).....
am i better to do an individual database (all exactly the same apart from name, titles etc) for each site that sits in their individual folders via terminal services? then let the head office access each seperate database via linked tables?
my thinking for the above way was security (they can't see each other) and resilience (1 database gets corrupted, the others are still workable) and speed (only a few users accessing each database)
the downsides are obviously the amount of files although this is nothing compared to the excel files at the moment.
any ideas or help would be appreciated.
thanks
louis

View 3 Replies View Related

Splitting A Database

Aug 11, 2005

I am trying to split my database but when i run the database splitter it comes up with the following error messages:

Subscript out of range

And

Invalid procedure call or arguement

Does anyone have any ideas what could be causing these or how to fix it?

Thanks

View 11 Replies View Related

Database Splitting

Sep 10, 2005

Hi
How can I change the location of the back end part, at the moment the front end is looking for the back end at a different location

Cheers
Bikeboardsurf

View 1 Replies View Related

Splitting A Database

Aug 21, 2006

Hi,

I have been searching for more info on this and found out quite a lot about it; however, I am still wondering how to connect the front ends that will be in different machines to the back end that resides on server.

I know that when you split a database, the wizard asks where to save the first front end. But how about if you have many?

Any help will be very much appreciated.

B

View 3 Replies View Related

Splitting The Database

Mar 14, 2007

i thank all for helping with the issue of mulitple users. after i did the splitthe database using the wizard. i noticed the tables lookes diiferent. but how do i put the front ends for users in their document since am on a thin client enviromemt. or
how do i transfer the front from the end. do i have to write codes??
thanks

View 5 Replies View Related

Splitting A Database

Jun 21, 2007

Hi. I would like to split my database which is used by various people on a shared drive.

Is it possible to specify a relative path to the linked tables in the back end?

Otherwise, if people access the shared drive via different drive letters, it fails.

Also, I like to keep a copy of the database myself. With absolute paths to the back end tables, I can't simply copy both sections from one place to another - as the links fail.

Thanks.

View 6 Replies View Related

Splitting A Database

Apr 1, 2005

I recently decided to split my database into a front end/back end environment. What I noticed though was a huge slow down in performance. One subform in particular takes 5-8 seconds to load, as opposed to less than a second before the split.

I know that splitting the database comes highly recommended in this forum, but the slowness is unacceptable. I especially want to split the database so I can execute changes quicker.

By the way, I have read several threads that recommend turning off the name autocorrect feature. I did this in the front and back end but did not notice a diference. I also compact/repair the database regularly.

The other thing I tried was creating an MDE file, as I was told they run quicker. Unfortunately, I am told by Access that it cannot be created. I believe from what I have read that I have too many forms that have attached modules.

For now, I am going to merge the database back into one file. But if anyone could offer some advise, I would like to pursue a split again.

View 2 Replies View Related

Database Questions

Dec 2, 2005

Hey guys, bit of a novice here

Say your got a database that has many users & in which quite alot of information is added to it on a regular basis. Basically its getting slower, what could be the problems & how could you fix it???

View 1 Replies View Related

Database Questions

Jul 24, 2007

I am a newbie and just found your forum - hope you can help me.
I built a kindergarten software but seems to have a problem : I have children registered and I keep records of the parents, other relatives etc'.
My question : what w'd be the relations between the tables since parents can have more then 1 child and so does the other relative (each parent has his own table). Should I keep all details in 1 table (personal detail for child + professional details such as positioned in adult class etc/
Hope I'm clear.
Thanks

View 11 Replies View Related

Is There Anyway To Reverse Splitting A Database?

Sep 14, 2005

I split a database and created a backend but now I dont need it and I accidentally deleted the backend while I was updating the file folder and it was on the network so it's gone for good.

Is there a way to reverse splitting a database so it no longer requires the back end?

View 1 Replies View Related

Reasons For Splitting A Database

Sep 1, 2007

I have a split database - frontend and back end sitting on a server. If there are only going to be absolute maximum 4 people using this database at a time - is there any good reason for it to remain split.

The reason I ask is that a few people may want to "take it home" to work on it and being non-computer savvy people have a lot of trouble re the concept of linking the front end to the back end.

How do you unsplit a database?

View 3 Replies View Related

General :: Splitting Database In 3

Sep 2, 2012

I have a database (already splitted in FE/BE) which Clients use on site.Part of the service we offer is Outsourcing: We do all the capturing and when they login on their side, it downloads the latest BE file for them to use "Read-Only".

However we added a new module in which half of the data on a particular table needs to be completed by the Client.So we need for the table to be splitted in such a way that they can capture their info on the form and when we log in on our side, it has to download the data they entered in the same way as when they login and download the data we captured.

Was thinking about adding a 3rd database file to the mix with just one table and in some way link that table to the existing table for the new module. But the intermediate link I created is not updateble.

View 6 Replies View Related

Error When Splitting Database?

Sep 29, 2011

I've recently downloaded the Goods template database from Microsoft [URL]. It's basically a inventory, invoice, purchase order system and is enough to fulfill my office needs. However, I seem to be running into an issue when I'm trying to split the database using the built in tool.

The "the database cannot be opened because vba project contained in it cannot be read..." error pops up when I click on "Access Database" button in an attempt to split the database. I also tried to do it manually, but noticed that none of the queries and most of the forms don't show up on the list when I'm trying to import queries, forms, etc.

View 1 Replies View Related

Help On Basic Access Database

Oct 16, 2006

ok I'm an accounting major and for one of my classes which is accounting information systems, they are making us design a database in access. Long story short, our teacher is horrible and is not teaching us access and continues to assume we know it and ignores us when we explain to her that access was never taught in our lower level classes. Our book also does not cover access to an extent that will help us with this project.

I have a small access assignment that requires we make a database for a small video rental store. The only things that need to be kept in mind are that the store has many customers, you stock over 2,500 different movies with most having multiple copies. All daily transactions need to be managed.

I have a relational database done.. I'm just asking if anyone feels like looking at it and pointing out some mistakes or areas that should be worked on or improved I would really appreciate it.. Thank You in advanced!

http://www.imagestation.com/picture/sraid217/p65593dec940cc3d2f42bbf36ced1324e/ec7ee08b.jpg

View 1 Replies View Related

Questions On Database Design

Jul 30, 2007

Hi,
New to forum. Beginner/Intermediate Access Experience.

Here is what I am trying to accomplish:

The database i am creating will basically need to have a user check-off a list of Fire Extinguishers that he has checked, on a monthly basis. For example, the user will enter a date, and then a form with a list of all the extinguishers will pop up, and he will place a check mark by each one. When he enters the check mark, that date will be stored so that we have a history of when each extinguisher was checked and by whom (using initials or something)

Currently, my design is simple, something like this:

tblUser
pkUserTableID
fldUserName
fldUserInitial
fldINSPECTIONDATE

tblExtinguisher
pkExtinguisherID
fldExtinguisherNumber
fldExtinguisherManufacturer
fldExtinguisherType
fkUserTableID

My question is this:
-Am I going down the right track with the 2 tables?
-Do I need a third table to Store the Historical Data?
-I am not quite sure how to layout the form so that all the extinguishers are listed.

I know these questions may seem vague, but any help would by highly appreciated.
thank you.

View 4 Replies View Related

Database Layout Questions

Nov 15, 2005

I have designed a few databases for my work. I have been recently assigned a new one that has me a little stumped. I am looking for some suggestions as to how to go about this.
Essentially, we have a training department that does training in the various aspects of the job. In the various classes, the "students" take a midterm exam to gauge the level of retention of the training midpoint in the class. Then at the end of the class, they need to take a final exam.
My department director would like the "students" to be able to take the exams using Access, since 99% of the questions are either multiple choice, yes/no, true/false, or fill in the blank, and Access would be able to "auto-grade" the tests, essentially.
I am at a loss, basically, as to the layout. The "student" information table would be the easy part. I am unsure of how to create the tables that would have the questions, depending on the class and whether it is a midterm or final, with the answer choices attached.
Any suggestions?

View 1 Replies View Related

Couple Questions About My New Database

Nov 4, 2005

Hello everyone, im new here and i have some basic access knowledge, little knowledge about VB. Im looking to create a access database using access 2000 -- I know what I need and how to create most of it, however, I do not know how to do a few things, input for improvement or recommendations are more than welcome... Heres the design

Im doing a fairly simple inventory control database, it will have about 8-10 fields:
FAX# (date)
DATE (date)
NAME (text)
EMP# (number)
UNIT (text)
SIZE (text) (this is static and will be combo box drop down)
GENDER (text) (same as size)
POSITION (text) (same as size)
SENT (date)
AMOUNT (number)
RECEIVED (number)
PO# (text)

I need all of that in a form, which I can do, what i also will need on the form is the current amount which be determined by RECEIVED - AMOUNT, which I need to some how show up on the form (this i dont know how to accomplish) ive been trying to put a formula into a text box like =SUM([RECEIVED]-[AMOUNT]) ... it works okay, unless i copy from excel to the table which the form uses, then it doesnt see the items i copied into the table, only the items that were typed in using the form. I also I need to put like a box below the text boxes which will display a query (which i dont know how to do) -- this box will display a query (ie. if i wanted to filter out all , and only see SIZE = xl GENDER = male and then the box will show up in 'table' form all the people who meet that requirement.)

==============================================
= Gender [M/F] Size [XS/S/M/L/XL] Position [K/C/W] =
= Name [ ] Unit [ ] Emp# [ ] =
= =
= Date [ ] Sent [ ] Fax [ ] =
= =
= PO# [ ] Received [ ] =
= ------------------------------------------------------- =
= Search [ ] Amount Left: X =
= ------------------------------------------------------- =
= || || =
= ||---------------------------------------------------|| =
= || || =
= ||---------------------------------------------------|| =
= || || =
= ||---------------------------------------------------|| =
= ------------------------------------------------------- =
==============================================

Thats the best ascii drawing i can do of what invision...
:) Thanks for any help in advance.

AD

View 1 Replies View Related

General :: Database Splitting Error

Dec 19, 2013

I split a database (without first making a copy of it) on my local machine and put the front end on a shared network drive. now no one can open any of the forms since the back end is on my machine.

is there a way to undo this or to split the database on the network drive so that users can get in?

i want to avoid having to redo the database from the ground up.

View 5 Replies View Related

Splitting Database And Use Runtime For Accessibility

Nov 24, 2014

I'm in the middle of developing a database for our engineering group to track projects. I've got a question:

I'm using Runtime because none of our group has MS Access loaded on their system. So, I'm providing a link to the participant to download the free Runtime Software and providing a Shortcut to the database in the shared area.

My question is, when I split the database and provide the users with the front end do they still require runtime? Do I still provide them the link to download the free Runtime software and if so, do I save both the back and front end with the .accdr extension? I'm assuming that since they will have the front end on their systems individually they will no longer require the Shortcut.

The way the system is currently, it seems that only one user is permitted in the database at a time as it is locked out. I would like for more than one user to be able to access the database at a time. I've set the Default Open Mode to Shared so I'm not sure why it gets locked down when a user is accessing it.

View 2 Replies View Related

My First Access Database, A Couple Of Questions

Mar 9, 2006

Hi all,
I've played a bit with MS Access 2003 the last week. I've made a form wich should contain information about stores (phone numbers, locations e.g.).

I'm trying to imagine myself (what could be a real) scenario, that way it's easier to give myself practice and tasks :)

As I'm new to MS Access, I'd like you to take a look at my forms. I want to know if there's better ways to do what I have done, and if I have done something wrong.


I also got a couple of questions;
Lets say I want to print one post by clicking on a button, is that hard to implement?
Is it possible to make a button, which exports the form to an .xls -file by clicking on it?
I did make these forms on a computer that had the resolution to 1280/1024, when I tried to open the form on a computer with 1024/768 resolution, the forms won't be displayed in the center of the screen :confused:

I think that's all.. Thanks! :)

Here's the access -file (http://www.home.no/f00b/stores.rar) (180kB) (use winrar to extract it)
I've tried to transalate to forms into english, sorry for the bad english :o

View 2 Replies View Related

Can Access Database Be Converted To V Basic

Nov 16, 2004

Is there a program that can convert an MS Access database to Visual Basic?

View 2 Replies View Related

EPOS/Stock Database Questions

Nov 30, 2007

Dear Reader

I am a realtivly new user and I do not know alot of things about Access

I have set up a database, and within this database, i have a table with my product details (the products are books, details include: ISBN, Title, Stock Level, and Price), I also have a table with customer's information (Name, Contact details, etc). I have created an order form, from which a user selects the customers name from a drop down list, and then he selects his name, and finally the date. Following this the user then works within a subform.

This subform has the following details, Order ID, Book ID, and Quantity Ordered. After this I want there to be a subtotal. I have no idea as to how to set this up, but I am assuming that I would need a query or something, to look up the price of the books, and then to multiply it by the quantity that the customer wants. Following this ideally I would like a small box on the main form saying the total value of the order.

Would their be anyway, to add the book ISBN number into the subform, where the user could either type in the ISBN number or select from a combo box the book title, but either way, both fields are updated, what ever method is used.

From this subform, I would like to be able to print out an order summary/invoice. This would contain all the books ordered by the customer in the current transaction, as well as the customer’s information, and the total of the order.

And my final question is probably the hardest one. Is their anyway (possibly by pressing a button) to automatically minimize the stock value on the products table, by the quantity chosen by the user in the order form? And if the quantity wanted is greater than the amount in stock, for a message to appear on the Order Summary/Invoice stating "On Order"

Using the above method, would it then be possible through the creation of a query to show what customers have ordered in the past, in a tab on the customer's details form.

Thanking you in advanced
CJM

View 11 Replies View Related

After Database Splitting, Is It Possible Zo Send A Tabel Into Backend.

Oct 6, 2004

Hallo everybody
I have an Access databse in which I have devided the tables into backend and frontend by using the Database Splitter wizard.
Then if I create any tables in the frontend Access file then thease tables are visible only in the front end of this system , not from other systems if I put the back end in network.
its ok for some tables , but now I have a table which I have to put in the shared backend , but if I cerate in the front end it is visible only in front end and if I create in backend it is visible only in backend.
how to send a table in the front end to backend after database splitting is over, so that I can access this table from other systems.
if it is possible please help me.
Thank you.
Kiran

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved