×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

link to RES 3700 version 5.7 tables with MS Access.

link to RES 3700 version 5.7 tables with MS Access.

link to RES 3700 version 5.7 tables with MS Access.

(OP)
thread693-1726185: Micros POS - Connect to db

I will be getting a new license with Micros Server. I am told that it is Version 5.7

I want to access the Menuitem definition table, the employee definition table and the daily sales tables. I am running current version of Access. Currently I download the CSV text files from my Old Micros system 2700. I then append these txt records into Access tables. I also create and upload to the Micros 2700 Menuitem definitions and employee definitions as needed throughout the month using a CSV text file which is created automatically in Access.

When I enter into the current century with my POS and my database back of the house, I would like to have direct access, or "live" access, to the POS tables. It would make download and upload failures minimized.

I understand that Sybase Central is installed in Micros software and apparently it will provide me with sql access to the tables.

My question: Will I be able to Link to the Micros tables so that I may use my Access for queries, forms, reports, macros, etc? I see that Access has wizards in the External Data dialog "New Source Data" which can be directed to other external sources such as "OBDC" and "SQL Server".

Will Micros server allow this link? Can it be this simple?

Please give me some heads up.

Micros Vendor has told me that they can take me only so far. There response to my inquiry is "Sybase central comes with RES 3700 and installs automatically as part of the installation process, our programmers can show you how to access Sybase central but that would be about the limitations of their knowledge in that area."

I have read some posts reqarding this situation and especially appreciate the no-nonsense comments from "pemegans".

Cheers. Gary

RE: link to RES 3700 version 5.7 tables with MS Access.

Accessing the database for input into access, excel is pretty straightforward. You will need to setup odbc to the database with a database user and password.
Trying to put information back into the database this way is not typically easy.

RE: link to RES 3700 version 5.7 tables with MS Access.

(OP)
Thanks Wildbar,

I am trying to get a better understanding before going forward with Micros.

In Access, I use two database files. One in which my tables reside. This is the Back End. The second database file, On the Front End, I have Forms,etc. In the Wizard for the external data in the front end database file, I link to the access tables in the back end. This is probably obvious and simple for you.. However, by stating this, it helps me to get to my point.

In that wizard, it appears that I can Link to an OBDC table in the same way. Are you saying that the "linked" Micros tables may only allow reference to the value and not editing ability?

Thanks for your response,

Gary

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close