Search results

Tried it. Loved it. You're right again!!!! Thanks

Thanks to my lucky star, I finally was able to build my cooection string with the required parameters. Will go with options 1. And thanks to you!!!!

But isn't this for a local sql server database? Because the link tables menu ask for file emplacement: my is on a remote web server...... I had choose to do the ADP way because the wizard was asking me for all server info and managed somehow to connect me and it works. So after your advices...

Yes, I am working with an ADP indeed. Can somebody give me some clues on the best way to scale back my project to a linked MDB, knowing that I have lots of data already in my tables That I would like to keep(if possible). Thank you.

Hi, Since I upsized my Access database to SQL server. One vital statement is not working anymore: Private Sub Form_Load() Set db = CurrentDb Set rs = db.OpenRecordset("Select * FROM TimeDot where ID = " & EmployeeID) End Sub The statement: Set rs = db.Open......... returns following error...

Ok. But all of those replies don't exactly answer my very question which is: "Can a database(Access or SQL sever) be reachable at the same time and in real time by both a website on a internet server and an MS project on a local server(or PC)." Here is my situation: We have a MS Access project...

Did I mentionned anything about ADP(that I don't even know about!)? I use only a .mdb file. Is it possible to migrate the data part to a remote server(my website server) so I can use my project that is on my PC but connecting to the data remotely?

Hi, I am finishing an Access database for a customer that may want, in a later stage, to have a website(probably ASP) that would connect on the same database. Is that possible? I mean can an Access project on a pc connect to remote database(mdb or SQL server) used by the website? If so can you...

Hi, Given this table(Meetings) EmployeeID Date Hour (Discreet values like: 0900,0945,1030,..... contained in a linked table) In my Mettings entry form, I would like to program a popup in the Hour field to show the available hours(not already taken) for the current employee. Can you give me...