Change Database Name

Sep 14, 2006

Hi

This is going to be very simple so someone !!!

All Iwant to do is change the name of my database.

Currently it is called 'Test' and I now want to call it by the proper name.

I have changed the icon name that is displayed in Windows Explorer and also on all the forms within the database properties window.

However the name 'Test' still appears at the top of the main Access window!!

How do I change this so that it says the new name?

Any help would be appreciated.

Thanks.

View Replies


ADVERTISEMENT

Change Default Database

Dec 4, 2007

I have tried to change the default database with the tools options general tab. I type in the change and it sticks as long as I do not get out of Access. However, once I do get out it goes back to the old default selection. How can I make this stick??

View 3 Replies View Related

General :: Change Database Name

Mar 12, 2014

I'm trying to change database name, and not the one in database properties and changing the title. I've done that already.

View 8 Replies View Related

Database Location Change

Jul 21, 2015

I use Access 2013, and have an Access Database in which one of my Tables is linked to a SharePoint site (SharePoint 2010). The database is in my computer, but I will be required to shift it into another computer onto a network drive. I want to know if doing this will affect the table's link or data exchange between the table and its linked list on SharePoint

View 4 Replies View Related

MDE File Still Allows Me To Change Database Design

Mar 16, 2007

I've converted my DB into an MDE file as I understand this secures all the code and doesn't allow any changes to the database (table structure, queries, etc.).

However, when I now view my MDE file, I can still delete queries and change tables. But I cannot view forms in design mode and therefore get access to the code.

Any ideas?

View 3 Replies View Related

Unable To Delete Or Change Name Of Database

Jan 23, 2008

I have tried to rename or delete in MS Explorer, but this just creates confusion. The databases still show up in bits and pieses on various screens. I've purchased 2 additional how to do it books on MS Access 2007 and find nothing on deleting or renaming an entire database and all objects or references to it. Does anyone know the magic bullet?:confused:

View 3 Replies View Related

Change Colour Of ALL Labels In Database

Feb 6, 2006

Hi

I have a problem where the user has certain contraints in colour.

I am trying to change all the colours of labels in the database to purple.

Is there any way to declare it once in the database and all label statements will pick up the new colour. Saves me going through every form. Also there are other users who want to use the database with black.

???:rolleyes:

View 2 Replies View Related

Unable To Change Owner For The Database Object

Jun 16, 2005

I have Access 2003 and I am trying secure my database.
I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the database object..current owner is Admin.

What can owner do that admin cannot do?

Please help..

Thanks a bunch.

View 3 Replies View Related

Unable To Change Owner For The Database Object

Jun 16, 2005

I have Access 2003 and I am trying secure my database.
I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the database object..current owner is Admin.

What can owner do that admin cannot do?

Please help..

Thanks a bunch. :confused:

View 4 Replies View Related

General :: Change Link From One External Database To Another?

Feb 26, 2013

I've got an Access 2010 application that currently links to a SQL Server 2000 database. I need to change the link to a SQL Server 2008 database on a different server. Where do I go to change the link? When I click on External Data, ODBC Database, I only get an option to import source data. I don't want to import any data. I just want the application to link to a different external database. If I go ahead and click OK, I choose my ODBC connection and log in to the 2008 database. Now I've got a list of "import objects" to choose from. I choose one table (just for testing; I actually want to link with all tables), it says it imported successfully, but when I view the data in that table from Access, it's the same old 2000 database data.

View 5 Replies View Related

General :: Change Password For Back-end Database

Jul 22, 2015

I need to change the password to the front end of my split database. How would I do this?

View 1 Replies View Related

Moving Database - How To Change Path To New Location

Jan 10, 2013

I am new to Microsoft access. I have a database moved from another computer. it is split into the backend and the front end..

However, when i click on the forms in the front end, I get an error message. It is trying to use a path from the old computer, to the database, but its on a different computer.

So, this brings me to my question, how do i change the path, to the new location

View 1 Replies View Related

Change Primary Location Of Access Database?

Jun 3, 2013

I created a database that I want to move to a server for others to access. When they open it, it says invalid path. It's looking for my desktop. How do I get this whole database moved to a shared location on a server?

View 8 Replies View Related

Reattaching Back End Database After Drive Change

Jul 20, 2013

I have a big (reasonably big) Access 2003 db which I have split. On the E: drive this functions perfectly. Years ago I moved it to an other drive and found that to reach the back end again I had to change the drive letter in the link to the tables. Unfortunately I can't remember how I did it - all I remember is that somehow I brought up the link path and could then simply change the drive letter. I now find it necessary to put the db on an external drive for use with different computers. It will probably be easiest to put "." instead of a drive letter in the link, but after trying all menu options for db, tables and macros I still haven't found out how to access the link path.

View 2 Replies View Related

General :: Cannot Change Field Data Type In Database

Mar 18, 2014

In my database i have a field for Tonnage (quantity) ...

I need for example to input 38.60 or 37.89 so my values must have 2 decimal places, ive searched and found changing my field type to double or decimal should solve the 'numbers rounding up/down' but access will not let me change the data type?

View 1 Replies View Related

Forms :: Change Query To Look At Same Tables On SQL Database / Cannot Add Records

Jun 24, 2014

I am running access 2007 in Win7. I have a time sheet application that I wrote many years ago. Within same I have a button to press to open a new form to enter time sheet data. The data for the form comes from a query that links Employee and the Timesheet history data file.In an effort to upgrade and make the application more portable and available to multiple users, I decided to migrate the data tables to a Microsoft SQL 2012 database. Various Access reports based on the SQL database run ok. But if I try to open a form to add a new record I get the following error message:-
"Run-Time Error '2105' You can't go to the specified record."

If I debug the error it shows:-
Private Sub
Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

In an effort to make sure the original time sheet form load worked ok on the original tables, I changed the query to feed off tables in the local Access program and have no issues. It works perfectly. Also if I open the Timesheet Query that feeds the form I can add new records.However if I change the Query to look at the same tables on the SQL database I cannot add records. I can search all records from first to last but not add a record into the query. The add record arrow is greyed out on the query results.

View 5 Replies View Related

Queries :: Make Only One Change In Mdb Access Database With Lot Of Rows

Nov 7, 2013

I need to make only one change in my mdb access database with lot of rows.For example, I have two columns: "num1" and "num2" with numbers and need to create new column (as a text) according the rule: num1 # num2....That means if the numbers in num1= 12 and num2= 1,3312, thenthe text in new column should be: 12 # 1,3312.

View 5 Replies View Related

General :: V2010 / Change Database For Multiple Users?

Mar 18, 2013

How do I change the database for multiple users?

There is no "advanced" option in the options tab.

View 3 Replies View Related

Lock Database Back End For Any User To Change Data?

Jun 27, 2014

using the "back-end" and "front-end", how to put a password also in the "back-end"? is to lock the database "backend" for anyone to change the data?

View 1 Replies View Related

General :: How To Change Font In Database Objects List View Windows

Oct 1, 2013

How to change font in database objects list view windows? (not datasheet, table/query windows)

View 1 Replies View Related

General :: Change Splash Screen For Database Using Method Of Creating Alternative Bitmap

Oct 17, 2014

I've changed my splash screen for a database using the method of creating an alternative bitmap.Is there a time setting for this or an alternative?

View 6 Replies View Related

How To Access Ms-Access WorkGroup Tables To Change Database Login Password

Apr 13, 2007

Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.

Regards,
Kishore

View 4 Replies View Related

Forms :: Change Button Color After Data Change

Apr 5, 2014

I am trying to change the button color on a subform if a related form data changes.Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any).The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number. Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form

2346 location warehouse price 29.99 (button - green)
2347 location shop price 29.99 (button - red)

View 1 Replies View Related

Change One Form Causing Change Other

Jul 2, 2005

I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003?

Thank you very much for help.

View 2 Replies View Related

Change Field Value On Change Of Other Field In Form

Apr 2, 2008

What I want to do is following.
In form ASSIGN(fields are takedate and inout) ,if TAKEDATE is different then 0 then set value of inout field to 1
My VBA knowledge is poor cause i dont think this should be hard

thanks in advance

View 8 Replies View Related

Database Size Limited To 2GB / Query Multiple Database Without Linking Tables?

Sep 7, 2011

I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:

1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.

2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.

I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.

View 3 Replies View Related







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