Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 22nd, 2006, 06:20 AM
Authorized User
 
Join Date: Nov 2005
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default connecting to a remote Access Project Database

1.I have put a Microsoft Access Project database on one computer on our local area network. When I try to access the database on another computer Iam only able to access the forms but not the tables or the data. Please help!!
2. Is it possible to design a payroll system using Microsoft Access If possible I need hints on how to go about it

Bmulenga
__________________
Bmulenga
 
Old August 22nd, 2006, 06:33 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   I think we addressed the first issue before. A MS Access Project database ONLY contains Forms, Reports, Queries, Modules, etc. But Not tables. The tables are on the SQL server. You can't access the adp file and pass through to the SQL server from a remote machine. You need to copy the database front end to each computer that wants to use it. Each computer must also be able to "see" the SQL server - or have the proper DSN. Does that help?

   As for 2, it is possible to do a payroll database in Access. How many employees? If there are not too many, this is easy. I would also probably take lots of back ups of the database, maybe one each pay period. I wouldn't exceed about 2,000 employees.

   To plan it you need to first know what you want to get out of it (reports) and then what you are going to get to put into it (data entry,) and then plan the algorithm to get from input to output. That middle bit is the hard part. How much help do you need?

HTH


mmcdonal
 
Old August 23rd, 2006, 03:48 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Do u have any idea about online tutorials or any ebook on this issue

Learn as you can..
------------------------
pap...
 
Old August 23rd, 2006, 06:18 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I would suggest any beginning book on Access database design. Wrox doesn't have one, but O'Reilly (who has online books) and Microsoft have them. You might also check out generic database design books, and check out the Microsoft Office Developer Center at http://msdn.microsoft.com/office/

Unfortunately, Access does not have a payroll database template built in or online that I can find.

Also, keep us in mind for the bits and pieces as this comes together.

HTH

mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting to a remote database server pratap_routray Oracle 3 October 18th, 2007 08:21 AM
connecting to a remote Access Project Database bright_mulenga Access 2 August 15th, 2006 06:33 AM
Connecting to project MDF SQL Database File nsoivan Crystal Reports 0 July 31st, 2006 05:14 AM
Chapter 5 Connecting to Access Database robodent BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 4 May 11th, 2006 03:32 PM
Remote access to an Access Project Database bright_mulenga Access 0 February 9th, 2006 10:51 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.