Search results

Hi guys, I'm now using MS SQL 2008 R2. I need some help now with the connection of the front end, i've tried dsn, dsn less and connection string in a file, the problem is when i close the DB and open it again the tables are not linked to the backend. Can someone help on that? thanks

Yes client instalation is out of question as there are too many workstations with limited premissions and they change frequently. I'll have a look at SQL Express. Always thougt MySQL whould be better and also i've been using it for a long time for the web. Tks for your help

So thers no way to achive this whithout installing the ODBC driver in each workstation right? well i guess i'll have to stay with access back end, or develop a web based front end.

I'm familiar with DSN-Less connections. So using this file i whouldn't need to install Mysql ODBC in every workstation? that's my goal. Can someone point me in the right way to make this file? Should i configure a DSN in the server and put the DSN name on the file?

That whould be perfect. A file with Dns-less? can you post an example? And how do I select the file inside acess. Tks

Hi! I was using a front end/back end in access over a network, around 100 users conected to the same access back end, each one wtih a copy of the front end localy. Now ive started to migrate the back end to Mysql, it's all set up, i connected the front end trough ODBC all works well on my...

no use for stLinkCriteria, i've removed it. Well i'm about to give up, dont know what else to do. i'm using a diferent code still when i put it to test sometimes users get the same record, how can this happen? MS selects the record in the exact same second as the next user? i tought woking...

this is the code i'm using now: Private Sub Command143_Click() Dim db As Database Set db = CurrentDb Dim rs As Recordset Set rs = db.OpenRecordset("Select * From report where isnull(userdone) and isnull(userlock) and type ='type1' ORDER BY id", dbOpenDynaset) If rs.EOF Then MsgBox ("No...

well with either your code or mine the problem still happens users still get the same record to edit sometimes. any ideas why?

tks for the replay, you say to use this line where id = '" & strID & "' and isnull(userlock)" so this means i have to select the id to be locked first right? so its the same as my code: Set rs = db.OpenRecordset("Select * From report where locked=FALSE AND isnull(userdone) and...

tks for the replay, you say to use this line where id = '" & strID & "' and isnull(userlock)" so this means i have to select the id to be locked first right? so its the same as my code: Set rs = db.OpenRecordset("Select * From report where locked=FALSE AND isnull(userdone) and...

here's my problem: I have an access db that is used by aprox 20 users, this db is devided in FE and BE each user has his own copy of the FE. The idea of this DB is that each user can work records from a table, so a user will open the db and get a record, finish working with it and get a new...

ok, so with this splitt do you think ill be able to use DoCmd.GoToRecord , , acNewRec wothout problems? i still don't get whit the DB works with DoCmd.Close DoCmd.OpenForm and crash with DoCmd.GoToRecord , , acNewRec

no. i have one mdb file in a shared folder that everyone use

Hi! i have an access database where users use a form to input data into the DB. when a user insert a new record after some validation the code i use to move to the new record is: DoCmd.GoToRecord , , acNewRec this works fine whith a single user, but when more users start to use the same form...