I am trying to open a MS Access Database which was made in MS Access 1997 or MS Access 2000, at the moment i am using MS Access 2010, i cannot open the database or link the tables.i do not have MS Access 2000 anymore.
View RepliesIs there a way of specifying the version number of an Access application?
e.g. In classic Visual Basic you can specify the version number in the "Project Properties" menu option and then use these values in code by doing an app.major, app.minor etc... (or something like that).
Is there an equivalent in MS Access?
Cheers,
Kabir
I am working on a section of code that when a user clicks a button it looks at a table called TBLVersion and increments the version number. The version number format is 1.0.1 what I need the code to do is increment the last digit by one for example to "1.0.2". I got the flowing code to work in excel but could not figure out how to translate it to access.
=LEN(A1)-SEARCH(".",A1,SEARCH(".",A1)+1)
=RIGHT(A1,B1)
There are around 100 customers.And on application open, need to check if customer has paid invoice. If the customer has paid/not paid need to change the status accordingly. Form on open event changes status of only the first customer.Form on current changes status only if we move to the specific record. Is there an event to trigger to check the entire table records on application open?
View 9 Replies View RelatedI have a small database application which is split in fe and be. Its running fine and i have been making changes to the front end regularly and replacing the file on server successfully with no problems, But today i edited some forms and reports and afterwards i ran it on a client in access runtime produced the on click event error ( which is on log in form which is a startup form ). Its working fine in full version of access even on the server but couldn't log in because the clicking on login button display the error. See attached image.
View 6 Replies View RelatedI know how to convert an Access database from a previous version of Access to a higher version of Access, using the shell command:
x = Shell("C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE " & Chr(34) & strOLDDB & Chr(34) & " /Convert " & Chr(34) & strNewDb & Chr(34))
However, what do I have to do to programatically revert from my current version of Access to a previous version? Is there a shell option similar to the /CONVERT choice? It would be nice if it was as simple as /REVERT
Thanks once more to you forum gurus!
Okay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..
View 1 Replies View RelatedI was looking to see if there was an easy way to create a user front end desktop application for a small access database.I have three users on different computers i would like them to input or amend data within one table of the access database.
View 2 Replies View RelatedI 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?
I've been working on a database for the past month and all of a sudden I'm getting an error "the microsoft jet database engine could not find the object 'database'" and when I click ok nothing is showing (i.e. no project window or anything). I normally do backups on something this large but for some reason I didn't on this one. The size of the file is still large but doesn't look like anything is in it.I've tried opening a new one and link and import everything but I get the same error.
View 4 Replies View RelatedThis seems like a very silly question but I wondered if someone could tell me how I open up another mdb file from a form?
I've tried the following
On Error GoTo Err_Command976_Click
DoCmd.Quit
Dim stAppName As String
stAppName = "S:updateUpdateMDEUtility.mdb"
Call Shell(stAppName, 1)
Exit_Command976_Click:
Exit Sub
Err_Command976_Click:
MsgBox Err.Description
Resume Exit_Command976_Click
End Sub
But I just keep getting "Invalid Call Procedure or Argument"
Many Thanks
Andy
I'm having problems with my database. It was on a USB memory stick and suddenly I got a message to format the entire USB memory. I managed to retrieve the files on the USB and loaded them onto anothe USB, but when I tried to open the database I got the message:
"Cannot open database ". It may not be a database that your application recognizes, or the file may be corrupt."
However, when I tried it on another computer I managed to open the database but when I was closing it I got the same message again. The database is working OK, but how do I get rid of the message?
I am probably staring right at it - but where is the option to set Access 2010 so that it automatically opens a specified database on startup?
View 1 Replies View RelatedCannot Open Database". It may not be a database that your application recognizes, or the file may be corrupt. I have a colleague that is using Microsoft Access to import objects from SQL server but he's getting the above error. I've checked the login my colleagues uses and it has all the right permissions ect but I cannot seem to figure out why this error is still happening. Is it something to do with the SQL server or Microsoft Access?
View 1 Replies View RelatedI am trying to get windows server 2012 task scheduler to open my access database. When the task runs all that I see happen is the locking file will appear on my desktop and I have to go to the task manager and kill it to make it stop. I tried a .bat file to open it as well and im still getting the same thing. If I just click on the database and open it manually it runs just fine.
View 3 Replies View RelatedI have a shared 2000 db and for the last few days someone has been leaving it open. In '97 you could open the .ldb file and see who it was, is there a way to find out in 2000?
Also, I have seen something on remotely removing users who leave the application open but can't find it now. Does anyone know how this is done? The data must be refeshed daily and hasn't been for the last four days due to this lock.
Hi all..
I need to open an application when user clicks a command button...From this forum I have learnt that I can use SHELL command..but when I use this command to open an application, it opens a new instance of the application everytime...Can I bring the application to the foreground if it was already open?
Thanks in advance.
Hi all,
I have an application which needs to be embeded in a form. The reason for this is that we need other details in addtion to what the application.exe can perform. When a user loads a form the application needs to start up within ACCESS form.
Can you please reagard this as high priority.
Regards
Sidtech
I am trying to set up something to be able to take me to a folder that holds various forms for personnel. I have a query that generates the link for each person. I have tried to set it up as a hyperlink in ACCESS 2013 and it displays as one but doesn't act like one.
I want to be able to click the link and have it open up a personnel folder for that individual. I can't find a MACRO that I can create to do it. Example of my query is that it creates a link K:Main BreakdownSection BreakdownPersonnel FoldersName and the name is the variable part.
My next problem will be to have it create that folder when we have new personnel arriving.
I would also note that I have not worked with ACCESS in many years and much of what I was able to do with 2002 and 2003 doesn't work with the newer versions of ACCESS.
I have recently inheritied a database and find that there are functional differences between different versions of the database. The database contains over 30 very large tables and I am unable to find the differences between the versions. I need a process or tool that I can use to compare the different versions to find the table/record/field differences. I am up against a deadline and am needing a solution ASAP.
View 1 Replies View RelatedI have a split database with the backend on our server. When I go to my server and look at all the open files on the network everyone who is in the backend shows up twice. One has zero locks and the other has multiple locks.
View 2 Replies View RelatedI want edit my Access Database on my Android phone, is there any good App recommend ?
View 2 Replies View Relatedi want to ask is there any way to open another access database using when click button at form.. for example i have tracking.accb then at my switchboard form, i would like to have a button that can go to another access which is borrow.accb. can these possible for me to do it..?
View 3 Replies View RelatedI 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 work in three different databases, but for one of them (the main company db), if I right clicked the pinned Access program on the taskbar and click the pinned database, it does nothing if someone else has the file open already. If the file isn't open, it'll pop up with an "Unknown publisher" warning (new, never happened before this), but it'll open the file. If someone has the database open, it doesn't flicker or even try, it just does nothing.
I am able to open Access and click on the database in the "Recent files" and have it open that way. I don't know what to troubleshoot, its like it's not seeing the file, but I can go to the properties on the pinned db and it shows the correct file location. I'm the only one having this issue, the other users here can right click the pinned program and open the file like normal.
I've rebooted my computer; unpinned and removed from list; compacted and repaired; nothing is making a difference.
All of the sudden I get an error message when I try to open my database from a file rather than through Access. If I open Access first and open the file that way, there is no problem but if I click on it from Windows Explorer, I get the error.
See picture.