Search results

Ensure the FE is deployed locally on each user's local PC – and the BE resides on a windows platform.

http://www.webthang.co.uk/Tuts/tuts_dmx/dmxf_1/dmx1_1.asp

From the VBA Editor open the Reference window (Tools > References from the menubar). - Remove one of the checked references - Decompile the application - http://www.fmsinc.com/free/newtips/access/accesstip7.asp - Recheck the reference ONLY if it is needed to compile. Repeat these steps for...

The best way to enable MS Access for a multi-user environment is to split the db into a FE/BE and deploy the FE on each user’s local PC.

You need to split the db and place the FE on each user’s local PC. http://www.myaccesstips.com/deploy/deploy.html Design change and action queries will create bloat.

Split the db and give each user their own copy of the FE. http://www.myaccesstips.com/deploy/deploy.html

Check out: http://www.myaccesstips.com/deploy/deploy.html

Check out: http://www.granite.ab.ca/access/corruptmdbs.htm

Check out: FTP function

Jeff just accepted a job with Microsoft on the Access Team. His new title is Software Development Engineer in Test. Also, the book he co-authored will be available in a few days. Access Inside Out

My suggestions: 1 - Decompile to avoid corruptions http://www.fmsinc.com/free/newtips/access/accesstip7.asp 2 - Create an MDE file for the FE 3 - Deploy the FE to each user’s local PC. http://www.myaccesstips.com/deploy/deploy.html

You are welcome – glad I could assist.

Try to compact and repair the database. If you still have issues try: http://www.fmsinc.com/free/newtips/access/accesstip7.asp then try: Try these commands from the immediate window (ctrl + G: saveastext acForm,"Form Name", "C:\frm.txt" Rename your existing report then run this command...

Is the main form being opened as read-only?

This is a good starter site: http://www.w3schools.com/asp/default.asp

You need to add the object library to your references. Open any module (code). From the VBA editor’s menubar select Tools > References. Scroll down to you find the Microsoft DAO 3.x object library. Check the checkbox, and then select OK. Select Debug > Compile from the menubar to recompile...

The link I posted provides detailed documentation on sharing the db over a network. You don’t need MSDE or ODBC. The BE is placed on the server, the FE on each PC.

you will need to split the database. http://www.myaccesstips.com/deploy/deploy.html

Try adding the Option Explicit statement to the module and declare all the variables. Dim Counter As Long Dim fldCurr As Field A more efficient method of exporting the data to excel would be to create a query and export the query. Running an update query and deleting table will cause database...

You have an extra semilcolon - take the one out on the from line. strSql = "SELECT tblEmployees.[strAccess]" & _ "FROM tblEmployees " & _ "where tblEmployees.[lngEmpID]='" & Me.cboEmployee.Value & "';"