Re: Access To Oracle Program Conversion

Thekla, Thank you for your input. The access database is large as no data is purged due to year end history reasons. It quite often becomes corrupted and have to repair. Moving to an Oracle database would make accessing quicker and would not become corrupted (hopefully). I could create the tables needed, and write all the SQL code. I was just hoping to find a easy way out.

Thanks again

"Thekla Damaschke" <Thekla.Damaschke_at_carmen.se> wrote in message news:3B2D8469.AE8D9D93_at_carmen.se...
> Me wrote:
> >
> > I have an visual basic 6 app that about 15 user's use to enter
 production
> > into an access
> > database. I would like to change this program to use an Oracle database
> > instead. Anyone know the in's and out's of changing from Access to
 Oracle
> > database's ??? Any help would be greatly appreciated. Thanks....
> >
>
> What do you intend to get by changing to Oracle?
> Is the database becoming to big for Access to handle,
> or to slow? Or do you have concurrency issues?
>
> If it is just data size, you can easily use Oracle
> (or any server-based database) as ODBC backend
> to Access, you need not to change to much in your program then.
> I dont see big drawbacks to that, beside the installation and
> administration procedure. At least there must be someone
> at your clients site, who knows what he is doing.
>
> If you want performance, you should think of rewriting your program as
> a stanalone or embedded client, what languages beside VB can you write in?
> Have you any BLOB columns of special types in your db?
> /Thekla

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Jun 18 2001 - 13:37:22 CDT