ACCESS FEED: Re: [MS_AccessPros] Old database

Sabtu, 30 Agustus 2014

Re: [MS_AccessPros] Old database

Jessica-

Sure, upload away!

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

http://www.viescas.com/

(Paris, France)

On Aug 30, 2014, at 4:32 PM, Jessica hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

I'm not having any luck getting direct access to the old database. There's really only one user for it and she had to access it by logging in remotely to the old computer it's currently on.

Saving the existing records is no longer a big concern. Right now it still works for her but if she's going to change it needs to happen Oct 1. It is a database of victim assistance records for a police department and she's required to report to the state annually. Annual for her purposes is Oct 1 to Sept 30.

Since it took this long to get any info on converting the old I'm quickly running out of time to learn new MS Access skills. I have a pretty good start I think I just need to figure out how to connect everything - that's my frustration at this point.

I have screen shots of the old database forms saved as a pdf document. Can I upload that to the group for some suggestions?

Thanks!

Jessica

Sent from my Verizon Wireless 4G LTE smartphone

-------- Original message --------

From: "John Viescas JohnV@msn.com [MS_Access_Professionals]"

Date:08/30/2014 6:17 AM (GMT-06:00)

To: MS_Access_Professionals@yahoogroups.com

Subject: Re: [MS_AccessPros] Old database

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

http://www.viescas.com/

(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

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]