Hello, Can anybody help me with

[min460120]

Hello,

Can anybody help me with the following questions:

1. How many rows can have in a Access table?
2. Will it have locking issue if multiple users want
to insert data into Access table in the same
time?
3. If it is possible to set up a timer in Access to delete
the whole data from a table at certain time in daily
basis?

Thank you

 

[hsitz]

(1) So far as I know, there is no limitation on rows. Rather the limitation is on the amount of data that can be held in a single database. A single database be up to 2GB in size.

(2) Access will handle locking for you. You will generally not experience locking issues if users are editing different records. You will, as you should, if two users are trying to edit the same record at the same time, but this will just bring up a dialog box to help you resolve the conflict.

(3) I'm sure this can be done. Access forms have a 'TimerInterval' property that can a macro or VBA code to run at regular intervals. If you use VBA code you could set it to delete data if the VBA code is called when the time is, say, between 2:00 am and 2:01 am. (You'd want to have the timer interval set to less than 60 seconds for that.) The database and the form with the timer event would have to be open for this to work. (I'm not sure whether there is also a general timer interval event for the database itself; I don't think so.)

-- Herb

 

[svanels]

As long you have 2 or 3 users on access, you probably won't have network related problems, but keep in mind that access is a desktop database, for true multi-users systems databases as sql-server, oracle, interbase are used which are designed handele multiple transactions across a network.

Regards S. van Els
SAvanEls@cq-link.sr

 

[PaulF]

Just some additional info, Access 97 Locks in Blocks, not just that Record, this is from the Help File:

Edited Records - Microsoft Access locks the record you're editing, so no other user can change it. It might also lock other records that are stored nearby on your disk. If another user tries to edit a record that you've locked, Microsoft Access displays the locked record indicator in the other user's datasheet. This strategy ensures that you can always finish making changes that you start. It is a good choice if you don't have editing conflicts often.

Access 2K is the same. The do have Row Locking, or one record at a time, but this is disabled if you use a shortcut to access the database, which most people do.

As far as the sheduled delete... If you have a Task Scheduler on your Network, you can create a task to open a different database, where you can either write code to delete the data in the tables of the other database, or you can Link to them, and perform Delete Queries. Just be sure you do this at a time when no one else has access to the data, and then you might consider also performing a Compact of that database, to reduce the File Size bloating associated with Access databases.

2Gig is the Limit in Access 2K, 1Gig is the Limit in Access 97, but you can get around this by keeping Tables in different databases, and Linking to the Tables, instead of storing them all in one database.

Just adding my 2 cents worth.
PaulF