Access 97 To XP Conversion
Oct 14, 2004
I have an Access 97 database that I’ve converted to Access XP. The font end database is on each user’s computer and the backend is on a network server. The database is updated with data from a mainframe db2 databases. I have 87 queries that pull the data from the db2 data base and import the data into an Access database that resides on a net work server. All these 87 queries are append and update queries that clean up the data and set it up in Access.
In the Access 97 database it takes 9 minutes to run all these updates but in the Access XP database is takes about 32 minutes. Both the front end database and network database are converted to XP. I have found that if you link a 97 table to an Access XP database, you slow everything down in the XP database ???, so I’ve made sure that all linked tables are XP. I’ve looked at my queries and tried to optimize as much as I can but nothing has worked.
I have several parameter queries that really seems to run extremely slow. I’m updating fields in on table with data from a field in another table. I using the query execute method with a loop to set the parameter each time and then execute the query This works well in 97 but in XP it’s extremely slow. I’ve changes indexes in the tables and at one point and at one point removed all indexes except for the index on the joining fields in the table.
All of the forms and reports in the database also run much slower.
My company has also upgraded. When I was using the 97 database I was using windows NT. With the XP database I’m using Windows XP.
If anyone has any advice or ideas, I would appreciate hearing from you.
View Replies
ADVERTISEMENT
Mar 24, 2006
Hi,
I have been tasked with updating an Access 97 database with several forms that would take me a good while to recreate.
I wondering if there is a way to convert them from 97 to either VB6 of VB.NET that is free of charge to me. All the solutions I have come across thus far cost money, and it is not possible for me to do this.
I have tried exporting the forms to an external file but it won't let me save them as a file type that my VB6 installation can open.
Cheers
Murray
View 3 Replies
View Related
Feb 11, 2007
Considering the difficulties in packaging Access software, I am wondering about the feasibility of converting my Access project to VB and distributing that instead. Has anyone done this and if so how difficult would it be. Does it mean a complete rewrite or can I use existing forms, reports and coding etc.
View 12 Replies
View Related
Nov 10, 2006
Hi,
I've got a fairly complex access 2000 database that's split into front and back ends.
There's 32 back end tables and a whole host of complex front end queries and forms. The whole thing's around 25,000 lines of code so not a 5 minute job to rebuild! (sorry but i just can't stop tweaking it!!)
I hate the idea of all that data moving across the network, and having to make the front end machines work so hard so I'd like to get the server doing it's fair share of work because it's got dual 3Ghz Xeon processors which aren't earning their keep! I was thinking about converting the mdb to SQL and although i could pay someone to do it for me, i do like to learn! (so when it breaks i'm not at anyone's mercy!!)
I assume there isn't an upsizing tool on the planet that will let me do this by clicking a button so can anyone point me in the right direction with regard to something decent that can automate as much as possible. PLUS a good source of information on the differentces between access and SQL so that i can start seeing how to accomplish with SQL what i'd do in Access?
Thanks,
Vince
View 3 Replies
View Related
Oct 29, 2014
What steps do I need to take in order to convert a 2007 database into a 2010 database
View 4 Replies
View Related
Mar 9, 2005
If a company has a hundreds of databases and they want to know which databases have conversin issues such as DAO to ADO conversion because Modules and codes behind the forms refers to DAO code and not to ADO. Is there any tool which can tell this or some other ideas?
View 1 Replies
View Related
Dec 15, 2004
I have few problem with my current Access 2000 application.
I create blank, new Access 2000 and import all objects from my Access 97 instead of going thru conversion process. I have several problems with my current 2000 version. I am new to Access 2000. I'd appreciate any help...
1/ The application once in a while have message "The database is read-only. You can't make any changes to the data-definition of the databases..." when I open it occasionally. Then I can not update or add anything. How do I prevent it from happening??
2/ In Access 2000 all my reports format changed to "portrait" orientation and the margin. So I open exclusively, even after I spent time to change to "landscape" and the margin I desired, saved it . Next time I open, some reports format saved, some change back to "portrait" and margin is 1''. Why don't they saved??
3/ My application is on the network server for multiuser environment. Everytime I click design view of forms, it has message saying "You don't have exclusively open..., so your designed changes may not be saved..." but in Access 97 is OK. How do I turn off that feature?
Thank you.
View 5 Replies
View Related
Apr 30, 2013
What I have now is an excel template (with ~12 worksheets) that many regional offices use to enter in some lease data, from which the excel sheet creates a rental schedule and does a whole ton of calculations on that data. Some are NPV calculations, some are yields etc etc.Eventually, I would like to:
1) Enable users to fill out one of these templates, and save the data to the database (Just the inputs? All the data? My reading suggests just the inputs)
2) Use the database to produce one of these templates for any lease in our system (shouldn't be hard, from what I've read)
3) Sum up calculations from this template for many records (eg. if a tenant has many leases, what is the NPV of all of those leases, or what is the total NPV for all tenants)
I have the inputs (from Access) I will have no problem using them in the excel version, but does it make sense to use Access given that I may need to somehow be switching back and forth to get the info I want for my various reports? I am very comfortable writing macros in VBA for excel, so if that's the solution, that is no problem. I assume what I need for #1 and #2 is a macro to arrange the inputs from the excel sheet into a format that can easily be dropped into access tables and vice versa.
View 6 Replies
View Related
May 29, 2005
Is there any way of converting MS Access Forms(And module behind) to Visual Studio.Net?
I have a pretty comprehensive MS Access DB that has several complex forms. I want to redo this DB App in Visual Studio.Net but don't want to recreate the forms from scratch if there is any way of converting/importing or any shortcuts/tricks to accomplish this.
Thanks in advance for any help!
Mitch
Side note: Anyone ever added credit card billing capabilities to their db? Where to start? (I know.... Post in another thread....)
View 1 Replies
View Related
Feb 16, 2005
Hello,
I have getting type conversion errors for numeric and currency fields when importing an Ecxel spreadsheet into a Table in Access. I have tried changing the data type to text in Excel, and that is what it says I have done when I examine the field formats in question. How can I force this to be text, it keeps reverting,
i.e. the fields in question, to numeric and currency. Can anyone help? Thank you.
Joe
View 4 Replies
View Related
Nov 3, 2005
I'm in the process of migrating my Access database to SQL, but am encountering problems. Firstly when I exported it I discovered that all of my Access queries had been converted to Tables. After deleting these, I attempted to cut and past the SQL code from the Access Queries to SQL's "views", which I had been taught were effectively the same thing.
However, now I come to test them I get an error that says it cannot be displayed because the query is a "view object".
What is happening here, am i doing the correct thing?
Thanks.
View 2 Replies
View Related
Sep 1, 2014
I have thousands of PDFs of which I want to present a number as thumbnails on a form and allow the users to select any one and have the full PDF displayed.
The only way in which I can see this working is to have the thumbnail as a JPG image and set the On Click property to display the relevant PDF. This part is quite simple, the problem I have is converting the existing PDFs to JPGs.
Any way of converting PDFs to JPGs using VBA code?
View 6 Replies
View Related
Jun 10, 2005
I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax?
View 1 Replies
View Related
Nov 18, 2005
I'm imported data from a csv file. The dates stored in there are in a dd-mm-yyyy time format. How can I work with this since Access's date format is just mm/dd/yyyy? I imagine I need to do some sort of conversion? Does Access provide anything for me to do this?
View 6 Replies
View Related
Jan 3, 2006
Does anyone have a Jet to ANSI SQL conversion tool they could either send me or recommend:confused:
View 2 Replies
View Related
Feb 17, 2006
We have an mdb back end on our server with read / write permissions for several approved users. One of them (don't know who yet) has converted the mdb file from 1997 to 2000. Is there a way to undo this? :o (a few have both versions on their machines which is why this was possible to begin to with)
We have had this set up for almost four years now, with no issues might I add but always knew in the back of my mind something like this would happen.
Thanks
View 1 Replies
View Related
Apr 22, 2006
Hello,
Its been a long time since i've been in this forum. I have a question about a conversion error i received not sure whats its about
i'm converting from access 97 to 2000. i ran the access 2000 conversion utility and then the following appeared and the conversion error table
Object TypeObject NameError Description
TableMSysObjects-1611: Could not find field 'Description'.
It looks like the database is fine
View 3 Replies
View Related
Jul 31, 2006
Hi guys, I hope somebody can give me a quick step-by-step.
I've nearly completed a program written in Access and have started to venture into marketing the program to a local company. When asked what other modifications they would like to see i was sent an email stating;
"A major item would be to deploy in MS SQL. You should be able to do that free of charge with the low tier version of SQL."
I had a feeling this would come up, but I don't want to sound like a total idot when talking to these folks... I really have no true understanding of what they are asking, but I suspect it refers to conversion from jet. Question: Is this a reasonably easy modification? What do I need to purchase? Would I be better off telling them the program is 'as-is'? Can this be easily done by someone who has never done it before? I'm sure other threads addressed this issued but I would truly appreciate a full understanding of my specific problem. Thanks, Scott.
View 10 Replies
View Related
Jun 10, 2007
I am in the process of building a table on Access 97 where one column will have a list of various buildings. The problem is I will need to import a spreadsheet from Excel 97 into the Table, and although the spreadsheet will match the Access table in terms of column headings, it's data is numerical ie a number has been assigned for each buliding instead of the building name. I need the Access table to show the building name instead of the number.
Is there a validation rule I could use when creating the Access table where a number will = a specific building name. ie 1= Lunar House 2= Apollo House 3 = Mackenzie House etc. So when it does come to importing my spreadsheet the numbers will show as buildings.
Hope you can help....many thanks
Russell from UK
View 2 Replies
View Related
Jun 10, 2005
I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax?
View 2 Replies
View Related
Sep 6, 2005
I have 2 questions that I think maybe similar.
First Question
When building a Select query through query builder, is there a function or a way I can convert the field, fldWebSite, which is of the datatype Hyperlink to text? The problem I am having is that when I export the results to a csv or txt file, the field instead of saying "www.website.com" turns into "www.website.com#http://www.website.com#"
Second Question
When building a Select query through query builder, How do I convert a field that is of the type currency into a fixed 2 dec. number? Inother words, I get "$1,234,567.00" when what I really want is "1234567.00".
View 1 Replies
View Related
Sep 11, 2006
Hello
I'm trying to convert my exsting LIKE Command to search Contians a word.
Example currently it will search for word starting with word in the search box.
I type in 2006, it will only look for project names starting with 2006.
I would like to Motify the search to "Contain" 2006 in the field anywhere.
Here's the code I like to convert.
"SELECT * FROM [qryProjects]" & "[PROJECT] LIKE """ & Me.txtSearchString2 & "*"" AND "
View 2 Replies
View Related
Jan 12, 2007
I have a time stamp field from an Oracle database that I want to convert to a regular date field in my Access query so that I can pull data from the table base on start and end date.
The time stamp field is formatted as: 09/19/2006 03:16:00 PM
In my query I have tried the following formatting:
1. DateRcvd: Format((Left([time_stamp],10)),"mm/dd/yy")
or
2. DateRcvd: Format([time_stamp],"Short Date")
Without criteria I get all the records in the following format:
1. 09/19/06
2. 9/19/06
Dates in the table are from 06/01/06 to current date 07.
Using the following criteria - I get varing results but never what I want. For example, using format #1, if I enter 09/16/06 and 01/10/07 I get everything for 07 and nothing for 06
If I use format #2, I get everything for 9/16/06 (no other records) and everything for 07
Criteria:
Between [Forms]![frmDateRange]![StartDate] And [Forms]![frmDateRange]![EndDate]
Any suggestions?:confused:
View 5 Replies
View Related
Apr 6, 2007
Hi Guys,
I am using MS Access 2007 and have the following query:
SELECT HoursLostThroughAccident
FROM Accidents
WHERE AccidentDate LIKE ? +'%'
The error I get after selecting values from a drop down list like 2001 or 2002 is:
'Failed to convert parameter values from a string to a datetime'
Is there a way that access converts the values like 2001 to something like
01.01.2001 and the values which have dates that are in the year 2001 will be displayed?
Thanks for any suggestions,
Phil
View 2 Replies
View Related
Sep 18, 2007
I have a table with data in the following format:
OppID Year 1 2 3 4 5 6 7 8 9 10 11 12
1 2007 $1 $2 $1 $3 $2 $3 $1 0 0 $3 $4 $2
I need to convert the data into:
OppID Date Amount
1 1/1/2007 $1
1 2/1/2007 $2
etc.
What is the best approach to complete this conversion 'on the fly', so that as the data is modified in the table, later the user can run a report (PivotTable) that uses the converted data? (Note that the day of the month is not defined, so I plan to assign each the 1st of the month).
Really would appreciate any help you can offer!
View 3 Replies
View Related
Sep 3, 2004
I have this code in an Access97 database that works just fine. But it doesn't like it in Access2003. Any ideas of what the problem is?
Thanks in advance - John
_______________________________________
' this adds date checking
If Not IsNull(Me!StartDate) Then
If ArgCount > 0 Then myCriteria = myCriteria + " AND "
myCriteria = myCriteria + " [Main Table].[Date] >= #" + Me!StartDate + "#"
ArgCount = ArgCount + 1
End If
If Not IsNull(Me!EndDate) Then
If ArgCount > 0 Then myCriteria = myCriteria + " AND "
myCriteria = myCriteria + " [Main Table].[Date] <= #" + Me!EndDate + "#"
ArgCount = ArgCount + 1
End If
View 2 Replies
View Related
