Synopsis - After A DB Is Created

Mar 27, 2008

I am trying to understand what’s next after a database is created (meaning it is functioning, but not ready for multi-user environment and not secured yet). By reading various postings and some articles, it seems these are the key steps I need to follow in order to have a database ready to go.
1. Once the database is ready and tested (at this point I am the only user and have full privileges to the database), I need to do the split – front end/back end (by using Access split wizard).
2. Then I save the back end on a shared drive to which the respective users will have access.
3. Next I secure the back end.
4. Then I create users group(s), and assign user ID/password for every user.
5. I install the front end to every user’s PC so they can begin to use it (not sure how to do that - some help is appreciated here!)

Is this close to what the process would be (even very oversimplified) or I am too far from the truth?! :confused:

Thank you in advance!
Atol

View Replies


ADVERTISEMENT

How Do I Get The Newly Created Key?

Jun 27, 2007

I have tables which I add a new post to. But I want to find its key. DoCmd.GoToRecord , , acNewRec
'Lot of data fills out the different textboxes
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.Requery
When I first save the data and the requery the you should expect the ID field on form to have the new unique number but it doesnt. Can you get the current unique ID on some other way?

View 2 Replies View Related

New Files Being Created

Nov 27, 2007

I have created an Access 2007 database on a network drive. I notice that as the database is being used, other files are being created sequencially such as, "database1", "database2", "database3", etc. What are these files. They are quite large and I am wondering if they are necessary.
If anyone has any information, I would appreciate it.

thanks,

View 5 Replies View Related

Should Forms Always Be Created From Queries

Jul 1, 2005

I've read quite a few posts and noticed that quite a few people have said that forms should be created from queries. Is this personal preference or a must.

Like I said on a previous post I am going on a one day Access soon, so maybe I should stop reading and playing until I have completed that, but my mind is running away with what I want to do.

View 14 Replies View Related

Extra Mdb File Created

Jan 1, 2006

Hi All,

For some strange reason, a replica db is being created along side the original. I don't believe it's a back up since the name back_up usually appears in the file name. I've seen it happen once when the proper mdb file was opened and then noticed the new db was created (always called db1.mdb). It's a permanent file mdb file and not the record locking icon. I remember over the summer someone posted a similar problem but I haven't been able to locate that thread. Any suggestions?

Thanks

View 2 Replies View Related

1 To Many Relation, 1-site Is Not Yet Created

Apr 11, 2006

The problem:
I have a table: TBL_INVOICES
and I have table TBL_SHIPMENT_NOTES
One invoice can have many shipment notes, so a created a
One to many relation between TBL_INVOICES and TBL_SHIPMENT_NOTES

However, the shipment notes are created earlier, thus there is no
invoice_ID when I create a shipment note.

How to deal with this problem ? Please, help ...

View 3 Replies View Related

Date Update And Created

Aug 11, 2007

Hello,
i would like to add in my database two fields: date update and date created automatically, but how?

thanx
sorry for my english...


windowsXP
access 2007

View 14 Replies View Related

Adding To Already Created Data

Jan 28, 2007

Hi folks

I have just devised a simply database but as usual when using it I found that I had left out some information.

To simplify - I could for example, make a drop down menu with the letters a-z but when finished realised that I had left out the letters K, L & R. How do I insert the missing data into the already created list?

Thanks for your help

Eulum:)

View 2 Replies View Related

Table Created By Files

Feb 23, 2007

I'm using access2003 and i want to organize a large amount of files in my company. There are thousands of files and I'm breaking the files up based on the dates. I want to create a table that automatically looks in each folder and links the job file with the job folder. This way I can create a custom query so a user just types in the job name and it will display what folder it is in. Can anyone out there help? Thanks

View 3 Replies View Related

Saving SQL Created On The Fly As A Query

Mar 4, 2006

Hi...

I am relatively new to access.

I have spent a few days coding a database search page consisting of various comboboxes and textboxes. the user can select or enter data in these and when he/she clicks the search button an SQL select statement is generated on the fly and updates an existing query and this is used to query the database. I want to be able to give the user the option to save the query he/she generates and reuse it. How can I prompt him for a name and turn the SQL string strSQL that he has generated into a query and save it for later use?

Any help greatly appreciated..thanks

View 4 Replies View Related

Reset Created Autonumber

Jan 28, 2005

I have two fields

1. Month (date field that shows only the current month only, ex: 04)
2. ItemNumber (created autonumber using =Dmax("ID","Table")+1 to retrieve the number from the previous record)

What I would like to do is everytime the current month changes I want the ItemNumber to reset to one.

I tried an If statement in the on current of the form
If Month <> Date() Then
ItemNumber = 1
Else
ItemNumber = Null

However it resets for every new record created, which by the code makes sense. Is there any way to have do this one time until the change of date or is there another way to go?

View 2 Replies View Related

Created Linking Table

Mar 12, 2013

I have a database with the following tables (among others):

tbl_Projects
tbl_Staff
tbl_ProjectsStaff
tbl_Payroll
tbl_Training
tbl_Clients

tbl_ProjectClients
tbl_ClientContracts
tbl_CostEstimates

As you can see I created two linking tables (project/staff and project/client).After that I linked other tables to the liking table. For example, tbl_Payroll and tbl_Training are linked to the tbl_ProjectStaff primary key.

I don't know much about access so I wanted to check if this is a correct design. I create forms that work well, but I noticed that the linking table doesn't have any data in it. The payroll table and the training table have the staff iDs and Project IDs but the tbl_ProjectStaff is empty.

View 14 Replies View Related

Linking Tables W/automatically Created Value

Nov 22, 2005

Don't know where this question will rank. Completely weird or completely common.

I've been getting great suggestions from this forum, one of them was to begin creating seperate tables for our data (I'm currently cleaning up a mess created 10 years ago for a nonprofit). The best way I have found to link/associate/whatever tables is to use their STUDENT identification number (since this value never changes). So we linked tests to that number (many tests to each student) by entering each new test as a seperate item with a manually entered stu id. We linked TUTOR and so forth the same way. But now I would like to start linking some more things. Particularly INSTRUCTION HOURS.

The question I have is this. How do I automatically create a value in the HOURS table that links to the value (stu id) in the STUDENT table. So that every student (previous and new) will have ONE associated HOURS set each time new student data is entered.

View 3 Replies View Related

Is It Possible To Make A Table Replicable Thats Already Been Created

Jan 11, 2007

I have tables in a database that are not ticked replicable at present (tick button is greyed out), this is causing
the records in the table to become scrambled when we attemp to replicate the database.

Any advice please, with over 50 tables in the database we don't feel inclined to start from scratch.

Any help appreciated.

Matthew

View 7 Replies View Related

How To Add Fields To A Table After A Form Has Been Created.

Feb 24, 2006

Anybody able to help me with this. I think there should be a simple solution to it, but it eludes me at the moment. Basically, I have created a form in MsAccess with alot of vb script on it, but
now I realise that I have to add more fields to the source table.
If I insert a new unbound text box onto the form, how do i bind it to
the new field in the source table. is there a formula that I should
use? When I look at the dropdown in the control source property, it
only gives me the fields that were in existense at the time the form
was created?

your help appreciated

thanks

View 3 Replies View Related

Forms Created From Starting A New Switchboard

May 13, 2006

This is probably elementary, but I'm entirely lost. Here's my issue:As most of you probably know, when first creating a switchboard in a database will automatically create a form based on it.Somehow I managed to delete that form, and have no idea how to make a new one with the same default switchboard format (where command buttons are automatically generated, and there's a default title label with the shadow effect, etc.)I thought I might try to just delete the switchboard and create a new one so that another form would be created, but it won't let me delete the switchboard!If I understand correctly, I have to create a switchboard without any other switchboards already existing for Access to create a related form for me. Any suggestions?

View 6 Replies View Related

Trash File Created When Exiting

Nov 19, 2007

One of the users of my databases uses a laptop. Whenever he exits the database, he leaves behind a trash file. Does anyone know what causes this?

View 2 Replies View Related

Forms :: Use Records ID But It Hasn't Yet Been Created

Aug 24, 2013

I'm in a form that creates the new company in the companies table. Then I want to leave a note in the notes table using the newly created company_id. Of course that id does not yet exist. What's a good way to accomplish this?

Code:
Private Sub b_EnterSave_Click()
Dim stDocName As String
stDocName = "company_quick_enter_form"
Dim CompanyIdStr As Integer
CompanyIdStr = Forms.company_quick_enter_form.Form.company_id

[Code] .....

View 4 Replies View Related

Email Each Time New Record Is Created

Jan 10, 2013

I'm working on a database to create service tickets for a small IT Department. I've created a form that would be sent via email using the collect data option. The thing is that I want to send an auto-response email each time a new record is created to the person(IT user) submitting the data. What is the best approach for this?

View 1 Replies View Related

Running An Automated Query Created In MSACCESS

Jul 20, 2006

Hello All,

I am new here and new to Access.

I have created a query which allows me to schedule daily events. But I want to automate this. Let me explain what i am trying to do.

Every morning at 7 am I want this query to run and the output of which to be mailed to myself. All this without me having to hit any button of sorts.

I have a long shot but very inefficient answer to this - which would be - having to leave my MS ACCESS running all night with an infinite loop checking to see what the system time is. When the infinite loop equates to 7 am it runs the query. But I think this would be a massive memory guzzler and I don't like this solution. Is there something else I can do?

Thanks for you time.

Regards

View 1 Replies View Related

Linked Table Being Deleted And Created Locally??

Oct 6, 2005

I have just split my multi-user DB into Front end and back end. All appears fine apart from there is code in the autoexec module that checks to see if a particular table has been updated today. Basically the first person to login to the DB each day will run this procedure without realising. Now I have FE & BE however, because the query used by the autoexec module is a "Make table" query rather than delete all data and use an append query, every person logging in is running the update each day if it is the first time they have logged in on their PC and they are getting a local table on each of their computers. Is there any code that will create the table in the networked location (when the first person of the day logs in), rather than me having to change all my "delete table" queries to cleardown data and then re-append updated data?

There are quite a lot of delete queries in my DB and I am now worried that I shouldn't have split the DB as I may have caused myself loads of work which I don't have time to do.

I have looked on other threads but cannot find the answer and would greatly appreciate some help

View 11 Replies View Related

Can You Add The Date/time To A Newly Created Table?

Mar 9, 2007

Is it possible to have the Date/Time appear as part of the name of a table? I don't want to create and rename a table I want to run a Query that will create a Table that will have the name + date or just the date.

Example

"Todays file 20070308 11:10:34 AM"

or
"2007080308"

Or
"2007080308 11:10:34"

View 3 Replies View Related

Sequential Number Created By A Query URGENT

Jan 5, 2006

I am trying to create a sequential number field in a query. I cant use an auto number for the fact that i am combining multiple tables. Any help with this would be greatly appreciated.

View 14 Replies View Related

Blank Record Created When Closing Form

Nov 4, 2005

I have a statistical program and the user constantly use the form to check calculations and get out without saving a record. In order to allow this with out writing to the table I used unbound fields and an accept and close command buttons.

This worked well until I added a subform to one of the forms. Now, if I just open that form and then click the close button, I get a blank record in the table associated to the main form. Is there a way to stop this?

View 1 Replies View Related

Can't Save Forms Created By Form Wizard

Jan 2, 2006

guys hello
i'm having a very weird problem i'm using access 2003 and when i'm creating a form using the wizard for the forms i can't save him i when i'm pressing the X button i'm getting the dialog to save the form and promted for the form name but it doesn't do anything and the form do not closes , when i'm creating forms by manual this problem doesn't appeares . i'm already (uninstalled and installed ) * 5 office , installed windows again , deleted the office dir , deleted the shared office directory cleaned the registry installed another version of office and no effect . i would appreciate any help thanks.
Igor

View 3 Replies View Related

A Button To Delete A Newly Created Record?

Sep 19, 2006

Hokay, firstly my apologies if this is the wrong subforum, but since my question revolves around the behaviour of one of my forms I guessed the thread should go here.

I have a very simple little database which I use to log RMAs (Returned Merchandise Authorizations). The database consists of three forms:

Form A - The switchboard. The main menu, works fine.
Form B - The View/Edit window. Allows me to look at the records in the database and alter them if necessary, works fine.
Form C - The Add window. Has the same form layout as B, but allows for adding records only. This is the one causing problems.

Now the situation is that when I enter Form C, the box for the RMA number gets autofilled out - which is correct - thus creating a new record. However, what I want to achieve is a button on the form that will allow me to quit back to the main menu without saving the record that has been created by opening the form. This is for situations where the form has been accidentally opened, or where a form has been started, but is not required to be finished.

View 2 Replies View Related







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