(UTC)
  Lantica User Forum › Not About Lantica or Sesame › Not About Sesame But Not Off In The Weeds › advice regarding a microsoft access to Sesame
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic advice regarding a microsoft access to Sesame (Read 1609 times)
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
advice regarding a microsoft access to Sesame
Jul 12th, 2012 at 7:19pm
Print Post Print Post  
I am looking for some advice and thoughts from you fine people regarding dealing with a microsoft access database.

I have received  2 microsoft access files Oe_mdb and Oe_Be.mdb

I was told all the data is in the file ending in BE(for back end)and that I will have to relink the tables to the BE if I want to use the system as is.

My question is first if I want to convert this to a sesame app do I need to create an app first and then relink the mdb and then export the data and then import into sesame?
or
is there a method to get some of the existing app created into a sesame app and then modify it?

If I need to start from scratch I will need to understand the old access database. Is re-linking something fairly simple or am I best off paying someone that knows what they are doing? What is a fair price to pay to have someone relink this data?

Thanks
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: advice regarding a microsoft access to Sesame
Reply #1 - Jul 12th, 2012 at 7:26pm
Print Post Print Post  
If you open the mdbs, you are going to find that Oe has all the forms and reports and suchlike. Oe_BE has nothing but tables populated with data. This is a common way to partition Access systems.

Oe has already been linked to Oe_BE, but since you moved the files, OE needs to be told where Oe_BE is. This is really easy.

On the External Data tab, choose Linked Table Manager. You can probably figure it out from there.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: advice regarding a microsoft access to Sesame
Reply #2 - Jul 12th, 2012 at 8:20pm
Print Post Print Post  
Wow, even great customer service on non Sesame products.

Your directions got me linked and into the Access database so I am able to see what it does.

Now to learn enough about the database to create what is needed in Sesame.

Thank you so much for the help.

You really are the greatest.
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: advice regarding a microsoft access to Sesame
Reply #3 - Jul 12th, 2012 at 9:59pm
Print Post Print Post  
Glad to help, Robert. I know my way around Access pretty well, so let me know if you need anything else.  If there's VBA in there that you don't understand, post it here and I can tell you what it does.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge