Search results

Paul, thanks that sounds great. How do I make a "File DSN on the server and link with that"

I was thinking about making my talbes (5) in SQL and leaving all of my queries, forms, and reports in Access. Is this a bad idea? One guy told me to do ADP, but I just do not have a good feeling about it. If I go ODBC backend do I need to create the ODBC connection on each and every computer?

OK, I can do that. Thank you for the help so far. Which way is "Better"

I have a very large DB. 250MB with 500,000+ records all in Access. I want to convert the backend to SQL. I have around 20 users that access the DB. I want to keep the front end in access because of the amount of queries, forms, reports, macros ect… what is the best way to attack this with SQL...

perfect. That was exactly what I wanted to know. Thanks. Have a good morning.

I am not worried about the read only people right now. Bottom line question: when running a front end and back end DB at what point do you enable record locking on the DB? Do I check record level locking on the frontend dbs or the backend DB?

no log in system. Bottom line should record level locking only be set on the front end systems or the back end db?

access 2000 with 30 users. 10 of which enter info. rest just use for reference. I have all tables on network server all users get a front end access version with all queries, forms, reps, ect. Now I think I need to enable record locking but do not know what to do. Do I enable record level...

funny thing I had never heard of any of that (fe vs be) but that is how I have my system set up. The only thing I see wrong with my set up is I have all of the same queries, forms, and reps in my BACK END too. No one really accesses them, but they are there. funny. The reason I ask to begin...

I have a small access database that my users keep open all day long. Access 2000. I have one primary version of the DB on the network. No one uses it. I have another file on the network that has linked tables to the primary db. I copy a version of this DB to each workstation. So each user...

I have a form that opens at start up with a lot of buttons. Sometimes when you click on a button it will think for a few seconds then close. Then if I open it back up it works fine.

i do not think so. It does it at random times.

I have an access2000 db. Many tables, forms, reps ect... at random times it will just close. Don't know why. No errors, no reason why. It just closes. Is this common and is there any fix?

Access 2000 Tbl_TEMP Tbl_MAIN Frm_ENTRY My user opens frm_ENTRY. Which is pulling data from tbl_TEMP. They clean up a few fields on the form. Then click a button which executes an append query which appends the data to tbl_MAIN. My problem is sometimes when it appends the data it is...

Moniker & Bob THANK YOU for the help. Moniker I went this route: If Mid(Me.SSN,4,1) = "-" and Mid(Me.SSN,7,1) = "-" Then... And it worked great. I can see where ther could be a couple small issues like if they forget a number becuase it is only looking for the mask, but this will catch 99%...

Access 2000 tbl_TESTS (lists all active employees for a company) tbl_RANDOMS (table that lists which employee needs to take a test) [EmpSS] is a social security field in both tables to connect them. I need a form that will allow me to show all active employees from tbl_TESTS and then select the...

Nope did not work. I changed the vb. Found a record that had a 5 digit number I hit the "Accept" button and it acted like the test went through. No errors, no messages. It just brings up the next record. Of course the test does not transfer across. Any other thoughts? Thanks.

It comes in mostly correct, but can be a simple 5 digit number at times. Those few times it is not correct my user needs to change it to a correct format. I will try this to see if it will work. I will let you know.

Big Bob Larson once again coming to the assistance... Private Sub cmdAccept_Click() On Error GoTo err_handler If Me.chkCOMPLETE Then DoCmd.RunCommand acCmdSaveRecord DoCmd.SetWarnings (False) DoCmd.OpenQuery "qry_ESKER_SEND_DATA_TO_TESTS_JUSTIN", acViewNormal Me.Requery...

tbl_TEMP is just general text tbl_TESTS has the mask. I cannot control the data from tbl_TEMP. It is coming from an outside source. I cannot accept it into the system until it is in the proper ss format. So is there anything I can add to the form that looks to make sure that the mask of...