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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Oct 1, 2013
How to change font in database objects list view windows? (not datasheet, table/query windows)
View 1 Replies
View Related
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
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
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
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
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
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