Using Files Created In Access 2003 In Access 2000
Nov 30, 2004
Hi:
The company I am consulting with uses Access 2000 and has no intentions of upgrading. I currently do not own Access on my laptop.
I was planning to purchase Access 2003 for my laptop but am concerned that files I create in 2003 might not be "editable" in 2000 even if I choose the 2000 format when creating new databases.
I'm just wondering if anyone has tried creating a file in 2003 (using the 2000 format - as I'm told you can choose what format you want to use) and then edited it in 2000. I want my client to be able to edit the files in 2000 once I've moved on. (I can get 2003 for about the same price as 2000 - so my preference would be to get 2003.) The other obvious reason for going for 2003 is that I could run into the reverse challenge if I own 2000 and my next client uses 2003. At that point, I'd be forced to upgrade to 2003.
My databases are not complex - but do include some customized macros.
Any help, comments... appreciated.
Thx,
dave
View Replies
ADVERTISEMENT
Jun 17, 2005
I have an Access DB that I created in Access XP. It works perfectly when used in Access XP. When used in an Access 2003 environment some of the functions don't work anymore. I have users who use Office XP and users who use Office 2003. Does anybody know how to make this DB work in Access 2003 without having to do wholesale code changes?
I have already changed the security to "Low" to bypass the security feature built in in Jet 4.0 but it didn't help. I might have to uninstall Windows XP SP2 to make it work because I know that the application works in an Office 2003 environment with Windows XP SP1 only. But I'm trying to avoid having to uninstall XP SP2 because it's a pain. Any ideas would be greatly appreciated.
Thank you.
My workstation environment is as follows:
OS: Windows XP SP2
Office: Office 2003 SP1
Jet: 4.0
Raneil
View 2 Replies
View Related
Apr 15, 2007
I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
View 1 Replies
View Related
Apr 19, 2005
I am working on a massave aplication that has been running in Access 2000, but recently several of the file sharing users have installed Access 2003 because of the limited availability of Access 2000. All the users are using the same file off the server.
The problem we are having is that when we reference a subform in the "[Forms]![FormName]![SubformName]![FeildName]" Access 2003 does not recognize it and returns an error. I have found that if I will modify it to "[Forms]![FormName]![SubformName].[Form]![FeildName]" it is recognized in both 2000 and 2003.
To try and change every instance of a subform reference will take forever and I am garuteed to overlook something. We reference subforms all over our program, missing any one of them would be a disaster. Before I went to the tedious task of looking through everything I just wanted to throw the situation out there and see if any of you had any great ideas on how to get it fixed efficiently. I would apreciate any ideas.
View 5 Replies
View Related
Jun 6, 2005
I upgraded a 2000 db to 2003 recently. When I ran the function below it gave me an error on the line in green. Any thoughts? Thanks.
Const FIRSTROW = 13
Dim wsp As Workspace, dbv As DAO.Database, tblResolve As DAO.Recordset
Dim tblVchs As DAO.Recordset, tblImpTmp As DAO.Recordset
Dim ObjXLApp As New Excel.Application
Dim FileToOpen As String, WhereCriteria As String, ImportTemp As String, tmpVch As String
Dim TotalDupes As Integer, TotalGood As Integer, TotalRejects As Integer
Dim TotalBlank As Integer, R As Integer, C As Integer
Dim BadSheet As Boolean, ImpFail As Boolean
Dim tmp, tmpType, tmpCtr, tmpRsn
If Forms![Import Block Vouchers]![Import Program] = "0" Then
MsgBox ("You must select a Program to load.")
ObjXLApp.Quit 'Exit from MS Excel
Exit Function
End If
View 5 Replies
View Related
Sep 14, 2005
Hi,
I've created a database in access 2003 with the default file format being Access 2000. Everything works fine on my computer and many others, all of whom are running different versions of access (2000, 2002 & 2003).
I have not had any problems with this database until recently and in the last few weeks we have had 2 users, both of them being Access 2000 users who have had the same problem.
The problem they are having is that when they click on any of the switchboard items, the buttons depress an then come back up again when the cursor is moved away, but nothing else happens - no action, no error message - nothing!!! Its the same for all of the buttons on the switchboard.
Does anyone know what is causing this? I have another computer with Access 2000 on it and this works fine, as it does on several other computers runiing Access 2000, I just cannot understand why it is not working on these 2 particular machine.......
Many thanks in anticpation.
Steve
View 3 Replies
View Related
Sep 20, 2005
I have recently installed access 2003 w/access 97 installed both are on my hard drive. When I create a new db in access 2003 it saves it in an access 2000 format. Does any one know why it does this?
Thanks--Appreciate any help
View 2 Replies
View Related
Dec 7, 2005
i am trying to use access 2000 database onto to access 2003. When i try to click design mode to change something it gives me this message:
You dont have permissions to modify.
If i run it on access 2000 it runs fine.
Someone please help.
View 5 Replies
View Related
Sep 27, 2006
Hi,
A few years ago I’ve made an access database on access 2000. The problem is that now I’ve installed the office 2003, and I can’t make the database work properly.
At first says that are missing those files: “tshoot.ocx”, “msioff9.ocx” and “msowc.dll”; so, I’ve copy them from another computer using office 2000 and now only complains about “msioff9.ocx” saying that my database contains a reference incomplete to it.
Is there no other way to convert my database do work properly with access 2003? What can I do?
Regards
View 2 Replies
View Related
Sep 20, 2005
I have recently installed access 2003 w/access 97 installed both are on my hard drive. When I create a new db in access 2003 it saves it in an access 2000 format. Does any one know why it does this?
Thanks--Appreciate any help
View 1 Replies
View Related
Nov 24, 2007
Hello all,
I would like to know to how a control created in VB 2005, be used in access 2003.
Thank you.
View 3 Replies
View Related
Apr 25, 2005
I have one Project in Ms access 2000.
If I create Setup(Package) it's working fine in Access2000 but for Access 2003 I need to install Ms Access 2000 Runtime.
Kindly tell me how to install Access 2000 Package in Access 2003 without installing Access 2000 Runtime.
Can it support backword compatibility ?
Thanks
John
View 1 Replies
View Related
Aug 26, 2005
How unusual is it for a database to become MUCH smaller when converting it from 2000 to 2003 formats. I mean 600megs to 10 megs. And as far as I can tell all the records are intact....!
View 1 Replies
View Related
Jul 27, 2007
I have 5 databases running 100% in Access 2000. We are switching to Office 2003 within a couple weeks via an upgrade. What should I do to prep my databases for the switch?
Is there any upconverting tool I need to do ect? Thanks.
View 9 Replies
View Related
Sep 26, 2006
Hi,
Is it possible to attach files (word, excel, emails etc) to records in Access?
I want to build a simple contact database that will enable me to add a word document to John Smith, for example
Regards
Djuro:cool:
View 1 Replies
View Related
Aug 24, 2005
It's not letting me open it since i did it in 2003, and im trying to open it now at home in 2000.
I'd really appreciate if anyone can help me convert it and then attach it...thanks :o
View 3 Replies
View Related
Nov 27, 2006
Hi, I have a few Access 2003 databases and I need to open them on my computer which has Access 2000 on it. Can anyone please tell me how to convert it so it is compatible? I have looked into "databse utilities" "convert to" etc but can't figure it out.
View 4 Replies
View Related
Aug 10, 2007
I have developed quite a few Access 2000 applications for clients and continue to maintain and update these applications. I am starting a new position with a client using Access 2003 at the client's location. I would like to upgrade to 2003 but I still need to service my 2000 clients. Can I install and run both versions of Access or can I still maintain the 2000 apps under 2003? Help!
View 4 Replies
View Related
Mar 24, 2008
I converted an MS Access 2000 DB to 2003 with no problems. I am able to open it up in Access 2003 now either by double clicking it or from Acccess - file open. I then created an MDE file in Access 2003, but when I tried to open it up I got a message saying
This database is in an unrecognized format.
The database may have been created with a LATER version of Microsoft Office Access than the one you are using. Upgrade your version of Microsoft Office Access to the current one, then open this database.
I noticed a service pack will get rid of this errror. My question is if I distribute the MDE will the user get the same error if they don't have the service pack installed on their PC? Will my installation of the service pack fix the errror and allow anyone to use the file without getting the message.
Thanks
View 2 Replies
View Related
Feb 24, 2006
I never realized how wonderful Access 2000 help was until I tried using Access 2003. Last night I went to MS online to see if I could download Northwinds.mdb 2003 database samples...I couldn't find anything. can someone recommend a good Access 2003 Developer's book??
View 2 Replies
View Related
Dec 28, 2005
I have written my very first database in Access 2003 but it tells me that it has been saved in Access 2000 Format.
My questions are:
1. Why has it done this?
2. Can I change it 2002 or 2003 format?
View 3 Replies
View Related
Jun 13, 2007
Hi
At work I was just updated to access 2003. I am trying to update a data base that I created in access 2000. Whenever I try to open a data access page I get the following error. "The installer encountered an internal string error. Installation failed." I've updated the Web components and that seems to have gone ok. My IT people are at a loss.
Any suggestions?
Thanks
John
View 1 Replies
View Related
Feb 28, 2006
Hi,
I'm just wondering if there is any differences in writing queries in vba in different versions of access. i'm developing a search function in access 2000, but it doesn't seem to be working. however, the same code in access 2003 works fine.
Here's an extract of the code when the search button is clicked (I'm getting table information, attribute/field information and condition they're specifying from the user. The result is then displayed in a subform):
Private Sub cmdFind_Click()
Dim searchSQL As String
Me.cmbTable.SetFocus
searchSQL = "select * from ENGINEERS INNER JOIN TEL_CABLING ON ENGINEERS.EngID = TEL_CABLING.EngID where " & Me.cmbTable.Text & "."
Me.cmbAttribute.SetFocus
searchSQL = searchSQL & Me.cmbAttribute.Text
Me.txtCondition.SetFocus
searchSQL = searchSQL & Me.txtCondition.Text
Me.subfrmTest.Form.RecordSource = searchSQL
Me.subfrmTest.Form.Requery
End Sub
The part in red is the part that is highlighted whenever i run it in access 2000. The error message is: " You entered an experession that has an invalid reference to the property RecordSource "
Can anyone tell my why it's like that and how i can fix it to work for access 2000?
Thanks I've also enclosed a picture of the form, so you can get a feel of what it looks like.
Kathy
View 1 Replies
View Related
Jul 9, 2007
Hello all
This morning I converted an Access 97 db to Access 2003. Unfortunately the db will not now open any .pcx files. Does anybody know if there is there an issue with .pcx files. According to MSDN Access should (and you would expect it to) open .pcx files. I did notice that when office 2003 is installed it does not install the pcx graphics filter PCXIMP32.FLT and it does not appear in the graphics conversion tools download for 2003.
Regards
DennisK
View 1 Replies
View Related
Jun 24, 2005
Hello..
I got the following code from this forum to create shortcut on the desktop..
==================
Set objShell = New WSHShell
Set objShortcut = objShell.CreateShortcut(objShell.SpecialFolders("AllUsersDesktop") & "" & sShortcut)
objShortcut.TargetPath = sDB
objShortcut.WindowStyle = "3"
objShortcut.SAVE
=================
I have Access 2003..but file format is 2000 because others have access 2000.
This code works great on my machine..but getting error on access 2000 machine..It does not recognize "New WSHShell" in the above code.
-------------------error message
Compile Error:
User-defined type not defined
-------------------
Any references needs to be added?
Please help...Thanks..
View 1 Replies
View Related
Apr 8, 2006
I have successfully used the recommended way to display images from a folder in a form as posted on the microsoft website.
http://support.microsoft.com/kb/210100/
These instructions were for Access 2000. I noticed that there are seperate instructions for doing this using Access 2003.:
http://support.microsoft.com/kb/285820/
My questions are:
1. If multiple users access this database using different versions of Access (2000 and 2003) will it not work for some?
2. do i have to modify code if i update to 2003?
Thanks for youir feedback!
~Bruce
View 1 Replies
View Related
