Running 2007. In 2003, to make a shortcut for an object, all I had to do is right click and place the short cut where i wanted.
I can't seem to find anyway to do it in 2007
Anybody have any clues?
I have created a database in Access 2010 and I am not able to open the same database in Access 2007. I have read somewhere that it is possible to open. I get the message, " Unrecognized database format". In Access options, the default file format is, "Access 2007".
View 1 Replies View RelatedI want to hide the top toolbars when my users open my database in Access 2007! i have an autoexec macro to maximise the window which gets rid of the navigation bar on the side but cant work out how to hide the top bar? do i need to write code? if so what code and where would i input it.. any help would be much appreciated...
many thanks,
Gaz
We have a new user who is unable to get into a database. Another user in the same office had no problems.
The other user is using:
"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerNameShareNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb
The new user was not able to access the share at all using ServerNameShareNameSFTP until he changed the path to:
"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb"
Now he can get into the SFTP folder, but when he uses the shortcut, he gets an error stating Microsoft Access couldn't find the file ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw 1" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb" (Note the space and 1)
I created a new shortcut, and I was able to open the db using his target line, even though I can use the shorter one. For the new user, this still generates an error.
We have an old Access 2000 db that is used by most of the company. I also have users who use it via a windows 2003 terminal server. I just created a new win 2008 remote desktop server and installed Access 2000 (What a pain that was).
Now from access, if I go to fileopen, navigate to the DB server and open the DB, it works fine. If I create a shortcut to the database on the desktop of the remote server, nothing happens. No error, no warning, no nothing. It's weird.
If I place a copy of the db locally, it opens just fine.I also tried mapping a drive to the db server and then made another shortcut and still nothing. I also created a shortcut and entered the path like this:
"C:Program Files (x86)Microsoft OfficeOfficeMSACCESS.EXE" J:QS XYZ.mdb
But that throws an error that it can't see the database.
I have a 2003 .mdb file and the associated Workgroup Information File which normally resides on a network in a folder V:V-Base-DatabaseDATA. I have the Workgroup Information File.
The database is unsupported and we need to migrate the data to a new web based database.
When I try to open the database with the shift key down I get the following message :
You do not have the necessary permission to use the V:V-Base-DatabaseDATAV-Basebe.mdb object.
What is the best way to access the data and do I need to do this on the server instead of a local drive off site?
I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.
Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.
I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?
Hello
I am using Access 2003(11.6355.6360) SPI
When I attempt to create a new DB - by performing Blank Database I immediately get a message 'Object Library not registered'.
If I 'OK' that box and try to create a table, I can do so - create Table in design view.
When I then try to Import external data - an excel file I get the message 'ActiveX component Can't create object'.
I have looked ob various sites for help and forum information regarding these errors but have found nothing conclusive, with specidfic regard to Access 2003.
The version has been loaded on my machine about 1 year as part pf Office Professional but this is the first time I have attempted to run Access itself.
Does any forum member have any ideas as to how this problem could be resolved.
Thank You
Rgds
Paul Langham
I need to display the out put of a table as chart in ms access 2007. My table is as below.
ItemID
Week 1 Value
Week 2 Value
1001
87
5
1002
80
1
1003
42
1
1004
55
164
In the chart X co ordinate should be the "ItemID" and the Y co ordinate should be the week number (eg, week1, week2 ...etc). Is it possible to display the chart with the above table? Or do I need to transform the table and then dosplay as chart? Also can I transform the above table as shown below using a single Transform query ?
ItemID
Week
Value
1001
1
87
1001
2
5
[code]....
Hi, I have been opening password protected access 2003 databases with ASP / ADO for years now. However now we have updated to office 2007 everything gone bottoms up.
I have an access 2007 database (newly made, not converted from 2003), and a fresh asp page. I've gotten the new connection string information for Access 2007 from the internet yet the page cannot open the database.
connection string being used:
sConnString="Provider=Microsoft.ace.OLEDB.12.0;Data Source=" & strPath & ";Jet OLEDB:Database PASSWORD= password"
When I try to open the page the error i get is - "Not a valid password" - 80040e4d. I'm 100% sure the password is correct, the driver is right (the server has office 2007 installed, and the new access driver from the M$ website). Every page i've seen on the internet says that the code I'm using is correct, yet asp still can't open it.
If i remove the password from the database it opens fine, so it's not a corrupt database, or bad path in the code.
If you can shed any light on my problem I would be eternally grateful - been working on it for hours now!
Many thanks
Ryan
I have a fully operational Visual Basic program that uses MS Office XP and it's related MS Access. Because of security concerns, I recently upgraded to MS Office 2007 and MS Access 2007. I can open MS Access 2007 using the shortcut on the desktop and run any of the database queries. When I try to run the Visual Basic program (called prjPathfinder) and open Access 2007, it says "Error 5: The type initializer for prjPathfinder.Upgrade Support threw an exception". It then shows the first form in prjPathfinder but does not open Access 2007. What am I missing?
View 3 Replies View RelatedOK, I have a very large Access database with embedded bitmap photos.
I have realized the error of my ways and would like to list them as linked.
The problem:
How can I get the embedded files out without individually going through, viewing and saving and naming?
Is there a way to save a file do a directory and name it, say the primarykey.bmp or something?
Please help!
Being physically disabled & using a headpointed to type & point to things on the screen so-so often I need to adjust my column width. How I can create a short cut/hot key to prompt the Column Width command?
View 1 Replies View RelatedHi All,
Background Info: I developed our main department's Access 2003 split database which is on a server for 15+ Users. I've now been given Access 2007 for development -- Users still have 2003. There are also 2 other smaller databases that are not split (.mdb).
Problem: In the split database, I've saved the Application .mdb as 2003, relinked and made a new .mde. But the Users still cannot open the database. (I did this in a copy until I figure out the nuances with 2007.) The 2 other unsplit databases can be saved as 2003 version and Users can open OK.
I'm grateful for any suggestions on working with Access 2007. I've been trying to tackle the ribbon which is a whole other question.
Hi
I have an Access 2000/2003 database which opens up and displays correctly in Access 2007, but when I go to use the File>Print command, or for that matter any of the other pull down menu's nothing happens?
Has anyone else experienced thisproblem, or does anyone know what I am doing wrong?
Any help greatly appreciated.
Thanks
Steve
Greeting All,
I am trying the beta version of Access 2007 and realize that when converting Access 97 to Access 2007, the new db in Access 2007 has an extension of .accdb. I rename the db file name to xxxxx.mdb and the VB app fails to recognize it.
Is there any way to convert the xxxx.accdb (Access 2007 beta) to xxxx.mdb so that I can try my app against the Access 2007 db?????
Thank you for your time,
ConKi
I am trying to copy/replicate an Access 2007 database. My objective is to have a new copy of the database, without any records in it.
Can't find anything in the Access help about this -- what I find in my old Access 97 does not apply.
Thanks
I am kinda new to 2007 and have at the moment a simple database.
I want three things
A: Use the database on a server.
B: Restrict the use to users etc as i used to be a ble to do in Access 97 i think (do i have to make a MDW if so how ?) 9I tried ACCDE but does not seem to do anything)
C: When users use the datavase not see all the normal access editing stuf..
Steve
I have built a database with Access 2007, and intend on sharing the database amongst two users.
I am running Vista, and the two PC's or on a peer to peer network. Both with Vista.
I have split the database, and put separate copies of the front end on each of the PC's.
The backend of the database is on the public drive on my PC.
Access opens and functions correctly on both PC's with 1 User logged in.
However, if both users are logged in, my collegues PC crashes when it tries to open forms. This does not happen on my PC.
Does anyone have any ideas on what I need to change. Thanks in advance.
Just upgraded to Acccess 2007 and have ownership problem extracting queries from a 2002 db.
When trying to import into a new 2007 or export from the 2002, get "you have no permission" message
Have created a new user tried to change owner of the db, but no permission
File security looks correct in that I am owner of the file with full permissions, but Access doesn't recognize me as the owner
Tried logging in as admin, but it isn't the owner either
This is not critical, just very time consuming, this is a test project, but it would be nice not to have to rewrite about 30-40 queries and equivalent forms
Any guidence appreciated
I am not sure where to post this question. I remember finding a forum just for Microsoft Access 2007 questions, but I couldn't find it again... Indifferent
Anyway, I have created a database, and have been testing it with my application. I have some data in this database. I was wondering if there was a way in Microsoft Access 2007 to create an empty copy of the database for release. In other words, I would like to create a copy of the database with all of the tables and columns, but without the data (rows) that I had entered as part of using my testing database...
Does anyone know if I can do this?
If anyone knows where this Access 2007 forum is, or resources that might answer my question, please let me know, as I would greatly appreciate that.
Thanks Again,
I'm using Access 2007 which I built a database that runs queries off of tables using ODBC. The database is all done in ms access, I've used no visual basic programing on it. I'm now trying to move a copy of the database to another computer's local drive in the office. When we try to open it on the other computer it gives me an error that says "There was a problem sending the command to the program" and Access hangs, which I then have to run task manager to end the program.
Specs Are: Windows 7 64bit (the db was created on Windows 7 32bit)
Microsoft Access Version 2007
I'm using Access 2007, with what I think is a normal database that I've built up over the past month (maybe 15 tables, <1000 records, 20 queries, 4 or 5 reports and macros). I'm not an experienced Access programmer, so I don't think I'm doing anything fancy with security settings or any other such stuff. (If I have, it's surely by accident, not by intent.)
When I try to back up the db using the simple office button -> manage -> backup method, access generates a date-stamped backup filename and opens a file save dialog for me, but it ALWAYS fails to backup the database. I always get the same error message when I click save, whether I save on my machine, or on a network drive.
"Could not use '<path to the current database dir><backname>.accdb; file already in use."
This same error occurs when I create a new blank database with a single Table1 in it, so I don't think it's my database.
Does anyone have any idea why this might be happening? I scoured the net for help, but nothing. I checked various Access forums, but nothing. So I arrive here after I've done my homework... thanks
I am on a deadline today and when I went to open an Access 2007 (I abhor the fact that I am forced to use 2007) database, it will not open. It gives me the error message Unrecognized database format [file path].
I have tried creating a brand new database and importing all objects from old to new but I get the same error message.
design a database in access 2007.
employee personal recordemployee job statusleave recordinventory record issue to employeejob performanceinventory control of equipmentforms, queries, tables, login forms.
I work with an Access 2007 database that I split into a front end and back end. The back end holds all of the tables and the front end holds the queries, forms and reports. It is also a multi-user database, in that we have 14 people having access to the same back end. Each of the 14 people have their own front end. I have one main table in the back end listing clients and their individual ID numbers. That table has a One to Many relationship with several other tables, such as Case Notes and Authorizations, to name a couple.
Here's one of my problems: Sometimes data that is entered by a user will disappear.
Example 1: User creates a new record in the Authorizations form. Sometimes it is created by duplicating an existing record, sometimes it is completely new. User then prints a report from that new record, which looks like it has been saved. A couple minutes later, or a couple hours later, or maybe even the next day, user goes back into the database and cannot find the record that was previously created. At that time I look in the back end and cannot find the record either.
Example 2: User creates a new record in the Case Notes form on Day 1. These are always completely new records. User returns to the database on Day 2 and the new record sometimes does not show up in the form or in the back end table.
I cannot MAKE these things happen and they are sporadic, which makes it hard to diagnose, but why this was happening or if there was a way to retrieve the lost data.