Jessica-
Do you still have a way to get to the data in VMS? If there's a way to export the data - even as something like a CSV file - then you can load it into your new Access database.
You don't give many details, but it sounds like you have multiple users for this app. Tell IT you're going to move the data to an SQL Server system they set up for you. They should feel comfortable with that. Then design the front ends in Access using linked tables to SQL Server.
As for upgrading computers - if you use the latest version of Access (2013), your application files should be compatible for at least the next two releases. At some point in the future, you may need to import all your application objects into the a database built using the "current" version of Access, but that's probably 3-5 years down the road.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Aug 29, 2014, at 5:14 PM, Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hello group. Sorry for drawing this problem out. I'm being told that this old database is actually a VMS database, not Access, and VMS is no longer a thing so it can't be converted.?.
In regards to me building a new database in Access to replace the old, IT is concerned that every time we upgrade computers we will have to convert the database to a newer version of Access to make it compatible. Has this ever been an issue for anyone?
I'm not convinced IT's solution is going to work so I will continue to try to build a database (we would like to implement something by Oct 1 for reporting purposes). Heads up, I might be asking for a lot of help as I am an extremely rookie Access user - particulary when it comes to the VBA stuff.
Thanks for your feedback!
Jessica
On Wednesday, August 6, 2014 3:18 PM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
We don't allow attachments bu tI think you can paste an image into the post.
In the mean time, I bet the box is actually a sub form. You can use conditional formatting to change the font color that way. If you make a copy of your database, remove all records from the tables and upload the zipped file to our Files>_AssistanceNeeded folder one of us can convert the DB for you.
Regards,
Bill Mosca
From: "Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, August 6, 2014 12:56:01 PM
Subject: Re: [MS_AccessPros] Old database
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, August 6, 2014 12:56:01 PM
Subject: Re: [MS_AccessPros] Old database
Since I haven't received an answer from IT on moving this old database to a place where I could potentially import it into a newer version, I am going to try to recreate it from scratch. Hopefully I'm not getting in over my head but in any case it will be a learning experience.
Can anyone tell me how the "Type of Crime" box in the attached image might have been created? When I try an option box I can enter only 20 options and it will allow for only one selection. I have a table of Type of Crime options that I tried to use in a combo box, however, as you can see some are displayed in red font and others are not. The combo box won't let me change the font colors for specific items.
Thanks!
Jessica
On Tuesday, July 29, 2014 7:40 PM, "mac ba macba2000id@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
you could export the db ..to ms excel format ,save it, from new computer,import the excel file into new DB
On Wednesday, July 30, 2014 1:19 AM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jessica,
Is the old database on a network drive where a computer with the newer version of Access is installed? If so you can bring in the objects using get external data.
Jim Wagner
________________________________
On Tuesday, July 29, 2014 11:09 AM, "hobackjessica@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
My business has an old MS database stored on an old computer that is remotely accessed by the only user in the department - we just discovered today that it is a MS - database probably 2000(?). The reason it is housed on an old computer in a store room someplace is because IT says the new computers won't support this old database. How would any of you recommend the data in the old database be transferred into a new version that can be used more easily?
Thanks!
Jessica
[Non-text portions of this message have been removed]
Can anyone tell me how the "Type of Crime" box in the attached image might have been created? When I try an option box I can enter only 20 options and it will allow for only one selection. I have a table of Type of Crime options that I tried to use in a combo box, however, as you can see some are displayed in red font and others are not. The combo box won't let me change the font colors for specific items.
Thanks!
Jessica
On Tuesday, July 29, 2014 7:40 PM, "mac ba macba2000id@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
you could export the db ..to ms excel format ,save it, from new computer,import the excel file into new DB
On Wednesday, July 30, 2014 1:19 AM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jessica,
Is the old database on a network drive where a computer with the newer version of Access is installed? If so you can bring in the objects using get external data.
Jim Wagner
________________________________
On Tuesday, July 29, 2014 11:09 AM, "hobackjessica@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
My business has an old MS database stored on an old computer that is remotely accessed by the only user in the department - we just discovered today that it is a MS - database probably 2000(?). The reason it is housed on an old computer in a store room someplace is because IT says the new computers won't support this old database. How would any of you recommend the data in the old database be transferred into a new version that can be used more easily?
Thanks!
Jessica
[Non-text portions of this message have been removed]
__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar