Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 10th, 2004, 03:56 PM
Authorized User
 
Join Date: Apr 2004
Location: Montreal, Quebec, Canada.
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to lguzman
Default How to access Simply Accounting fields from Access

We use Simply Accounting at our company. Lots of the information we need to manage day to day operations is already in the Simply Accounting data files. Such as prices. Is there a way I can retrieve that information from Simply Accounting an use it in Ms-Access.

In other words is there a way I can link Simply Accounting tables to my Ms-Access application?

Thanks.


[LGuzman]
__________________
[LGuzman]
Reply With Quote
  #2 (permalink)  
Old September 10th, 2004, 07:52 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: South San Francisco, CA, USA.
Posts: 128
Thanks: 0
Thanked 1 Time in 1 Post
Default

I have a question, what DBMS (Database Management System ex. MySQL, Access, MS SQL, Oracle, Sybase) is Simply Accounting or is this a database?

When you say data files are those text files? meaning is the file extension .txt

Because if this is a DBMS you can link to your Access by ODBC (object database connection).



Reply With Quote
  #3 (permalink)  
Old September 16th, 2004, 08:36 AM
Authorized User
 
Join Date: Apr 2004
Location: Montreal, Quebec, Canada.
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to lguzman
Default

First let me thank you for having taken the time to answer me.
Second, I apologize for not having answered your post earlier.

I have been looking into your suggestion but I keep running into walls... The data files are of extension .SDB. I have tried researching what creates these files but have found no valuable information. I do think it must be a database management system but don't know which and what drivers to use in ODBC. (Which is another challenge for me since I have never used it).

Once again: thanks.



[LGuzman]
Reply With Quote
  #4 (permalink)  
Old September 16th, 2004, 09:12 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: South San Francisco, CA, USA.
Posts: 128
Thanks: 0
Thanked 1 Time in 1 Post
Default

Luis,
Talk to your IT administrator and ask how you can have a link via ODBC connection from this main-frame server to your microsoft access database. That way you can retrieve data thru MS Access application.

John


Reply With Quote
  #5 (permalink)  
Old September 16th, 2004, 02:55 PM
Authorized User
 
Join Date: Apr 2004
Location: Montreal, Quebec, Canada.
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to lguzman
Default

Thanks for your suggestion John.

However I would like to point out that these files (.sdb) are not on a main-frame but reside locally on the same PC where I have my Ms-Access application.



[LGuzman]
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access database fields with SQLDataSource hastikeyvan ASP.NET 3.5 Basics 0 April 21st, 2008 01:10 AM
DIRECT ACCESS TO DATASET FIELDS kostaskon Pro VB Databases 0 February 27th, 2008 12:54 PM
using apostrophe in Access string fields badgolfer VB Databases Basics 1 July 15th, 2005 12:47 AM
Access long text fields Tharkun SQL Server ASP 2 October 30th, 2003 08:47 AM
Using a datagrid with Access D/B Time fields rosenzl VS.NET 2002/2003 1 June 22nd, 2003 04:14 AM



All times are GMT -4. The time now is 01:24 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.