what to use Access database or Access Project?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm new access, need to write a payroll program. what shout i begin with access database or access project ? please advise
 
It really depends on how many users and the size of database..
Using Access Project could be good for the future update but Access Project requires more skill then Access database
Creating Access Project, you need to know SQL (data actually connect to SQL Server/MSDE), Trigger, Stored Procedure, VBA..
if you are new to access, i would like to suggest you to use Access database..

Edmun
MCP - Access and SQL Serve

----- felix wrote: ----

i'm new access, need to write a payroll program. what shout i begin with access database or access project ? please advise
 
For most payroll applications, security is of high importance.
While I have heard that there were significant security concerns with
earlier versions of Access Projects, and frankly don't know what has become
of this issue, in general a SQL database is a much more secure place to have
your data than an Access database.

HTH
= Turtle

felix said:
i'm new access, need to write a payroll program. what shout i begin with
Click to expand...
access database or access project ? please advise
 
how many records can the access database handle compare to access projects, how to get start with SQL server if i only have a small workgroup of computer and don't have a server!!!
 
Access can handle plenty of data. There's not a specific record limit. The
limitation is based on the size of the .mdb file, 1GB or 2GB.

If you installed a version that has Access Projects you already have MSDE
(don't need SQL Server, but can use it if it's available.)
 
Back
Top