SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Access 2007 front end to SS2K8 problem


Access 2007 front end to SS2K8 problem

Author
Message
valeryk2000
valeryk2000
Right there with Babe
Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)

Group: General Forum Members
Points: 721 Visits: 412
May be just make the form invisible before it can be requeried?
WendellB
WendellB
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2080 Visits: 1831
The challenge in doing that is to know that the subform controls are displaying "=deleted" - it's not something I've ever attempted. If you can do that then you could hide the subform control until it has been populated. But that text popping up doesn't trigger an event as far as I know, so there's the problem. You could certainly try putting a bit a code behind the "Before Del Confirm", "On Delete", and "After Del Confirm" to display a simple text box message, but I don't think it will work. I presume you have solved the situation where multiple users were sharing the same database and clobbering the temporary table.

Chris makes an excellent point - with SQL Server tables you want to make sure that the have a default value defined for bit fields, or you will have all sorts of trouble. Another thing you should also do is to give each linked table a TimeStamp field. Access is much happier when you do that - if you don't you tend to get ODBC error messages that another user has edited the record, and your changes cannot be saved.

Wendell

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
valeryk2000
valeryk2000
Right there with Babe
Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)

Group: General Forum Members
Points: 721 Visits: 412
I'll try. Users now use different files. The only case "=deleted " shows up - when user switches to another case and the subform is reloaded.
Thanks
WendellB
WendellB
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2080 Visits: 1831
That is an easier case then as you know you are getting new data, so you can hide the subform control (set the visible property to No), get the data, and then unhide it by setting the Visible property to Yes.

Afterthought - just out of curiosity can you give us a brief idea of what your application is for?

Wendell

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
ProofOfLife
ProofOfLife
SSC Veteran
SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)

Group: General Forum Members
Points: 290 Visits: 9474
Hi

When you say "=deleted" do you mean "#deleted"?

If you do then I think you have an issue with the primary key on one or more of your tables. One of the common causes of this is the use of the bigint data type for your primary key.

Cheers
valeryk2000
valeryk2000
Right there with Babe
Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)

Group: General Forum Members
Points: 721 Visits: 412
[b]

Afterthought - just out of curiosity can you give us a brief idea of what your application is for?

Wendell

This is an application with sensitive patient and doctor information. They created an Access database 4 years ago and were constantly updating since then. It has a lot of forms, subforms, reports and subreports. At some moment it occured to the management that the data is not safe in Access. So they told me to transfer the data to SQL Server ... but keep the Access front end intact (I tried to suggest that VB, Java or Web front end would be much better - no way, management was very conservative). SQL statements on the front end would use real table names (as well as linked tables app) with a posibility to read or affect a back end data by a "unauthorized user". So I moved all logics (select, update, delete, etc) to the back end in stored procedures and triggers.
This is a sad story in short
condolences are accepted around the clock 24/7 :-(
Thanks
WendellB
WendellB
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2080 Visits: 1831
I should say! Extended condolences are definitely in order. Crying

There's a common misperception that Access is an insecure system that is also unreliable. As long as you use the .mdb format, you have Access User Security. That feature can be used to manage what various users are permitted to see and do. If you are using an Access back-end for data storage, then there are issues with reliability and with the possibility of theft or loss of the data. But once you put that data into SQL Server on a physically secured server, then an Access front-end provides the fastest development path to a feature rich user interface. With a compiled and properly secured front-end your data is as secure as with any other system.

My prescription for a frazzled and frustrated developer would be a nice long holiday weekend like we are having here, but on a beach or along a quiet mountain brook. (Bad planning on our part to be cutting over a new client this weekend. :crazySmile Hopefully your situation is beginning to settle down and behave as it should, and things will get better.

Wendell
Evergreen, CO
http://www.glmms.com

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
valeryk2000
valeryk2000
Right there with Babe
Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)

Group: General Forum Members
Points: 721 Visits: 412

With a compiled and properly secured front-end your data is as secure as with any other system.

Compiled - is a key word. Our current wersion is not compiled - simple mdb. That's why all logics is hidden in SQL stored procedures that are called from the front end
==================

Thank you. We have a lot of rain on the East Coast of the country. So ... I enjoy fixing holes in my apps
valeryk2000
valeryk2000
Right there with Babe
Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)

Group: General Forum Members
Points: 721 Visits: 412


When you say "=deleted" do you mean "#deleted"?



Certainly "#deleted". Thank you
sdhanpaul
sdhanpaul
SSC-Enthusiastic
SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)

Group: General Forum Members
Points: 107 Visits: 566
WendellB (9/3/2012)

There's a common misperception that Access is an insecure system that is also unreliable. As long as you use the .mdb format, you have Access User Security.
Wendell
Evergreen, CO
http://www.glmms.com


ah, i have a file..no installation require that I use to get mdb passwords...sorry but its security is crap.

I have a pretty good security procedure working for me right now with them though...anyways...this topic is not abt security...


to the original poster...i noticed your first post is that the user sits and does nothing then suddenly its "=deleted"

i think your connection timed out.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search