Search results

Since I'm new to Sql Server, I still have some fundamental questions I'm trying to resolve. I would like to build a database using Windows Forms as my front-end using VB2005, SQL Server 2005 Express as my back-end and then run reports with Access through OBDC. Is this good thinking or am I off...

I attempting to make the change to a sql server 2005 express be linked to an Access2003 fe. I have created the tables in sql server 2005 and linked to them in Access through ODBC. My question is can I create a stored procedure in access or can I copy a select access query and paste it to sql...

I am still a bit confused about the system.mdw file. I create FE and BE on my local computer and change name of system.mdw to say Jobs.mdw, after backing up system.mdw I then join jobs.mdw with my jobs FE and jobs BE and set secutity settings, etc. I then place FE, BE and Jobs.mdw all in the...

I have an Access 2000 split into FE and BE and the client has requested the BE be password protected. I attempt set database password on BE but then when I open FE I get error msg " not a valid password". I get the same error message if FE has same password or if FE has no password. Any ideas...

I added one text field to my table underlying a form and now I cannot enter data to the form without an error message 3164 which states the control is locked. I click OK and then I can enter data as normal. I have locked nothing and looked at every possible thing I can think of and I cannot find...

I added one text field to my table underlying a form and now I cannot enter data to the form without an error message 3164 which states the control is locked. I click OK and then I can enter data as normal. I have locked nothing and looked at every possible thing I can think of and I cannot find...

I understand how to use grouping but I need to place two fields within the same group to enhance readability. But, of course, one field repeats. Is there any way to have that field show only one time. Thanks. Regards, Jim

I am really confused. I created a database in Access 2000, split it and then upsized the backend to MSDE, and linked to the upsized tables. The linked tables now show a globe icon next to them. Also, local tables were created on the backend. I will be putting the backend on a NT server and the...