Add module to remote access database
I have 100+ access 2000 .mdb's that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend to do this from within...
Answer Question
| Jun 28 2008 5:53 PM GMT
| asked by
Ttstudio
Access, VBA, MDB
limit number of users in access 2003
I converted access 2000 to access 2003 and I did the front end/back end approach. I need to limit the number of users accessing the front end so it doesn't lock up the application and not populate the look up table...I inherited this application
Answer Question
| Jun 16 2008 2:08 PM GMT
| asked by
Herdine
Access 2003, Access 2000
access2k unicode text column even # of bytes error
a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...
Answer Question
| May 13 2008 7:38 PM GMT
| asked by
Santa
Access 2000, Unicode text column error, Data recovery
Save Access 2007 format as 2000 format with VBA
how can i save the curent database as a 2000 format with vba
View Answer
| May 6 2008 10:23 AM GMT
| asked by
Dave b
VBA, Access 2007, Access 2000
How Can i restrict the user to insert next record
Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should pop...
View Answer
| Apr 30 2008 11:23 AM GMT
| asked by
VBAccess
VBA, Access 2000, Microsoft Access
Delete query
Can you help me solve the following problem. Whenever i have an order where the field Audit = True, i will have to delete all the previous orders having the Audit = True. And only when customerid = 121. With other words i have to delete the previous orders having Audit = true but not the last one....
View Answer
| Apr 18 2008 5:53 PM GMT
| asked by
Samotek
Access 2000, Database, DELETE statement
How can i express the percent margin in a query for Microsoft Access?
How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and...
Answer Question
| Feb 27 2008 7:16 AM GMT
| asked by
Peljo
Access 2000, Microsoft Access
How supply password in VBA during CompactOnClose for back-end password-protected db?
Access 2000:Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close.Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link.I have password protected...
View Answer
| Feb 19 2008 9:46 PM GMT
| asked by
Dlc9ball
Microsoft Access, VBA, Access
